Kusto (Azure Data Explorer)

An MCP server that provides access to Azure Data Explorer clusters, supporting functions such as querying tables and retrieving table structures

Database Developer tools #Data query #Table management #ADX connection .Python

rating : 2 points

downloads : 6

update time : 2025-04-28

What is Kusto MCP Server?

Kusto MCP Server is a middleware service that acts as a bridge between users and Azure Data Explorer clusters. It provides functions such as data querying and table structure viewing through a standardized protocol, simplifying the interaction process with ADX clusters.

How to use Kusto MCP Server?

After configuring the Claude Desktop client to connect to the MCP server, you can perform operations such as data querying and table structure viewing. The server supports two authentication methods: Azure AD authentication is used in the production environment, while no authentication is required for the local emulator.

Applicable scenarios

Suitable for analysts and developers who need to frequently query ADX cluster data, especially in scenarios where ADX query capabilities need to be integrated into other applications.

Main features

Table list queryProvides three types of table list query functions: list queries for internal tables, external tables, and materialized views.

Data querySupports executing Kusto Query Language (KQL) queries on internal tables/materialized views and external tables.

Table structure viewingCan retrieve detailed structure information for any internal table, external table, or materialized view.

Advantages and limitations

Advantages

Unified interface to access ADX clusters, simplifying development

Supports both production environment and local emulator modes

Provides a complete set of functions for table structure and data querying

Limitations

Requires pre - configuration of ADX cluster connection information

Azure AD application registration and permission configuration are required in the production environment

Only supports Kusto Query Language (KQL)

How to use

Configure Claude Desktop

Edit the claude_desktop_config.json file and add the Kusto MCP server configuration.

Start the MCP server

Start the server by running the mcp - server - kusto module through uvicorn.

Execute a query

Send query commands through the client tool to obtain data or table structure information.

Usage examples

Data explorationAnalysts need to know which data tables are available in the ADX cluster

Data queryDevelopers need to query data from a specific table in the last 7 days

Table structure inspectionData engineers need to know the field structure of a table to write an ETL process

Frequently Asked Questions

How to distinguish between internal tables and external tables?

What configurations are required for the local emulator mode?

Is there a size limit for query results?

Related resources

Azure Data Explorer documentation

Official ADX product documentation

Kusto Query Language reference

KQL syntax and function reference

MCP protocol specification

Official specification of the Model Context Protocol

🚀 Kusto MCP Server

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

🚀 Quick Start

This server offers a range of tools for interacting with ADX clusters, and also provides configuration instructions for Claude Desktop.

✨ Features

Tools

The server provides the following tools:

List Tables:
- list_internal_tables: Lists all internal tables in the cluster.
- list_external_tables: Lists all external tables in the cluster.
- list_materialized_views: Lists all materialized views in the cluster.
Execute Queries:
- execute_query_internal_table: Executes queries on internal tables or materialized views.
- execute_query_external_table: Executes queries on external tables.
Get Table Schema:
- get_internal_table_schema: Retrieves the structure information of internal tables or materialized views.
- get_external_table_schema: Retrieves the structure information of external tables.

📦 Installation

No specific installation steps are provided in the original document.

💻 Usage Examples

Claude Desktop Configuration

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

⚠️ Important Note

When using the Azure Data Explorer emulator for local development, provide the cluster URL like https://localhost:8082, and there's no need to provide --authority_id, --client_id, and --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}}"
      ]
    }
  }
}