Azure Cosmos DB MCP ServerServer

patrice-truong
GitHub
CosmosDBMCPAI Assistant

Loading subscription status...

💡 Description

This repository demonstrates how to create an MCP server and client for Azure Cosmos DB, featuring a NextJS 15 application that displays a product catalog and includes an AI assistant to help users find products and retrieve past orders. The MCP server connects to an Azure Cosmos DB NoSQL database to read product and order data.

📝 JSON Entries

{
  "mcpServers": [
    {
      "Azure_Cosmos_DB_MCP_Server": {
        "env": {
          "AZURE_OPENAI_API_KEY": "<azure_openai_key>",
          "AZURE_OPENAI_ENDPOINT": "https://<azure_openai_account>.openai.azure.com/",
          "AZURE_STORAGE_ACCOUNT_NAME": "<storage_account_name>",
          "NEXT_PUBLIC_AZURE_CLIENT_ID": "<client_id>",
          "NEXT_PUBLIC_AZURE_TENANT_ID": "<tenant_id>",
          "AZURE_STORAGE_CONTAINER_NAME": "<container_name>",
          "AZURE_COSMOSDB_NOSQL_DATABASE": "eshop",
          "AZURE_COSMOSDB_NOSQL_ENDPOINT": "https://<cosmosdb_account_name>.documents.azure.com:443/",
          "NEXT_PUBLIC_AZURE_CLIENT_SECRET": "<client_secret>",
          "AZURE_COSMOSDB_NOSQL_CARTS_CONTAINER": "carts",
          "AZURE_COSMOSDB_NOSQL_ORDERS_CONTAINER": "orders",
          "NEXT_PUBLIC_AZURE_STORAGE_ACCOUNT_NAME": "<storage_account_name>",
          "AZURE_COSMOSDB_NOSQL_PRODUCTS_CONTAINER": "products",
          "NEXT_PUBLIC_AZURE_STORAGE_CONTAINER_NAME": "img"
        },
        "args": [],
        "command": "npx ts-node src/server.ts"
      }
    }
  ]
}

🛠️ Tools

.NETNode.jsNextJS

Features

  • Integration with Azure Cosmos DB
  • AI Assistant for product search and order retrieval

💬 Example Queries

  • Show me products related to backpacks
  • Retrieve my orders