A Model Context Protocol (MCP) server that transforms natural language questions into optimized KQL queries with intelligent schema discovery
Mcp kql server mcp server lets Claude, Cursor and other MCP clients work with MCP Kql Server directly. A Model Context Protocol (MCP) server that transforms natural language questions into optimized KQL queries with intelligent schema discovery, AI-powered caching, and seamless Azure Data Explorer integration. Simply ask questions in plain English and get instant, accurate KQL queries with.
A Model Context Protocol (MCP) server that transforms natural language questions into optimized KQL queries with intelligent schema discovery, AI-powered caching, and seamless Azure Data Explorer integration. Simply ask questions in plain English and get instant, accurate KQL queries with context-aware results.
The server is distributed via PyPI as mcp-kql-server, so most clients can run it without a manual build step. Add it to your MCP client's configuration and restart the client to pick it up — the copy-paste configs for Claude Desktop, Claude Code and Cursor are on this page.
The server reads 8 environment variables: FASTMCP_TRANSPORT, MCP_KQL_AUTH_ON_STARTUP, MCP_KQL_CHECK_FOR_UPDATES, MCP_KQL_DEFER_AUTH, MCP_KQL_SKIP_STARTUP_VERSION_CHECK, MCP_KQL_AUTH_CHECK_TIMEOUT_SECONDS, MCP_KQL_AUTH_LOGIN_TIMEOUT_SECONDS, MCP_KQL_SQLITE_BUSY_TIMEOUT_MS. Keep credentials in your client's env block or a secrets manager rather than committing them.
Cloud and DevOps servers put infrastructure on speaking terms with your assistant, so "why is this broken?" is answered from real state rather than a generic checklist. MCP Kql Server sits in that group. Worth comparing against the other cloud devops servers in this directory before you commit to one, since several overlap in scope but differ sharply in setup cost and permissions.
{
"mcpServers": {
"kql-server": {
"command": "uvx",
"args": ["mcp-kql-server"],
"env": {
"FASTMCP_TRANSPORT": "your-value",
"MCP_KQL_AUTH_ON_STARTUP": "your-value",
"MCP_KQL_CHECK_FOR_UPDATES": "your-value",
"MCP_KQL_DEFER_AUTH": "your-value",
"MCP_KQL_SKIP_STARTUP_VERSION_CHECK": "your-value",
"MCP_KQL_AUTH_CHECK_TIMEOUT_SECONDS": "your-value",
"MCP_KQL_AUTH_LOGIN_TIMEOUT_SECONDS": "your-value",
"MCP_KQL_SQLITE_BUSY_TIMEOUT_MS": "your-value"
}
}
}
}Add to claude_desktop_config.json, then restart Claude Desktop.
| Variable | Description | Required |
|---|---|---|
| FASTMCP_TRANSPORT | Configuration value read at startup. | Optional |
| MCP_KQL_AUTH_ON_STARTUP | Configuration value read at startup. | Optional |
| MCP_KQL_CHECK_FOR_UPDATES | Configuration value read at startup. | Optional |
| MCP_KQL_DEFER_AUTH | Configuration value read at startup. | Optional |
| MCP_KQL_SKIP_STARTUP_VERSION_CHECK | Configuration value read at startup. | Optional |
| MCP_KQL_AUTH_CHECK_TIMEOUT_SECONDS | Configuration value read at startup. | Optional |
| MCP_KQL_AUTH_LOGIN_TIMEOUT_SECONDS | Configuration value read at startup. | Optional |
| MCP_KQL_SQLITE_BUSY_TIMEOUT_MS | Configuration value read at startup. | Optional |
Manage your whole Supabase project in conversation — database, auth, storage, Edge Functions and branches.
Stop letting your assistant hallucinate n8n node parameters — this server hands it the real schemas, templates and validation.
AWS Labs' official server suite — current AWS docs, CDK guidance, cost analysis and service tools.
Cloud browsers for AI agents — automation sessions that run in Browserbase's fleet, not on your machine.
Workers, KV, R2 and D1 by conversation — Cloudflare's official remote servers for building and observability.
Dashboards, Prometheus and Loki queries, incidents and alerts — observability by conversation.