What is Mcp Kql Server

MCP KQL Server is a tool that allows users to execute Kusto Query Language (KQL) queries directly within Claude Desktop, leveraging Azure Data Explorer for data analytics.

Use cases

Use cases include data analysis within Claude workflows, generating reports from Azure Data Explorer, and visualizing data insights in a structured format.

How to use

To use MCP KQL Server, clone the repository, set up a virtual environment, install dependencies, install Azure CLI, authenticate with Azure, and configure Claude Desktop with the necessary settings.

Key features

Key features include seamless integration with Claude, secure authentication via Azure CLI, structured output in table format, optional Markdown table visualization, and optimized performance with robust error handling.

Where to use

MCP KQL Server can be used in data analytics, business intelligence, and any application that requires querying large datasets in Azure Data Explorer.

🚀 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.

✨ Features

• 🔍 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.

📌 Comparison with Other Tools

📋 Requirements

• 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)

📂 Project Structure

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

🏗️ Setup Instructions

1️⃣ Clone the Repository

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

2️⃣ Install Python 3.10+

• Windows:

  winget install Python.Python.3.10
  

• macOS:

  brew install [email protected]
  

• Linux:

  sudo apt-get install python3.10
  

Verify installation:

python --version

3️⃣ Install Azure CLI

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

  az config set core.login_experience_v2=off
  az login
  

4️⃣ Create and Activate Virtual Environment

python -m venv .venv

Activate environment:

• Windows:

  .venv\Scripts\activate
  

• macOS/Linux:

  source .venv/bin/activate
  

5️⃣ Install Dependencies

pip install .

🖥️ Setup for Claude Desktop

• 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.

🖱️ Setup for VS Code

• 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.

✅ Test the Server

• 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"
    

🤝 Contributing

• 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.

📬 Contact

For issues or questions, please open a ticket on GitHub or contact the maintainer at [email protected].

🎉 Happy Querying!