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
