MCP ExplorerExplorer

Mcp Server Kusto

@ZZZHDWon 11 days ago
1 MIT
FreeCommunity
AI Systems
A mcp server that uses azure data explorer as a backend

Overview

What is Mcp Server Kusto

mcp-server-kusto is a server that provides access to Azure Data Explorer (ADX) clusters, allowing users to interact with data stored in these clusters.

Use cases

Use cases include data exploration, real-time analytics, and integrating Azure Data Explorer with other applications for enhanced data management and insights.

How to use

To use mcp-server-kusto, configure the ‘claude_desktop_config.json’ file with the necessary parameters such as cluster URL, authority ID, client ID, and client secret. Then, run the server using the specified command.

Key features

Key features include listing internal and external tables, executing queries on both internal and external tables, and retrieving the schema for these tables.

Where to use

mcp-server-kusto can be used in data analytics, business intelligence, and application development where Azure Data Explorer is utilized for data storage and querying.

Content

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

Tools

No tools

Comments