MCP.so
ログイン

Mcp Cosmosdb Sql

@hendrickcastro

リポジトリ

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.

基本情報

カテゴリ

データベース

トランスポート

stdio

公開者

hendrickcastro

投稿者

H. C.

設定

以下の設定を使って、このサーバーを 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"
      }
    }
  }
}

ツール

ツールは検出されませんでした

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

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

FAQ from Mcp Cosmosdb Sql

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.

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.

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.

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.

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).

コメント

「データベース」の他のコンテンツ

Neon MCP Server

neondatabase

MCP server for interacting with Neon Management API and databases

617

Database Gateway

centralmind

Universal MCP-Server for your Databases optimized for LLMs and AI-Agents.

531

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

88.1K

mcp_mysql_server

wenb1n-dev

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能； 还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245

Dbhub

bytebase

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

3.1K