mcp-kql-server

A Model Context Protocol (MCP) server for executing Kusto Query Language (KQL) queries against Azure Data Explorer clusters. Seamlessly integrates with Claude Desktop and Visual Studio Code (VS Code). Supports Azure CLI authentication and provides a convenient kql_execute tool for execute KQL queries directly within your AI prompts, complete with optional visualizations.

• 🔍 Execute KQL Queries: Run KQL queries directly within your AI prompts using the kql_execute MCP tool.
• ⚡ Plug-and-Play Simplicity: No manual tenant ID configuration or complex credential management. Simply authenticate via Azure CLI (az login) and start querying immediately.
• 🤖 Seamless Claude Integration: Execute KQL queries within Claude Desktop without switching interfaces or dashboards.
• 🔒 Secure and Efficient: Leverages Azure CLI’s robust authentication, ensuring secure credential handling and optimized query performance.
• 📊 Visualization Ready: Optional Markdown table outputs make data analysis intuitive and engaging.
• 🔑 Azure CLI Authentication: Built-in Azure CLI authentication with retry and caching logic.
• 📡 Protocol Compatibility: Fully compatible with MCP protocol version 2024-11-05.
• 🛠️ Reliable Implementation: Uses fastmcp for a robust and reliable MCP server implementation.

• Python 3.10 or higher
• Azure Data Explorer cluster access
• Azure CLI installed and authenticated (az login)
• Node.js (optional, for Claude Desktop filesystem server)
• VS Code with Claude extension or MCP client (for VS Code integration)

mcp-kql-server/
├── mcp_kql_server/
│   ├── __init__.py
│   ├── mcp_server.py
│   ├── kql_auth.py
│   └── execute_kql.py
├── pyproject.toml
├── README.md

git clone https://github.com/4R9UN/mcp-kql-server.git
cd mcp-kql-server

• Windows:

  winget install Python.Python.3.10

• macOS:

  brew install python@3.10

• Linux:

  sudo apt-get install python3.10

Verify installation:

python --version

• Follow official instructions: Install Azure CLI
• Log in to Azure:

  az config set core.login_experience_v2=off
  az login

python -m venv .venv

Activate environment:

• Windows:

  .venv\Scripts\activate

• macOS/Linux:

  source .venv/bin/activate

pip install .

• Copy claude_desktop_config.json to Claude's configuration directory:

  • Windows: C:\Users\YourUser\AppData\Roaming\Claude\
  • macOS: /Users/YourUser/Library/Application Support/Claude/
  • Linux: Currently not supported by Claude Desktop.

• Update the configuration file with your Python path and project directory:

{
  "mcpServers": {
    "mcp-kql-server": {
      "command": "C:\\Users\\YourUser\\mcp-kql-server\\.venv\\Scripts\\python.exe",
      "args": [
        "-m",
        "mcp_kql_server.mcp_server"
      ]
    }
  }
}

• Optional: Install Node.js for filesystem server support (Node.js).
• Restart Claude Desktop.

• Install VS Code.
• Install the Copilot MCP client extension.
• Modify the MCP settings.json with the following configuration:

{
  "mcpServers": {
    "mcp-kql-server": {
      "command": "C:\\Users\\YourUser\\mcp-kql-server\\.venv\\Scripts\\python.exe",
      "args": [
        "-m",
        "mcp_kql_server.mcp_server"
      ],
      "env": {
        "PYTHONPATH": "C:\\Users\\YourUser\\Downloads\\mcp-kql-server",
        "PYTHONUNBUFFERED": "1",
        "AZURE_CORE_ONLY_SHOW_ERRORS": "true"
      }
    }
  }
}

• Run the MCP: List Servers command in VS Code’s Command Palette to verify setup.
• Enable autodiscovery if using Claude Desktop’s configuration.

• Claude Desktop:
  • Open Claude Desktop and provide the following prompt:

    Use a tool to execute the attached KQL query, visualize the results, and provide high-level insights from the query output.
    
    KQL query: "cluster('mycluster').database('mydb').MyTable | take 10"
    

• Fork the repository.
• Create a feature branch:

  git checkout -b feature/YourFeature

• Commit your changes:

  git commit -m "Add YourFeature"

• Push to your branch:

  git push origin feature/YourFeature

• Open a Pull Request.

For issues or questions, please open a ticket on GitHub or contact the maintainer at arjuntrivedi42@yahoo.com.

🎉 Happy Querying!