Kusto MCP Server
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@Kusto MCP Server list all internal tables in the cluster"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
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}}"
]
}
}
}Available Tools
7 toolsexecute_query_external_tableC
Execute a kql query to external table
Inputs: database (required), query (required).
execute_query_internal_tableC
Execute a kql query to internal table or materialized view
Inputs: database (required), query (required).
list_external_tablesC
List all external tables in the database
Inputs: database (required).
list_internal_tablesC
List all internal tables in the database
Inputs: database (required).
list_materialized_viewsC
List all materialized views in the database
Inputs: database (required).
retrieve_external_table_schemaC
Get the schema of an external table
Inputs: database (required), table (required).
retrieve_internal_table_schemaC
Get the schema of a table or materialized view
Inputs: database (required), table (required).
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
TDQS
Scored across 7 tools
Tools are mostly distinct with separate verbs for listing, querying, and schema retrieval. However, execute_query_internal_table includes materialized views, slightly overlapping with the listing tools.
All tool names follow a consistent verb_noun pattern in snake_case, such as execute_query, list_, retrieve_. No mixing of styles.
With 7 tools, the set is well-scoped for a focused Kusto query server, covering essential operations without unnecessary bloat.
The set covers querying, listing, and schema retrieval for tables and views. Minor gaps include no tools for database-level listing or management operations, but the read-only focus seems intentional.
Maintenance
Related MCP Connectors
The MCP server for Azure DevOps, bringing the power of Azure DevOps directly to your agents.
An MCP server giving access to Grafana dashboards, data and more.
MCP server for querying and analyzing data from ad platforms, analytics tools, and spreadsheets
Official Microsoft MCP Server to query Microsoft Entra data using natural language
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceAn MCP server that enables listing and querying Trino tables using Python, providing access to data resources through the Model-Control-Protocol.18MIT
- FlicenseAqualityDmaintenanceAn MCP server for Microsoft SQL Server that enables executing read-only queries, listing tables, and describing database schemas. It offers specialized support for custom ports and multiple authentication methods including SQL credentials, NTLM, and Windows Integrated Auth.3-
- AlicenseAqualityDmaintenanceAn MCP (Model Context Protocol) server that provides tools for interacting with Azure Data Explorer (Kusto) clusters.1028 npmMIT
- AlicenseAqualityDmaintenanceAn MCP server for Azure development and operations, enabling Cosmos DB queries, Service Bus messaging, and PIM role activation.3144 PyPIMIT