Vibe querying with MCP server for Azure Data Explorer (Kusto)

What is Vibe querying with MCP server for Azure Data Explorer (Kusto)?

This is an MCP (Model Context Protocol) server built with the Azure Data Explorer Go SDK that exposes tools for interacting with Azure Data Explorer (Kusto) clusters. It is designed for users who want to perform data analysis and exploration using natural language via MCP clients like VS Code, Claude Desktop, or other compatible tools.

How to use Vibe querying with MCP server for Azure Data Explorer (Kusto)?

Clone the repository, build the binary with go build -o mcp_kusto main.go, then configure the server in your MCP client (e.g., VS Code mcp.json or Claude Desktop config) by pointing to the binary path. Authentication uses Azure’s DefaultAzureCredential – for example, log in via az login. Ensure your user principal has the required permissions (.show databases, .show tables, execute queries) on the cluster.

Key features of Vibe querying with MCP server for Azure Data Explorer (Kusto)

• Lists all databases in a specified Azure Data Explorer cluster.
• Lists all tables in a specific database.
• Retrieves the schema of a specific table.
• Executes read-only KQL queries against a database.

Use cases of Vibe querying with MCP server for Azure Data Explorer (Kusto)

• Quickly explore database and table structures using natural language.
• Run ad-hoc Kusto queries without leaving your code editor.
• Leverage AI assistants to analyze Azure Data Explorer data interactively.

FAQ from Vibe querying with MCP server for Azure Data Explorer (Kusto)

What tools does the server expose?

It exposes four tools: list_databases, list_tables, get_table_schema, and execute_query. All are read‑only.

How do I authenticate the server?

The server uses DefaultAzureCredential from the Azure SDK. You can authenticate via Azure CLI (az login) or by setting environment variables for a service principal.

What permissions are required for the user principal?

The user principal must have permissions to run .show databases, .show tables, .show table, and execute queries on the database.

What are the runtime dependencies?

Go is required to build the server from source. No runtime besides the compiled binary and an authenticated Azure session is needed.

Can I use this with VS Code or Claude Desktop?

Yes. The README includes configuration examples for VS Code MCP settings (mcp.json) and Claude Desktop’s MCP server configuration.