Integrations
Used for loading environment variables from a .env file for configuration of the Azure Data Explorer connection details and authentication credentials.
Supports comprehensive testing of the MCP server functionality, including configuration validation, server operation, and error handling tests.
Azure Data Explorer MCP Server
A Model Context Protocol (MCP) server for Azure Data Explorer/Eventhouse in Microsoft Fabric.
This provides access to your Azure Data Explorer/Eventhouse clusters and databases through standardized MCP interfaces, allowing AI assistants to execute KQL queries and explore your data.
Features
- Execute KQL queries against Azure Data Explorer
- Discover and explore database resources
- List tables in the configured database
- View table schemas
- Sample data from tables
- Get table statistics/details
- Authentication support
- Token credential support (Azure CLI, MSI, etc.)
- Workload Identity credential support for AKS
- Docker containerization support
- Provide interactive tools for AI assistants
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:
Azure Workload Identity Support
The server now uses WorkloadIdentityCredential by default when running in Azure Kubernetes Service (AKS) environments with workload identity configured. It prioritizes the use of WorkloadIdentityCredential whenever the necessary environment variables are present.
For AKS with Azure Workload Identity, you only need to:
- Make sure the pod has
AZURE_TENANT_ID
andAZURE_CLIENT_ID
environment variables set - Ensure the token file is mounted at the default path or specify a custom path with
ADX_TOKEN_FILE_PATH
If these environment variables are not present, the server will automatically fall back to DefaultAzureCredential, which tries multiple authentication methods in sequence.
- Add the server configuration to your client configuration file. For example, for Claude Desktop:
Note: if you see
Error: spawn uv ENOENT
in Claude Desktop, you may need to specify the full path touv
or set the environment variableNO_UV=1
in the configuration.
Docker Usage
This project includes Docker support for easy deployment and isolation.
Building the Docker Image
Build the Docker image using:
Running with Docker
You can run the server using Docker in several ways:
Using docker run directly:
Using docker-compose:
Create a .env
file with your Azure Data Explorer credentials and then run:
Running with Docker in Claude Desktop
To use the containerized server with Claude Desktop, update the configuration to use Docker with the environment variables:
This configuration passes the environment variables from Claude Desktop to the Docker container by using the -e
flag with just the variable name, and providing the actual values in the env
object.
Using as a Dev Container / GitHub Codespace
This repository can also be used as a development container for a seamless development experience. The dev container setup is located in the devcontainer-feature/adx-mcp-server
folder.
For more details, check the devcontainer README.
Development
Contributions are welcome! Please open an issue or submit a pull request if you have any suggestions or improvements.
This project uses uv
to manage dependencies. Install uv
following the instructions for your platform:
You can then create a virtual environment and install the dependencies with:
Project Structure
The project has been organized with a src
directory structure:
Testing
The project includes a comprehensive test suite that ensures functionality and helps prevent regressions.
Run the tests with pytest:
Tests are organized into:
- Configuration validation tests
- Server functionality tests
- Error handling tests
- Main application tests
When adding new features, please also add corresponding tests.
Tools
Tool | Category | Description |
---|---|---|
execute_query | Query | Execute a KQL query against Azure Data Explorer |
list_tables | Discovery | List all tables in the configured database |
get_table_schema | Discovery | Get the schema for a specific table |
sample_table_data | Discovery | Get sample data from a table with optional sample size |
License
MIT
You must be authenticated.
remote-capable server
The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.
AI assistants to query and analyze Azure Data Explorer databases through standardized interfaces.
- Features
- Usage
- Docker Usage
- Using as a Dev Container / GitHub Codespace
- Development
- Project Structure
- License
Related Resources
Related MCP Servers
- AsecurityAlicenseAqualityAllows AI assistants to list tables, read data, and execute SQL queries through a controlled interface, making database exploration and analysis safer and more structured.Last updated -1360PythonMIT License
- -securityFlicense-qualityEnables AI assistants to interact with Metabase databases and dashboards, allowing users to list and execute queries, access data visualizations, and interact with database resources through natural language.Last updated -9JavaScript
- -securityAlicense-qualityAn easy-to-use bridge that lets AI assistants like Claude and Cursor IDE directly query and explore Microsoft SQL Server databases. No coding experience required!Last updated -25JavaScriptGPL 3.0
- -securityFlicense-qualityEnables AI assistants to interact with Metabase, providing access to dashboards, questions, databases, and tools for executing queries and viewing data through natural language.Last updated -JavaScript