10 months ago
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.
Overview
1. 🗄️ List Databases - mcp_list_databases
List all databases in the CosmosDB account.
2. 📦 List Containers - mcp_list_containers
List all containers in the current database.
3. 📋 Container Information - mcp_container_info
Get detailed information about a specific container including partition key, indexing policy, and throughput settings.
4. 📊 Container Statistics - mcp_container_stats
Get statistics about a container including document count, size estimation, and partition key distribution.
5. 🔍 Execute SQL Query - mcp_execute_query
Execute SQL queries against CosmosDB containers with parameters and performance metrics.
6. 📄 Get Documents - mcp_get_documents
Retrieve documents from containers with optional filtering and partition key targeting.
7. 🎯 Get Document by ID - mcp_get_document_by_id
Retrieve a specific document by its ID and partition key.
8. 🏗️ Schema Analysis - mcp_analyze_schema
Analyze document schema structure in containers to understand data patterns.
Server Config
{
"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"
}
}
}
}