Mcp Server Kusto

Name: Mcp Server Kusto
Author: ZZZHDW

@ZZZHDW

代码仓库

关于 Mcp Server Kusto

A mcp server that uses azure data explorer as a backend

基本信息

分类

其他

许可证

MIT

运行时

python

传输方式

stdio

发布者

ZZZHDW

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

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

工具

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

概览

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

FAQ from Mcp Server Kusto

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.

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.

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.