Kusto MCP Server

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

Local serverstdio

What is the Kusto MCP server?

Kusto mcp server connects Kusto to AI assistants that speak the Model Context Protocol. A mcp server that provides access to Azure Data Explorer (ADX) clusters.

What Kusto does

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

Tools it exposes

Once connected, the assistant can call these 8 tools directly:

  • 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_internal_table — execute a query on an internal table or materialized view
  • execute_query_external_table — execute a query on an external table
  • 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
  • Tools — The Tools tool exposed by this server

Installing the kusto mcp server

Setup follows the standard MCP pattern: clone or install the server, then register it in your client's configuration file and restart the client. The configuration snippets on this page cover Claude Desktop, Claude Code and Cursor.

Configuration

Before the server will start you need to supply 4 environment variables: ADX_CLUSTER_URL, TENANT_ID, CLIENT_ID, CLIENT_SECRET. Keep credentials in your client's env block or a secrets manager rather than committing them.

Where it fits

Cloud and DevOps servers put infrastructure on speaking terms with your assistant, so "why is this broken?" is answered from real state rather than a generic checklist. Kusto sits in that group, and the shape of its toolset — list_internal_tables, list_external_tables, list_materialized_views among others — tells you what it is really for. Worth comparing against the other cloud devops servers in this directory before you commit to one, since several overlap in scope but differ sharply in setup cost and permissions.

Practical notes

  • This server runs locally, so it operates with whatever access your machine and its credentials already have. Scope that deliberately rather than by default.
  • It will not start until its required credentials are present, so set those before wondering why the tools never appear.
  • With 8 tools exposed, expect a noticeable bump in prompt size — disable it in projects that never use Kusto.
  • Maintained by ZZZHDW.
  • MCP clients ask for confirmation before each tool call by default. Keep that on while you learn what the kusto mcp server actually does with your data.
  • Every entry in this directory is reviewed by hand before it goes live, and details are checked against the project's own documentation.

Available tools

ToolWhat it does
list_internal_tableslist all internal tables in the cluster
list_external_tableslist all external tables in the cluster
list_materialized_viewslist all materialized views in the cluster
execute_query_internal_tableexecute a query on an internal table or materialized view
execute_query_external_tableexecute a query on an external table
get_internal_table_schemaget the schema of an internal table or materialized view
get_external_table_schemaget the schema of an external table
ToolsThe Tools tool exposed by this server.

How to install the Kusto MCP server

{
  "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}}"
      ]
    }
  }
}

Configuration as documented by the project. Restart the client after saving.

Configuration

VariableDescriptionRequired
ADX_CLUSTER_URLEndpoint or connection string the server talks to.Yes
TENANT_IDConfiguration value read at startup.Optional
CLIENT_IDConfiguration value read at startup.Optional
CLIENT_SECRETCredential the server authenticates with.Yes

Example prompts to try

  • Use Kusto to list internal tables.
  • Use Kusto to list external tables.
  • Use Kusto to list materialized views.

Frequently asked questions

It connects Kusto to MCP-compatible AI assistants such as Claude and Cursor, exposing 8 tools (list_internal_tables, list_external_tables, list_materialized_views, and more) that the assistant can call on your behalf. Instead of copying data back and forth by hand, the assistant works with Kusto directly.