drio
Open app

Azure Data Explorer MCP Server

Source

A Model Context Protocol (MCP) server that enables AI assistants to query and analyze Azure Data Explorer databases through standardized interfaces.

Catalog onlyCatalog onlySTDIO

Overview

Azure Data Explorer MCP Server is a Model Context Protocol (MCP) server that allows AI assistants to query and analyze Azure Data Explorer databases through standardized interfaces.

To use the server, create a service account in Azure Data Explorer, configure environment variables for your ADX cluster, and add the server configuration to your client configuration file.

  • Execute KQL queries against Azure Data Explorer - Discover and explore database resources - Authentication support - Provide interactive tools for AI assistants
  1. Analyzing logs for error counts over a specific time period.
  2. Exploring database schemas and tables.
  3. Executing complex queries to derive insights from data.

Add to your AI client

Use these steps to connect Azure Data Explorer MCP Server in Cursor, Claude, VS Code, and other MCP-compatible apps. The same JSON appears in the Use with menu above for one-click copy.

Cursor

Add this to your .cursor/mcp.json file in your project root, then restart Cursor.

.cursor/mcp.json

{
  "mcpServers": {
    "adx-mcp-server-pab1it0": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-adx-mcp-server-pab1it0"
      ]
    }
  }
}

Claude Desktop

Add this server entry to the mcpServers object in your Claude Desktop config, then restart the app.

~/Library/Application Support/Claude/claude_desktop_config.json (macOS) or %APPDATA%\Claude\claude_desktop_config.json (Windows)

{
  "mcpServers": {
    "adx-mcp-server-pab1it0": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-adx-mcp-server-pab1it0"
      ]
    }
  }
}

Claude Code

Add this to your project's .mcp.json file. Claude Code will detect it automatically.

.mcp.json (project root)

{
  "mcpServers": {
    "adx-mcp-server-pab1it0": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-adx-mcp-server-pab1it0"
      ]
    }
  }
}

VS Code (Copilot)

Add this to your .vscode/mcp.json file. Requires the GitHub Copilot extension with MCP support enabled.

.vscode/mcp.json

{
  "servers": {
    "adx-mcp-server-pab1it0": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-adx-mcp-server-pab1it0"
      ]
    }
  }
}

Windsurf

Add this to your Windsurf MCP config file, then restart Windsurf.

~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "adx-mcp-server-pab1it0": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-adx-mcp-server-pab1it0"
      ]
    }
  }
}

Cline

Open Cline settings, navigate to MCP Servers, and add this server configuration.

Cline MCP Settings (via UI)

{
  "mcpServers": {
    "adx-mcp-server-pab1it0": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-adx-mcp-server-pab1it0"
      ]
    }
  }
}

FAQ

What is KQL?

KQL stands for Kusto Query Language, used to query Azure Data Explorer.

Is there a limit to the number of queries I can execute?

No, but performance may vary based on the complexity of the queries and the size of the data.

Can I use this server with other AI assistants?

Yes, the server is designed to work with any AI assistant that supports the Model Context Protocol.

Research and data