Pab1it0 Adx MCP Server

🚀 Azure Data Explorer MCP Server

An MCP server for Azure Data Explorer that enables AI assistants to execute KQL queries and explore data through a standardized interface.

🚀 Quick Start

This is a Model Context Protocol (MCP) server for Azure Data Explorer. Through the standardized MCP interface, you can use this server to access your Azure Data Explorer clusters and databases, allowing AI assistants to execute KQL queries for data exploration.

✨ Features

• [x] Execute KQL queries against Azure Data Explorer.
• [x] Discover and explore database resources:
  • [x] List tables in the configured database.
  • [x] View table structures.
  • [x] Get sample data from tables.
• [x] Support authentication:
  • [x] Support token credentials (Azure CLI, MSI, etc.).
• [x] Provide Docker containerization support.
• [x] Offer interactive tools for AI assistants.

The tool list is configurable, so you can choose which tools to provide to MCP clients. This is useful if you don't use certain features or don't want to take up too much space in the context window.

💻 Usage Examples

Basic Usage

1. Log in to your Azure account with access to the Azure Data Explorer cluster using the Azure CLI.
2. Configure environment variables via the .env file or system environment variables:

# Required: Azure Data Explorer configuration
ADX_CLUSTER_URL=https://yourcluster.region.kusto.windows.net
ADX_DATABASE=your_database

3. Add the server configuration to your client configuration file. For example, for Claude Desktop:

{
  "mcpServers": {
    "adx": {
      "command": "uv",
      "args": [
        "--directory",
        "<Full path to the adx-mcp-server folder>"
      ]
    }
  }
}

Advanced Usage

Docker Support

• Build the image using the following command:

docker build -t azure-data-explorer-mcp .

• Run the container using the following command:

docker run --rm -it -e ADX_CLUSTER_URL=your_cluster_url -e ADX_DATABASE=your_database azure-data-explorer-mcp

📚 Documentation

Tools

📄 License

MIT