ksagala/mcp-kql-server

이 페이지는 AI로 자동 번역되었습니다. 기술적인 세부 사항은 원문을 확인하세요. 원문 보기

0 stars 6 forks 품질 57 트렌드 0

A Model Context Protocol (MCP) server for executing Kusto Query Language (KQL) queries against Azure Data Explorer clusters.

개요

A Model Context Protocol (MCP) server for executing Kusto Query Language (KQL) queries against Azure Data Explorer clusters. Seamlessly integrates with Claude Desktop and Visual Studio Code (VS Code). Supports Azure CLI authentication and provides a convenient kql_execute tool for directly within your , complete with optional visualizations. - : Run KQL queries directly within your AI prompts using the kql_execute MCP tool. - : No manual tenant ID configuration or complex credential management. Simply authenticate via Azure CLI (az login) and start querying immediately. - : Execute KQL queries within Claude Desktop without switching interfaces or dashboards. - : Leverages Azure CLI’s robust authentication, ensuring secure credential handling and optimized query performance. - : Optional Markdown table outputs make data analysis intuitive and engaging. - : Built-in Azure CLI authentication with retry and caching logic. - : Fully compatible with MCP protocol version 2024-11-05.

README

원문 README의 일부입니다. 원문 보기.

🚀 MCP KQL Server

✨ Features

🔍 Execute KQL Queries: Run KQL queries directly within your AI prompts using the kql_execute MCP tool.
⚡ Plug-and-Play Simplicity: No manual tenant ID configuration or complex credential management. Simply authenticate via Azure CLI (az login) and start querying immediately.
🤖 Seamless Claude Integration: Execute KQL queries within Claude Desktop without switching interfaces or dashboards.
🔒 Secure and Efficient: Leverages Azure CLI’s robust authentication, ensuring secure credential handling and optimized query performance.
📊 Visualization Ready: Optional Markdown table outputs make data analysis intuitive and engaging.
🔑 Azure CLI Authentication: Built-in Azure CLI authentication with retry and caching logic.
📡 Protocol Compatibility: Fully compatible with MCP protocol version 2024-11-05.
🛠️ Reliable Implementation: Uses fastmcp for a robust and reliable MCP server implementation.

📌 Comparison with Other Tools

Feature	MCP KQL Server	Azure Data Explorer MCP	Standalone Scripts
Claude Integration	✅	❌	❌
Plug-and-Play Authentication	✅ (Azure CLI)	❌ (Manual setup)	❌ (Custom code)
No Tenant ID Required	✅	❌	❌
Data Visualization	✅	✅	❌
Open-Source	✅	✅	Varies

📋 Requirements

Python 3.10 or higher
Azure Data Explorer cluster access
Azure CLI installed and authenticated (az login)
Node.js (optional, for Claude Desktop filesystem server)
VS Code with Claude extension or MCP client (for VS Code integration)

📂 Project Structure

mcp-kql-server/
├── mcp_kql_server/
│   ├── __init__.py
│   ├── mcp_server.py
│   ├── kql_auth.py
│   └── execute_kql.py
├── pyproject.toml
├── README.md

🏗️ Setup Instructions

1️⃣ Clone the Repository

git clone https://github.com/4R9UN/mcp-kql-server.git
cd mcp-kql-server

2️⃣ Install Python 3.10+

Windows:
```
winget install Python.Python.3.10
```
macOS:
```
brew install [email protected]
```
Linux:
```
sudo apt-get install python3.10
```

GitHub에서 전체 README 보기

설치

This server does not publish a one-line install command.

Open the repository installation guide MCP 초보자라면? mcpskill.org 가이드부터 시작하세요 →

설정

{
  "mcpServers": {
    "mcp-kql-server": {
      "command": "C:\\Users\\YourUser\\mcp-kql-server\\.venv\\Scripts\\python.exe",
      "args": [
        "-m",
        "mcp_kql_server.mcp_server"
      ]
    }
  }
}