广告合作
MCP.so
登录

MCP Cosmosdb Sql

@hendrickcastro

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

hendrickcastro

提交者

H. C.

关于 MCP Cosmosdb Sql

A comprehensive **Model Context Protocol (MCP)** server for **Azure CosmosDB** database operations. This server provides 8 powerful tools for document database analysis, container discovery, and data querying through the MCP protocol.

MCP Cosmosdb Sql 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "mcp-cosmosdb": {
      "command": "npx",
      "args": [
        "-y",
        "hendrickcastro/MCPCosmosDB"
      ],
      "env": {
        "OCONNSTRING": "AccountEndpoint=https://your-cosmos-account.documents.azure.com:443/;AccountKey=your-account-key-here;",
        "COSMOS_DATABASE_ID": "your-database-name"
      }
    }
  }
}

MCP Cosmosdb Sql 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

点击上方按钮,在临时沙箱中运行此服务器并实时获取工具列表。

概览

What is Mcp Cosmosdb Sql?

Mcp Cosmosdb Sql is a comprehensive Model Context Protocol (MCP) server for Azure CosmosDB database operations. It provides eight tools for document database analysis, container discovery, and data querying through the MCP protocol, targeting developers using MCP-compatible clients like Claude Desktop or Cursor IDE.

How to use Mcp Cosmosdb Sql?

Install and configure by adding the server to your MCP client’s JSON configuration (e.g., claude_desktop_config.json) with the command npx -y hendrickcastro/MCPCosmosDB and environment variables OCONNSTRING and COSMOS_DATABASE_ID. Alternatively, clone the repository, run npm install && npm run build, and point the client to dist/server.js. Invoke any of the eight tools via the client’s MCP interface.

Key features of Mcp Cosmosdb Sql

  • List all databases in the CosmosDB account
  • List and get detailed information about containers
  • Execute SQL queries against containers with parameters
  • Retrieve documents with optional filters and partition key targeting
  • Retrieve a specific document by ID and partition key
  • Analyze document schema structure in containers
  • Performance metrics with query request charges
  • Automatic connection pooling and retry logic

Use cases of Mcp Cosmosdb Sql

  • Container analysis: list containers, view index policies, and get statistics
  • Querying data: run parameterized SQL queries and retrieve filtered documents
  • Document operations: fetch specific documents by ID and partition key
  • Schema analysis: understand data patterns and document structures in a container

常见问题

1

How do I connect to Azure CosmosDB?

Set the `OCONNSTRING` environment variable to your CosmosDB connection string (including AccountEndpoint and AccountKey) and set `COSMOS_DATABASE_ID` to your database name.

2

What tools are available?

Eight tools: `mcp_list_databases`, `mcp_list_containers`, `mcp_container_info`, `mcp_container_stats`, `mcp_execute_query`, `mcp_get_documents`, `mcp_get_document_by_id`, and `mcp_analyze_schema`.

3

What should I do if I get a “Cross partition query required” error?

Set `enable_cross_partition: true` in your query parameters, or increase the `COSMOS_ENABLE_CROSS_PARTITION_QUERY` environment variable.

4

Can I use the CosmosDB Emulator for local development?

Yes. Use the default emulator connection string (`AccountEndpoint=https://localhost:8081/;AccountKey=C2y6yDjf5/…`) and ensure the emulator is running on port 8081.

5

How do I configure retry behavior?

Set optional environment variables: `COSMOS_MAX_RETRY_ATTEMPTS` (default 9) and `COSMOS_MAX_RETRY_WAIT_TIME` in milliseconds (default 30000).

评论

数据库 分类下的更多 MCP 服务器

Postgres Mcp

crystaldba

Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.

3.0K

Redis

modelcontextprotocol

Model Context Protocol Servers

88.2K

MotherDuck's DuckDB MCP Server

motherduckdb

Local MCP server for DuckDB and MotherDuck

498

mcp-server-qdrant: A Qdrant MCP server

qdrant

An official Qdrant Model Context Protocol (MCP) server implementation

637

nuzur

nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi

广告合作