Kusto (Azure Data Explorer)

🚀 Kusto MCP Server

A MCP server that provides access to Azure Data Explorer (ADX) clusters.

🚀 Quick Start

This server offers a range of tools for interacting with ADX clusters, and also provides configuration instructions for Claude Desktop.

✨ Features

Tools

The server provides the following tools:

• List Tables:

  • list_internal_tables: Lists all internal tables in the cluster.
  • list_external_tables: Lists all external tables in the cluster.
  • list_materialized_views: Lists all materialized views in the cluster.

• Execute Queries:

  • execute_query_internal_table: Executes queries on internal tables or materialized views.
  • execute_query_external_table: Executes queries on external tables.

• Get Table Schema:

  • get_internal_table_schema: Retrieves the structure information of internal tables or materialized views.
  • get_external_table_schema: Retrieves the structure information of external tables.

📦 Installation

No specific installation steps are provided in the original document.

💻 Usage Examples

Claude Desktop Configuration

Edit the claude_desktop_config.json file to add the following configuration:

{
  "mcpServers": {
    "kusto": {
      "command": "uv",
      "args": [
        "--directory",
        "{{PATH_TO_PROJECT}}\\mcp-server-kusto\\src\\mcp_server_kusto",
        "run",
        "mcp-server-kusto",
        "--cluster",
        "{{ADX_CLUSTER_URL}}",
        "--authority_id",
        "{{TENANT_ID}}",
        "--client_id",
        "{{CLIENT_ID}}",
        "--client_secret",
        "{{CLIENT_SECRET}}"
      ]
    }
  }
}

⚠️ Important Note

When using the Azure Data Explorer emulator for local development, provide the cluster URL like https://localhost:8082, and there's no need to provide --authority_id, --client_id, and --client_secret.

{
  "mcpServers": {
    "kusto": {
      "command": "uv",
      "args": [
        "--directory",
        "{{PATH_TO_PROJECT}}\\mcp-server-kusto\\src\\mcp_server_kusto",
        "run",
        "mcp-server-kusto",
        "--cluster",
        "{{ADX_CLUSTER_URL}}"
      ]
    }
  }
}

📚 Documentation

No detailed documentation is provided in the original document.

🔧 Technical Details

No technical details are provided in the original document.

📄 License

No license information is provided in the original document.