Azure Data Explorer MCP Server

Name: Azure Data Explorer MCP Server
Author: pab1it0

@pab1it0

Azure Data Explorer MCP Server について

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

基本情報

カテゴリ

データと分析

ライセンス

MIT

ランタイム

python

トランスポート

stdio

公開者

pab1it0

設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

{
  "mcpServers": {
    "adx-mcp-server": {
      "command": "docker",
      "args": [
        "build",
        "-t",
        "adx-mcp-server",
        "."
      ]
    }
  }
}

ツール

Query

Discovery

概要

What is Azure Data Explorer MCP Server?

An MCP server that enables AI assistants to execute KQL queries and explore Azure Data Explorer (ADX/Kusto) and Eventhouse databases through a standardized interface. It is for developers and analysts who want to query ADX clusters using AI-driven tools.

How to use Azure Data Explorer MCP Server?

Configure the required environment variables (ADX_CLUSTER_URL and ADX_DATABASE), log in to Azure via the Azure CLI, then add the server configuration to your MCP client (e.g., Claude Desktop). You can run it directly with uv, via Docker, or in a Dev Container.

Key features of Azure Data Explorer MCP Server

Execute arbitrary KQL queries and receive structured JSON results.
Discover tables, view schemas, sample data, and get table statistics.
Supports DefaultAzureCredential and Azure Workload Identity authentication.
Configurable transports: stdio, HTTP, and Server-Sent Events (SSE).
Docker images and Dev Container support for easy deployment.

Use cases of Azure Data Explorer MCP Server

AI assistants querying Azure Data Explorer databases on demand.
Automated data exploration and analysis through natural language.
Integrating ADX queries into MCP‑compatible clients like Claude Desktop.
Running ADX queries from CI/CD pipelines or containerized environments.

FAQ from Azure Data Explorer MCP Server

What authentication methods are supported?

The server uses DefaultAzureCredential by default and falls back to WorkloadIdentityCredential when the required environment variables are present (e.g., in AKS with workload identity).

What environment variables are required?

ADX_CLUSTER_URL (the cluster URL) and ADX_DATABASE (the database name) are required.

What Python version is required?

Python 3.12 is required.

Does the server support HTTP transport?

Yes. Set ADX_MCP_SERVER_TRANSPORT to http or sse and optionally configure ADX_MCP_BIND_HOST and ADX_MCP_BIND_PORT.

Can I run this server in Docker?

Yes. A Dockerfile and docker-compose configuration are provided. Pass the required environment variables to the container.

「データと分析」の他のコンテンツ

Google Analytics MCP Server

surendranb

Google Analytics 4 data to AI agents, agentic workflows, and MCP clients. Give agents analysis-ready access to website traffic, user behavior, and performance data with schema discovery, server-side aggregation, and safe defaults that reduce data wrangling.

225