MCP.so
Sign In

Azure TableStore MCP Server

@dkmaker

About Azure TableStore MCP Server

A MCP Server to query a Azure Table Storage for local development

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "mcp-azure-tablestorage": {
      "command": "npx",
      "args": [
        "dkmaker-mcp-server-tablestore"
      ]
    }
  }
}

Tools

3

⚠️ WARNING: This 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. Query data from an Azure Storage Table with optional filters. Supported OData Filter Examples: 1. Simple equality: filter: "PartitionKey eq 'COURSE'" filter: "email eq '[email protected]'" 2. Compound conditions: filter: "PartitionKey eq 'USER' and email eq '[email protected]'" filter: "PartitionKey eq 'COURSE' and title eq 'GDPR Training'" 3. Numeric comparisons: filter: "age gt 25" filter: "costPrice le 100" 4. Date comparisons (ISO 8601 format): filter: "createdDate gt datetime'2023-01-01T00:00:00Z'" filter: "timestamp lt datetime'2024-12-31T23:59:59Z'" Supported Operators: - eq: Equal - ne: Not equal - gt: Greater than - ge: Greater than or equal - lt: Less than - le: Less than or equal - and: Logical and - or: Logical or - not: Logical not

Get property names and types from a table

List all tables in the storage account

Overview

What is Azure TableStore MCP Server?

A TypeScript-based MCP server that enables interaction with Azure Table Storage directly through Cline, allowing querying and managing data in Azure Storage Tables.

How to use Azure TableStore MCP Server?

Install globally via npm (npm install -g dkmaker-mcp-server-tablestore) or run with npx dkmaker-mcp-server-tablestore. Configure the AZURE_STORAGE_CONNECTION_STRING environment variable. Add the server to Cline’s MCP settings JSON file with the command, path to the built index.js, and the connection string.

Key features of Azure TableStore MCP Server

  • 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 a connection string

Use cases of Azure TableStore MCP Server

  • Query a table with filters (e.g., PartitionKey eq 'ACTIVE') and view a limited subset of results
  • Retrieve the schema of a specific table (e.g., Orders table)
  • Enumerate all tables present in the storage account
  • Understand data scope while processing a safe, manageable subset

FAQ from Azure TableStore MCP Server

What does the server do?

It provides an MCP interface to interact with Azure Table Storage, supporting querying, schema retrieval, and table listing through Cline.

How do I install and configure it?

Install via npm globally or use npx. You must set the AZURE_STORAGE_CONNECTION_STRING environment variable and add the server’s configuration to Cline’s MCP settings file.

What is the default result limit and why?

The query_table tool returns a default limit of 5 items to protect the LLM’s context window. Do not increase this limit unless explicitly confirmed by the user.

What dependencies does the server require?

It uses @azure/data-tables for Azure Table Storage interaction and @modelcontextprotocol/sdk for MCP server implementation.

Frequently asked questions

What does the server do?

It provides an MCP interface to interact with Azure Table Storage, supporting querying, schema retrieval, and table listing through Cline.

How do I install and configure it?

Install via npm globally or use npx. You must set the `AZURE_STORAGE_CONNECTION_STRING` environment variable and add the server’s configuration to Cline’s MCP settings file.

What is the default result limit and why?

The `query_table` tool returns a default limit of 5 items to protect the LLM’s context window. Do not increase this limit unless explicitly confirmed by the user.

What dependencies does the server require?

It uses `@azure/data-tables` for Azure Table Storage interaction and `@modelcontextprotocol/sdk` for MCP server implementation.

Comments

More Cloud & Infrastructure MCP servers