cheng306/mcp-server
If you are the rightful owner of mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to dayong@mcphub.com.
Azure Data Explorer MCP Server allows users to login and run KQL queries on Azure Data Explorer using a Model Context Protocol server.
Azure Data Explorer MCP Server
This is a Model Context Protocol (MCP) server that can login to Azure Data Explorer and run KQL queries.
Features
- Login to Azure Data Explorer using service principal (client credentials)
- Run KQL queries against an Azure Data Explorer database
- View formatted query results
Prerequisites
- Node.js (v16 or higher)
- npm (v7 or higher)
- Azure Data Explorer cluster
- Service Principal with access to Azure Data Explorer
Setup
- Clone or download this repository
- Install dependencies:
npm install
- Build the project:
npm run build
Running the server
Start the server:
npm start
The server will listen on standard input/output (stdio), which is the format expected by MCP clients like Claude for Desktop.
Usage with Claude for Desktop
- Configure Claude for Desktop to use this MCP server by editing the
claude_desktop_config.jsonfile:
{
"mcpServers": {
"adx-query-server": {
"command": "node",
"args": [
"/absolute/path/to/this/repository/build/index.js"
]
}
}
}
-
Restart Claude for Desktop
-
Use the MCP server through Claude by asking it to:
- Login to Azure Data Explorer
- Run KQL queries
Available Tools
login-to-adx
Authenticates with Azure Data Explorer using client credentials.
Parameters:
cluster: The ADX cluster URL (e.g., https://mycluster.eastus.kusto.windows.net)database: The database nametenantId: The Azure tenant IDclientId: The Azure client/application IDclientSecret: The Azure client secret
run-adx-query
Runs a KQL query against the connected Azure Data Explorer database.
Parameters:
query: The KQL query to execute
Development
To run the server in development mode:
npm run dev
License
ISC