mcp-azure-tablestorage
Azure TableStore MCP 서버
Cline을 통해 Azure Table Storage와 직접 상호 작용할 수 있는 TypeScript 기반 MCP 서버입니다. 이 도구를 사용하면 Azure Storage Tables의 데이터를 쿼리하고 관리할 수 있습니다.
특징
OData 필터 지원을 사용하여 Azure Storage 테이블 쿼리
데이터 구조를 이해하기 위한 테이블 스키마 가져오기
스토리지 계정의 모든 테이블 나열
자세한 오류 처리 및 응답 정보
연결 문자열을 통한 간단한 구성
Related MCP server: Azure Omni-Tool MCP Server
설치
지역 개발 설정
저장소를 복제합니다.
지엑스피1
종속성 설치:
npm install서버를 빌드하세요:
npm run buildNPM 설치
npm을 통해 패키지를 전역적으로 설치할 수 있습니다.
npm install -g dkmaker-mcp-server-tablestore또는 npx로 직접 실행하세요.
npx dkmaker-mcp-server-tablestore참고: npx 또는 글로벌 설치를 사용하는 경우에도 AZURE_STORAGE_CONNECTION_STRING 환경 변수를 구성해야 합니다.
클라인에 설치
Cline에서 Azure TableStore 서버를 사용하려면 MCP 설정 구성에 해당 서버를 추가해야 합니다. 구성 파일은 다음 위치에 있습니다.
Windows: %APPDATA%\Code\User\globalStorage\saoudrizwan.claude-dev\settings\cline_mcp_settings.json
구성에 다음을 추가하세요.
{
"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
}
}
}
}C:/path/to/your/mcp-azure-tablestorage 리포지토리를 복제한 실제 경로로 바꾸세요.
구성
서버에는 다음 환경 변수가 필요합니다.
AZURE_STORAGE_CONNECTION_STRING: Azure Storage 계정 연결 문자열
클라인에서의 사용법
⚠️ 중요 안전 참고 사항 : query_table 도구는 LLM의 컨텍스트 창을 보호하기 위해 제한된 결과 하위 집합(기본값: 5개 항목)을 반환합니다. 사용자가 명시적으로 확인하지 않는 한 이 제한을 늘리지 마십시오. 결과 집합이 커지면 컨텍스트 창이 과부하될 수 있습니다.
설치가 완료되면 Cline을 통해 Azure TableStore 서버를 사용할 수 있습니다. 다음은 몇 가지 예입니다.
테이블 쿼리:
Query the Users table where PartitionKey is 'ACTIVE'Cline은 다음과 같이 query_table 도구를 사용합니다.
{
"tableName": "Users",
"filter": "PartitionKey eq 'ACTIVE'",
"limit": 5 // Optional: Defaults to 5 items. WARNING: Do not increase without user confirmation
}응답에는 다음이 포함됩니다.
쿼리와 일치하는 항목의 총 수(제한 없음)
안전한 LLM 처리를 위한 제한된 항목 하위 집합(기본값 5개)
적용된 한계값
예를 들어:
{
"totalItems": 25,
"limit": 5,
"items": [
// First 5 matching items
]
}이러한 설계를 통해 LLM은 관리 가능한 하위 집합으로 작업하는 동시에 데이터의 전체 범위를 파악할 수 있습니다. 5개 항목의 기본 제한은 LLM의 컨텍스트 창에 과부하가 걸리는 것을 방지합니다. 이 제한은 사용자가 명시적으로 확인하는 경우에만 늘려야 합니다.
테이블 스키마 가져오기:
Show me the schema for the Orders tableCline은 다음과 함께 get_table_schema 도구를 사용합니다.
{
"tableName": "Orders"
}테이블 목록:
List all tables in the storage accountCline은 다음과 같이 list_tables 도구를 사용합니다.
{}프로젝트 구조
src/index.ts: Azure Table Storage 상호 작용 논리를 사용한 메인 서버 구현build/: 컴파일된 JavaScript 출력package.json: 프로젝트 종속성 및 스크립트
종속성
@azure/data-tables: Azure Table Storage 클라이언트 라이브러리
@modelcontextprotocol/sdk: MCP 서버 구현 툴킷
특허
이 프로젝트는 MIT 라이선스에 따라 라이선스가 부여됩니다. 자세한 내용은 라이선스 파일을 참조하세요. 즉, 원본 저작권 고지 및 라이선스 조건을 명시하는 한 코드를 자유롭게 사용, 수정, 배포 및 재라이선스할 수 있습니다.
Available Tools
3 toolsget_table_schemaC
Get property names and types from a table
| Name | Required | Description | Default |
|---|---|---|---|
| tableName | Yes | Name of the table to analyze |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
With no annotations provided, the description carries the full burden of behavioral disclosure. It states a read operation ('Get'), implying it is likely non-destructive, but does not address permissions, rate limits, error handling, or output format. This leaves significant gaps in understanding how the tool behaves beyond its basic function.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is a single, efficient sentence that directly states the tool's purpose without unnecessary words. It is front-loaded with the core action and resource, making it easy to parse quickly.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given the lack of annotations and output schema, the description is incomplete for a tool that retrieves schema information. It does not explain what the output looks like (e.g., a list of properties with types), potential errors, or dependencies, leaving the agent with insufficient context for effective use.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
The input schema has 100% description coverage, with 'tableName' clearly documented. The description adds no additional parameter details beyond what the schema provides, such as examples or constraints. Since the schema does the heavy lifting, the baseline score of 3 is appropriate.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the verb 'Get' and the resource 'property names and types from a table', making the purpose specific and understandable. However, it does not explicitly differentiate from sibling tools like 'list_tables' (which likely lists table names) or 'query_table' (which likely queries table data), leaving room for ambiguity in tool selection.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description provides no guidance on when to use this tool versus alternatives like 'list_tables' or 'query_table'. It lacks context such as prerequisites, typical use cases, or exclusions, leaving the agent to infer usage based on tool names alone.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
list_tablesC
List all tables in the storage account
| Name | Required | Description | Default |
|---|---|---|---|
| prefix | No | Optional prefix to filter table names |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
With no annotations provided, the description carries full burden for behavioral disclosure. It states the tool lists tables but doesn't mention any behavioral traits such as pagination, rate limits, authentication requirements, or what happens if no tables exist. This leaves significant gaps in understanding how the tool behaves operationally.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is a single, efficient sentence that directly states the tool's purpose without unnecessary words. It's appropriately sized and front-loaded, making it easy for an agent to parse quickly.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given the lack of annotations and output schema, the description is incomplete for a tool that interacts with storage resources. It doesn't address behavioral aspects like return format, error handling, or operational constraints, which are important for an agent to use the tool effectively in real scenarios.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
Schema description coverage is 100%, so the input schema already documents the optional 'prefix' parameter. The description doesn't add any additional meaning about parameters beyond what's in the schema, such as format examples or usage context. The baseline score of 3 reflects adequate but minimal value added.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the action ('List') and target resource ('all tables in the storage account'), providing a specific verb+resource combination. However, it doesn't explicitly differentiate from sibling tools like 'get_table_schema' or 'query_table', which prevents a perfect score.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description provides no guidance on when to use this tool versus alternatives like 'get_table_schema' or 'query_table'. There's no mention of use cases, prerequisites, or exclusions, leaving the agent with minimal contextual direction.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
query_tableA
⚠️ 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:
Simple equality: filter: "PartitionKey eq 'COURSE'" filter: "email eq 'user@example.com'"
Compound conditions: filter: "PartitionKey eq 'USER' and email eq 'user@example.com'" filter: "PartitionKey eq 'COURSE' and title eq 'GDPR Training'"
Numeric comparisons: filter: "age gt 25" filter: "costPrice le 100"
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
| Name | Required | Description | Default |
|---|---|---|---|
| filter | No | OData filter string. See description for examples. | |
| limit | No | Maximum number of items to return in response (default: 5). Note: Full query is still executed to get total count. | |
| select | No | Array of property names to select. Example: ["email", "username", "createdDate"] | |
| tableName | Yes | Name of the table to query |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
With no annotations provided, the description carries the full burden of behavioral disclosure. It excels at this by: 1) Warning about the default 5-item limit to protect context window, 2) Explaining that the full query executes to get total count despite the limit, 3) Providing extensive OData filter examples and supported operators, 4) Clarifying this is a query operation (not mutation). This goes well beyond what the input schema provides about behavioral characteristics.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is appropriately sized and front-loaded with the most critical information (warning and core purpose). Every sentence earns its place by providing essential guidance, examples, or operational details. The only minor issue is the extensive OData examples could be slightly condensed, but they serve an important educational purpose for this query tool.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given 4 parameters, no annotations, and no output schema, the description does an excellent job of providing context. It covers the tool's purpose, behavioral constraints (limit warning), parameter usage (extensive filter examples), and distinguishes from siblings. The only gap is lack of information about return format or error handling, which would be helpful since there's no output schema.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
Schema description coverage is 100%, so the baseline is 3. The description adds significant value beyond the schema by: 1) Providing concrete OData filter examples with syntax, 2) Listing all supported operators with explanations, 3) Clarifying the 'limit' parameter's purpose and default behavior. However, it doesn't explain the 'select' parameter's semantics beyond what the schema already states, keeping it from a perfect score.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the tool's purpose: 'Query data from an Azure Storage Table with optional filters.' This is a specific verb ('query') + resource ('Azure Storage Table') combination that distinguishes it from sibling tools like 'get_table_schema' (schema retrieval) and 'list_tables' (table enumeration). The description establishes this as a data querying tool with filtering capabilities.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description provides clear context about when to use this tool: for querying table data with OData filters. It distinguishes from siblings by focusing on data retrieval rather than schema or table listing. However, it doesn't explicitly state when NOT to use this tool or mention specific alternatives beyond the sibling names. The warning about the default limit provides operational guidance but not comparative usage advice.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
3 tool updates
v1.0.0- First observed
get_table_schema - First observed
list_tables - First observed
query_table
TDQS
Scored across 3 tools
Each tool has a clearly distinct purpose with no overlap: get_table_schema retrieves metadata about table structure, list_tables enumerates available tables, and query_table fetches actual data from tables. The descriptions clearly differentiate these operations, making tool selection unambiguous for an agent.
All three tools follow a consistent verb_noun naming pattern (get_table_schema, list_tables, query_table) with perfect consistency in style and structure. The naming convention is predictable and follows the same grammatical pattern throughout the tool set.
With only 3 tools, this server feels somewhat thin for Azure Table Storage operations. While the tools cover basic read operations, the absence of create, update, or delete operations for tables or entities makes the surface incomplete for typical database workflows. The count is borderline minimal for the domain.
The tool set has significant gaps for a database/storage system. There are no tools for creating tables, inserting entities, updating entities, or deleting tables/entities - only read operations exist. While the query capabilities are well-documented, the lack of write operations creates dead ends for agents trying to perform complete data management workflows.
Maintenance
Related MCP Connectors
Interact with your Google Bigtable resources using natural language commands.
Provides capabilities that let LLM agents perform a range of infrastructure management tasks.
List datasets, schemas, run APL queries, and use prompts for exploration, anomalies, and monitoring.
Query your warehouse or a CSV with Claude/ChatGPT over MCP, governed by table-level ACL + audit.
Related MCP Servers
- AlicenseBqualityDmaintenanceIntegrates Cline with Azure DevOps services, enabling access to work items, repositories, and pull requests through configurable MCP tools.1533MIT
- AlicenseBqualityDmaintenanceEnables intelligent interaction with Azure resources through natural language by translating requests into safe, auditable Azure CLI commands with plan/review workflows and direct access to 8 Azure services including Storage, Cosmos DB, Key Vault, and more.31MIT
- FlicenseNot gradedqualityDmaintenanceProvides an interactive dashboard within VS Code Copilot to manage Azure Storage accounts, containers, and blobs through a rich UI. It enables users to visualize storage resources, perform CRUD operations, and generate SAS tokens using the Model Context Protocol.2-
- FlicenseNot gradedqualityCmaintenanceConnects Microsoft Copilot Studio to Azure SQL Databases, enabling natural language interactions for data querying, record management, and schema inspection. It features 12 specialized tools for performing CRUD operations, executing SQL queries, and generating data visualizations like charts.-