Kusto MCP Server

An MCP (Model Context Protocol) server that provides tools for interacting with Azure Data Explorer (Kusto) clusters. Query, manage connections, and explore schemas using AI assistants like Claude and GitHub Copilot.

Features

• Execute KQL queries and scripts

• Manage multiple cluster connections

• Explore database schemas

• Full Azure authentication support

• Works with Claude Desktop, Claude Code CLI, and VS Code with GitHub Copilot

Prerequisites

• Node.js 18+

• .NET 8 Runtime

• Kusto CLI (microsoft.azure.kusto.tools NuGet package)

• Azure CLI (for authentication)

Install Kusto CLI

dotnet tool install -g Microsoft.Azure.Kusto.Tools

Or via NuGet:

nuget install microsoft.azure.kusto.tools -Version 14.0.3

Installation

Via npm (recommended)

npm install -g kusto-mcp-server

Via npx (no installation required)

npx kusto-mcp-server

Usage with AI Assistants

Claude Desktop

Add to your Claude Desktop configuration:

• Windows: %APPDATA%\Claude\claude_desktop_config.json

• macOS: ~/Library/Application Support/Claude/claude_desktop_config.json

• Linux: ~/.config/claude/claude_desktop_config.json

{
  "mcpServers": {
    "kusto": {
      "command": "npx",
      "args": ["-y", "kusto-mcp-server"],
      "env": {
        "KUSTO_CLI_PATH": "~/.nuget/packages/microsoft.azure.kusto.tools/14.0.3/tools/net8.0/Kusto.Cli.dll"
      }
    }
  }
}

Claude Code (CLI)

claude mcp add kusto -- npx -y kusto-mcp-server

Verify it's connected:

claude mcp list

VS Code with GitHub Copilot

Add to your VS Code settings.json (or .vscode/mcp.json in your workspace):

{
  "mcp": {
    "servers": {
      "kusto": {
        "command": "npx",
        "args": ["-y", "kusto-mcp-server"],
        "env": {
          "KUSTO_CLI_PATH": "~/.nuget/packages/microsoft.azure.kusto.tools/14.0.3/tools/net8.0/Kusto.Cli.dll"
        }
      }
    }
  }
}

Or use the VS Code command palette:

1. Open Command Palette (Ctrl+Shift+P / Cmd+Shift+P)

2. Run "MCP: Add Server"

3. Select "Command (stdio)"

4. Enter command: npx -y kusto-mcp-server

5. Enter server ID: kusto

Authentication

Before using the server, authenticate with Azure:

az login

Available Tools

Query Tools

Connection Management

Schema & Help

Usage Examples

Add a Connection

kusto_connection_add({
  name: "my-cluster",
  cluster: "https://mycluster.kusto.windows.net",
  database: "MyDatabase",
  authMethod: "azcli",
  isDefault: true
})

Execute a Query

kusto_query({
  query: "StormEvents | summarize count() by State | top 10 by count_",
  connectionName: "my-cluster"
})

Get Schema

kusto_schema({
  scope: "tables",
  connectionName: "my-cluster"
})

Execute Multiple Commands

kusto_execute({
  commands: [
    ".show tables",
    "StormEvents | count"
  ],
  connectionName: "my-cluster"
})

Configuration

Environment variables:

Development

# Clone the repository
git clone https://github.com/yeshsurya/kusto-mcp-server.git
cd kusto-mcp-server

# Install dependencies
npm install

# Build
npm run build

# Watch mode
npm run dev

# Run tests
npm test

License

MIT