MCP.so
Sign In

MCP Server Kusto

@ZZZHDW

Basic information

Category

Other

License

MIT

Transports

stdio

Author

ZZZHDW

About MCP Server Kusto

A mcp server that uses azure data explorer as a backend

MCP Server Kusto config

Add this server to your MCP-compatible client using the configuration below.

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

MCP Server Kusto tools

7

list all internal tables in the cluster

list all external tables in the cluster

list all materialized views in the cluster

execute a query on an internal table or materialized view

execute a query on an external table

get the schema of an internal table or materialized view

get the schema of an external table

Overview

What is Mcp Server Kusto?

Mcp Server Kusto is an MCP server that provides access to Azure Data Explorer (ADX) clusters. It enables AI assistants to list tables, execute queries, and retrieve table schemas from ADX.

How to use Mcp Server Kusto?

Install and configure by editing claude_desktop_config.json with the uv command and arguments pointing to the project directory and cluster URL. For Azure AD authentication, provide --authority_id, --client_id, and --client_secret. For a local emulator, omit those flags and use a URL like https://localhost:8082.

Key features of Mcp Server Kusto

  • List internal tables, external tables, and materialized views
  • Execute queries on internal and external tables
  • Get schema of internal tables, external tables, and materialized views
  • Supports Azure AD authentication (tenant, client ID, secret)
  • Supports local Azure Data Explorer emulator without authentication

Use cases of Mcp Server Kusto

  • Query ADX clusters directly from Claude Desktop conversations
  • Explore available tables and views in a cluster before writing queries
  • Retrieve table schemas to understand data structures for query formulation
  • Run ad-hoc analytics on ADX data through a natural language interface

Frequently asked questions

1

How do I configure authentication for Mcp Server Kusto?

Provide the `--authority_id` (tenant ID), `--client_id`, and `--client_secret` arguments in the Claude Desktop configuration.

2

Can I use Mcp Server Kusto with a local ADX emulator?

Yes. Use a cluster URL like `https://localhost:8082` and omit the `--authority_id`, `--client_id`, and `--client_secret` arguments.

3

What tools are available in Mcp Server Kusto?

The server provides tools to list internal/external tables and materialized views, execute queries on internal/external tables, and get schemas of internal/external tables and materialized views.

4

What are the runtime dependencies for Mcp Server Kusto?

The server requires `uv` to run, and the Python project located at the specified directory path must be available.

Comments

More Other MCP servers