pab1it0/adx-mcp-server

开发工具

本页由 AI 翻译，技术细节请以原文为准。查看原文

59 stars 24 forks 质量 73 趋势 13MIT

Repository Install

pab1it0/adx-mcp-server 是从 https://github.com/pab1it0/adx-mcp-server. 导入的 MCP 服务器候选

概览

pab1it0/adx-mcp-server 是从 https://github.com/pab1it0/adx-mcp-server. 导入的 MCP 服务器候选

概述（AI 翻译）

一个[模型上下文协议][mcp]（MCP）服务器，使AI助手能够执行KQL查询并通过标准化接口探索Azure数据探测器（ADX/Kusto）数据库。

该服务器提供对Azure Data Explorer和Eventhouse（Microsoft Fabric中的）集群的无缝访问，使AI助手能够利用强大的Kusto查询语言查询和分析您的数据。

[mcp]： https://modelcontextprotocol.io

特色

查询执行

执行KQL查询 - 对你的ADX数据库运行任意KQL查询
结构化结果 - 将结果格式化为JSON，便于使用。

数据库发现

列表表 - 发现数据库中的所有表
查看模式 - 检查表模式和列类型
样本数据 - 预览表内容及可配置的样本大小
表统计 - 获取包括行数和存储容量在内的详细元数据

认证

DefaultAzureCredential - 支持 Azure CLI、托管身份等
工作负载身份 - 原生支持 AKS 工作负载身份
灵活凭证 - 支持多种Azure认证方法

部署选项

本页由 AI 翻译，技术细节请以原文为准。

README

以下为原文 README 节选，完整内容请查看原文。

Azure Data Explorer MCP Server

A Model Context Protocol (MCP) server that enables AI assistants to execute KQL queries and explore Azure Data Explorer (ADX/Kusto) databases through standardized interfaces.

This server provides seamless access to Azure Data Explorer and Eventhouse (in Microsoft Fabric) clusters, allowing AI assistants to query and analyze your data using the powerful Kusto Query Language.

Features

Query Execution

Execute KQL queries - Run arbitrary KQL queries against your ADX database
Structured results - Get results formatted as JSON for easy consumption

Database Discovery

List tables - Discover all tables in your database
View schemas - Inspect table schemas and column types
Sample data - Preview table contents with configurable sample sizes
Table statistics - Get detailed metadata including row counts and storage size

Authentication

DefaultAzureCredential - Supports Azure CLI, Managed Identity, and more
Workload Identity - Native support for AKS workload identity
Flexible credentials - Works with multiple Azure authentication methods

Deployment Options

Multiple transports - stdio (default), HTTP, and Server-Sent Events (SSE)
Docker support - Production-ready container images with security best practices
Dev Container - Seamless development experience with GitHub Codespaces

The list of tools is configurable, so you can choose which tools you want to make available to the MCP client. This is useful if you don’t use certain functionality or if you don’t want to take up too much of the context window.

Usage

Login to your Azure account which has the permission to the ADX cluster using Azure CLI.
Configure the environment variables for your ADX cluster, either through a .env file or system environment variables:

# Required: Azure Data Explorer configuration
ADX_CLUSTER_URL=https://yourcluster.region.kusto.windows.net
ADX_DATABASE=your_database

# Optional: Azure Workload Identity credentials 
# AZURE_TENANT_ID=your-tenant-id
# AZURE_CLIENT_ID=your-client-id 
# ADX_TOKEN_FILE_PATH=/var/run/secrets/azure/tokens/azure-identity-token

# Optional: Custom MCP Server configuration

在 GitHub 查看完整 README

安装

docker run --rm -i -e ADX_CLUSTER_URL -e ADX_DATABASE -e AZURE_TENANT_ID -e AZURE_CLIENT_ID -e ADX_TOKEN_FILE_PATH adx-mcp-server

新手？先看 mcpskill.org 教程 →

配置

{
  "mcpServers": {
    "adx": {
      "command": "uv",
      "args": [
        "--directory",
        "<full path to adx-mcp-server directory>",
        "run",
        "src/adx_mcp_server/main.py"
      ],
      "env": {
        "ADX_CLUSTER_URL": "https://yourcluster.region.kusto.windows.net",
        "ADX_DATABASE": "your_database"
      }
    }
  }
}