Azure TableStore MCP Server
@dkmaker
A MCP Server to query a Azure Table Storage for local development
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.,
Orderstable) - 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.