Azure Data Explorer MCP Server

@pab1it0

リポジトリ

基本情報

カテゴリ

データと分析

ライセンス

MIT

トランスポート

stdio

作者

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.

Azure Data Explorer MCP Server の設定

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

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

Azure Data Explorer 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.

よくある質問

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.

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

TofuBofu AI Visibility

Arnav Neil

TofuBofu runs a free AI visibility scan for any B2B company, right inside your AI assistant. Ask it to scan a domain and it runs the questions real buyers ask across ChatGPT, Claude, Gemini, Perplexity, Google AI Overvie

Rankbits

rankbits

AI visibility analytics across 15+ providers (ChatGPT, Perplexity, Gemini, AI Overviews, and more). The MCP connector lets assistants run scans, compare competitor mentions, and track your brand's visibility in AI answer

AskRentAI

Ask your Rent Manager property portfolio anything, from the AI you already use. AskRentAI is a hosted, read-only MCP server for Rent Manager, the property management platform used across a large share of US rental housi

Social Growth Engineers

Top In It

The research behind short-form growth for your AI assistant: viral TikTok and Reels videos, the hooks that made them work, app growth playbooks, articles and reports.

Sugra API MCP

Sugra Systems, Inc.

Official MCP server for the Sugra API, giving AI agents source-attributed access to 1,500+ endpoints across 36 data domains from 160+ primary sources. Covers markets, economics, company fundamentals, government, news, cl