Cover image
Try Now
2024-12-23

Ein MCP -Server zum Abfragen eines Azure -Tabellenspeichers für die lokale Entwicklung

3 years

Works with Finder

1

Github Watches

4

Github Forks

5

Github Stars

Azure TableStore MCP Server

License: MIT

A TypeScript-based MCP server that enables interaction with Azure Table Storage directly through Cline. This tool allows you to query and manage data in Azure Storage Tables.

mcp-azure-tablestorage MCP server

Features

  • Query Azure Storage Tables with OData filter support
  • Get table schemas to understand data structure
  • List all tables in the storage account
  • Detailed error handling and response information
  • Simple configuration through connection string

Installation

Local Development Setup

  1. Clone the repository:
git clone https://github.com/dkmaker/mcp-azure-tablestorage.git
cd mcp-azure-tablestorage
  1. Install dependencies:
npm install
  1. Build the server:
npm run build

NPM Installation

You can install the package globally via npm:

npm install -g dkmaker-mcp-server-tablestore

Or run it directly with npx:

npx dkmaker-mcp-server-tablestore

Note: When using npx or global installation, you'll still need to configure the AZURE_STORAGE_CONNECTION_STRING environment variable.

Installing in Cline

To use the Azure TableStore server with Cline, you need to add it to your MCP settings configuration. The configuration file is located at:

Windows: %APPDATA%\Code\User\globalStorage\saoudrizwan.claude-dev\settings\cline_mcp_settings.json

Add the following to your configuration:

{
  "mcpServers": {
    "tablestore": {
      "command": "node",
      "args": ["C:/path/to/your/mcp-azure-tablestorage/build/index.js"],
      "env": {
        "AZURE_STORAGE_CONNECTION_STRING": "your_connection_string_here"  // Required: Your Azure Storage connection string
      }
    }
  }
}

Replace C:/path/to/your/mcp-azure-tablestorage with the actual path where you cloned the repository.

Configuration

The server requires the following environment variable:

  • AZURE_STORAGE_CONNECTION_STRING: Your Azure Storage account connection string

Usage in Cline

⚠️ IMPORTANT SAFETY NOTE: The query_table tool returns a limited subset of results (default: 5 items) to protect the LLM's context window. DO NOT increase this limit unless explicitly confirmed by the user, as larger result sets can overwhelm the context window.

Once installed, you can use the Azure TableStore server through Cline. Here are some examples:

  1. Querying a table:
Query the Users table where PartitionKey is 'ACTIVE'

Cline will use the query_table tool with:

{
  "tableName": "Users",
  "filter": "PartitionKey eq 'ACTIVE'",
  "limit": 5  // Optional: Defaults to 5 items. WARNING: Do not increase without user confirmation
}

The response will include:

  • Total number of items that match the query (without limit)
  • Limited subset of items (default 5) for safe LLM processing
  • Applied limit value

For example:

{
  "totalItems": 25,
  "limit": 5,
  "items": [
    // First 5 matching items
  ]
}

This design allows the LLM to understand the full scope of the data while working with a manageable subset. The default limit of 5 items protects against overwhelming the LLM's context window - this limit should only be increased when explicitly confirmed by the user.

  1. Getting table schema:
Show me the schema for the Orders table

Cline will use the get_table_schema tool with:

{
  "tableName": "Orders"
}
  1. Listing tables:
List all tables in the storage account

Cline will use the list_tables tool with:

{}

Project Structure

  • src/index.ts: Main server implementation with Azure Table Storage interaction logic
  • build/: Compiled JavaScript output
  • package.json: Project dependencies and scripts

Dependencies

  • @azure/data-tables: Azure Table Storage client library
  • @modelcontextprotocol/sdk: MCP server implementation toolkit

License

This project is licensed under the MIT License - see the LICENSE file for details. This means you can use, modify, distribute, and sublicense the code freely, provided you include the original copyright notice and license terms.

相关推荐

  • NiKole Maxwell
  • I craft unique cereal names, stories, and ridiculously cute Cereal Baby images.

  • Andris Teikmanis
  • Latvian GPT assistant for developing GPT applications

  • Joshua Armstrong
  • Confidential guide on numerology and astrology, based of GG33 Public information

  • https://suefel.com
  • Latest advice and best practices for custom GPT development.

  • Callycode Limited
  • A geek-themed horoscope generator blending Bitcoin prices, tech jargon, and astrological whimsy.

  • Emmet Halm
  • Converts Figma frames into front-end code for various mobile frameworks.

  • Jan Meindl
  • Builds new GPTs

  • XLwebDev.com
  • PR Professional: Guiding You to Get Media Placements and Publicity Quickly and Effectively

  • Beniyam Berhanu
  • Therapist adept at identifying core issues and offering practical advice with images.

  • https://cantaspinar.com
  • Summarizes videos and answers related questions.

  • apappascs
  • Entdecken Sie die umfassendste und aktuellste Sammlung von MCP-Servern auf dem Markt. Dieses Repository dient als zentraler Hub und bietet einen umfangreichen Katalog von Open-Source- und Proprietary MCP-Servern mit Funktionen, Dokumentationslinks und Mitwirkenden.

  • OffchainLabs
  • GO -Umsetzung des Ethereum -Beweises des Anteils

  • huahuayu
  • Ein einheitliches API-Gateway zur Integration mehrerer Ethercan-ähnlicher Blockchain-Explorer-APIs mit Modellkontextprotokoll (MCP) für AI-Assistenten.

  • deemkeen
  • Steuern Sie Ihren MBOT2 mit einer Power Combo: MQTT+MCP+LLM

  • zhaoyunxing92
  • 本项目是一个钉钉 MCP (Message Connector Protocol )服务 , 提供了与钉钉企业应用交互的 api 接口。项目基于 Go 语言开发 , 支持员工信息查询和消息发送等功能。

  • pontusab
  • Die Cursor & Windsurf -Community finden Regeln und MCPs

    Reviews

    5 (1)
    Avatar
    user_BHt3HDHi
    2025-04-15

    The Remote MCP Server on Cloudflare, created by majie1993, is an exceptional product for managing remote servers. It is highly reliable and user-friendly, making server management seamless and efficient. I highly recommend it for anyone in need of robust server management solutions. For more details, check out the product at https://mcp.so/server/remote-mcp-server/majie1993.