Azure ADX

Azure ADX

Query and analyze Azure Data Explorer databases.

49
Stars
23
Forks
11
Releases

Overview

This MCP server enables AI assistants to query Azure Data Explorer (ADX/Kusto) databases and Eventhouse clusters via standardized MCP interfaces. It supports executing arbitrary KQL queries against a configured ADX database and returning results in JSON format for easy consumption. Discovery capabilities include listing tables, viewing table schemas and column types, sampling table data with configurable sizes, and retrieving detailed table statistics such as row counts and storage metrics. Authentication is provided via DefaultAzureCredential (Azure CLI, Managed Identity, etc.) and native Workload Identity for AKS environments, with a token file path option; if workload identity variables are not present, the server falls back to DefaultAzureCredential. Deployment options include multiple transports (stdio by default, HTTP, and Server-Sent Events), Docker container deployment, and a development Dev Container experience. The set of tools exposed by the MCP server is configurable, allowing you to tailor the MCP client surface to only the functionality you need for your use case.

Details

Owner
pab1it0
Language
Python
License
MIT License
Updated
2025-12-07

Features

Execute KQL queries

Run arbitrary KQL queries against Azure Data Explorer databases.

Structured results

Return query results formatted as JSON for easy consumption.

List tables

Discover all tables in the configured database.

View table schemas

Inspect table schemas and column types.

Sample data

Preview table contents with configurable sample sizes.

Table statistics

Provide detailed metadata including row counts and storage size.

Azure authentication

Supports DefaultAzureCredential and Workload Identity for AKS; flexible credential options.

Deployment options

Supports multiple transports (stdio, HTTP, SSE) and Docker/Dev Container deployment.

Audience

AI assistantsExecute KQL queries and explore ADX data via MCP server.
Developers integrating MCP clientsIntegrate MCP-enabled ADX querying into applications and workflows.

Tags

Azure Data ExplorerADXKustoMCPQueryDiscoveryAuthenticationDockerSSEHTTPstdioAKSWorkload IdentityEventhouseMicrosoft FabricAI assistants