Skip to main content
Glama
Kusto MCP Server

Kusto MCP Server

by ZZZHDW

Kusto MCP Server

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

Tools

The following tools are provided by the server:

  • list tables:

    • list_internal_tables:list all internal tables in the cluster

    • list_external_tables:list all external tables in the cluster

    • list_materialized_views:list all materialized views in the cluster

  • execute query:

    • execute_query_internal_table:execute a query on an internal table or materialized view

    • execute_query_external_table:execute a query on an external table

  • get table schema:

    • get_internal_table_schema:get the schema of an internal table or materialized view

    • get_external_table_schema:get the schema of an external table

Claude Desktop configuration

Edit claude_desktop_config.json 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}}"
      ]
    }
  }
}

When using azure data explorer emulator locally, provide the cluster url like https://localhost:8082 and not need to provide --authority_id, --client_id, --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}}"
      ]
    }
  }
}

Available Tools

7 tools
execute_query_external_tableC

Execute a kql query to external table

Inputs: database (required), query (required).

execute_query_internal_tableC

Execute a kql query to internal table or materialized view

Inputs: database (required), query (required).

list_external_tablesC

List all external tables in the database

Inputs: database (required).

list_internal_tablesC

List all internal tables in the database

Inputs: database (required).

list_materialized_viewsC

List all materialized views in the database

Inputs: database (required).

retrieve_external_table_schemaC

Get the schema of an external table

Inputs: database (required), table (required).

retrieve_internal_table_schemaC

Get the schema of a table or materialized view

Inputs: database (required), table (required).

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    B3/5.0

    Scored across 7 tools

    Disambiguation4/5

    Tools are mostly distinct with separate verbs for listing, querying, and schema retrieval. However, execute_query_internal_table includes materialized views, slightly overlapping with the listing tools.

    Naming Consistency5/5

    All tool names follow a consistent verb_noun pattern in snake_case, such as execute_query, list_, retrieve_. No mixing of styles.

    Tool Count5/5

    With 7 tools, the set is well-scoped for a focused Kusto query server, covering essential operations without unnecessary bloat.

    Completeness4/5

    The set covers querying, listing, and schema retrieval for tables and views. Minor gaps include no tools for database-level listing or management operations, but the read-only focus seems intentional.

    Maintenance

    ActivityInactive
    ResponsivenessNo recent community issues

    Related MCP Connectors

    Related MCP Servers

    • F
      license
      A
      quality
      D
      maintenance
      An MCP server for Microsoft SQL Server that enables executing read-only queries, listing tables, and describing database schemas. It offers specialized support for custom ports and multiple authentication methods including SQL credentials, NTLM, and Windows Integrated Auth.
      3
      -
    • A
      license
      A
      quality
      D
      maintenance
      An MCP (Model Context Protocol) server that provides tools for interacting with Azure Data Explorer (Kusto) clusters.
      10
      28 npm
      MIT
    • A
      license
      A
      quality
      D
      maintenance
      An MCP server for Azure development and operations, enabling Cosmos DB queries, Service Bus messaging, and PIM role activation.
      31
      44 PyPI
      MIT