%20--%3e%3cdefs%3e%3cstyle%3e%20.st0%20{%20fill:%20%23061b40;%20}%20.st1%20{%20fill:%20%23306af1;%20}%20.st2%20{%20fill:%20%235ce5cf;%20}%20%3c/style%3e%3c/defs%3e%3cg%3e%3cpath%20class='st0'%20d='M55,10.5h9v3h-9v9h12V7.5h-12v3ZM64,19.5h-6v-3h6v3Z'/%3e%3cpolygon%20class='st0'%20points='69%2016.5%2078%2016.5%2078%2019.5%2069%2019.5%2069%2022.5%2081%2022.5%2081%2013.5%2072%2013.5%2072%2010.5%2081%2010.5%2081%207.5%2069%207.5%2069%2016.5'/%3e%3cpolygon%20class='st0'%20points='95%2010.5%2095%207.5%2083%207.5%2083%2022.5%2095%2022.5%2095%2019.5%2086%2019.5%2086%2016.5%2095%2016.5%2095%2013.5%2086%2013.5%2086%2010.5%2095%2010.5'/%3e%3cpath%20class='st0'%20d='M40,1.5v21h11.6l1.4-1.4v-7.6h0c0,0-1.4-1.5-1.4-1.5l1.4-1.4V2.9l-1.4-1.4h-11.6ZM50,19.5h-7v-6h7v6ZM50,10.5h-7v-6h7v6Z'/%3e%3c/g%3e%3cpath%20class='st1'%20d='M23.1,24L14.7,4.8l-4.9,11.2h3.8l-1.8,4H3.3L12.1,0H2C.9,0,0,.9,0,2v20c0,1.1.9,2,2,2h21.1Z'/%3e%3cpath%20class='st2'%20d='M34,0h-16.8l10.6,24h6.2c1.1,0,2-.9,2-2V2C36,.9,35.1,0,34,0ZM32.5,20h-4V4h4v16Z'/%3e%3c/svg%3e)
Mysql Kusto MCP
What is the Kusto Chat App?
This application allows users to interact with Kusto databases using natural language queries. It leverages Azure OpenAI's large language model (LLM) to understand and translate conversational queries into Kusto Query Language (KQL).How does it work?
The app uses the Model Context Protocol (MCP) Client/Server framework where the client handles user interactions and the server processes the queries with Azure OpenAI's LLM.Use Cases
Ideal for data analysts and engineers who want to query Kusto databases without writing complex KQL queries. Also useful for quick data exploration and ad-hoc reporting.Key Features
Natural Language ProcessingUnderstands and converts conversational English queries into Kusto queries
Azure OpenAI IntegrationLeverages powerful language models from Azure OpenAI service
MCP FrameworkUses the Model Context Protocol for efficient client-server communication
Azure CLI AuthenticationSimplifies authentication using existing Azure CLI credentials
Pros and Cons
Advantages
No need to learn Kusto Query Language (KQL)
Fast setup using existing Azure credentials
Conversational interface makes data exploration intuitive
Powered by state-of-the-art Azure OpenAI models
Limitations
Requires Azure OpenAI service access
Dependent on Azure CLI for authentication
May need refinement for complex queries
Currently command-line only (no GUI)
Getting Started
Install Prerequisites
Ensure you have Python and pip installed on your system
%20--%3e%3cdefs%3e%3cstyle%3e%20.st0%20{%20fill:%20%230080ff;%20}%20%3c/style%3e%3c/defs%3e%3cpath%20class='st0'%20d='M16.2,11.1c.4.5.4,1.2,0,1.8l-4.7,7.1h-3.8l5.3-8L7.6,4h3.8l4.7,7.1Z'/%3e%3c/svg%3e)
Azure Login
Authenticate with Azure using the Azure CLI
Setup Environment
Clone the repository and install dependencies
Configure Azure OpenAI
Create a .env file with your Azure OpenAI credentials
Run the Application
Start the client which will automatically launch the server
Example Queries
Basic Data QueryAsk for specific data from your Kusto database
Trend AnalysisRequest trend information over time
Frequently Asked Questions
How do I get Azure OpenAI credentials?
Can I use this without Azure CLI authentication?
How accurate are the generated Kusto queries?
Can I customize the OpenAI model used?
Additional Resources
Azure OpenAI Service
Official Azure OpenAI service portal
Kusto Query Language Documentation
Official KQL documentation
Azure CLI Documentation
Official Azure CLI documentation
精選MCP服務推薦
Markdownify MCP
Markdownify是一個多功能文件轉換服務，支持將PDF、圖片、音頻等多種格式及網頁內容轉換為Markdown格式。
TypeScript
1.7K
5分
Baidu Map
已認證
百度地圖MCP Server是國內首個兼容MCP協議的地圖服務，提供地理編碼、路線規劃等10個標準化API接口，支持Python和Typescript快速接入，賦能智能體實現地圖相關功能。
Python
714
4.5分
Firecrawl MCP Server
Firecrawl MCP Server是一個集成Firecrawl網頁抓取能力的模型上下文協議服務器，提供豐富的網頁抓取、搜索和內容提取功能。
TypeScript
3.9K
5分
Sequential Thinking MCP Server
一個基於MCP協議的結構化思維服務器，通過定義思考階段幫助分解複雜問題並生成總結
Python
278
4.5分
Context7
Context7 MCP是一個為AI編程助手提供即時、版本特定文檔和代碼示例的服務，通過Model Context Protocol直接集成到提示中，解決LLM使用過時信息的問題。
TypeScript
5.2K
4.7分
Magic MCP
Magic Component Platform (MCP) 是一個AI驅動的UI組件生成工具，通過自然語言描述幫助開發者快速創建現代化UI組件，支持多種IDE集成。
JavaScript
1.7K
5分
Edgeone Pages MCP Server
EdgeOne Pages MCP是一個通過MCP協議快速部署HTML內容到EdgeOne Pages並獲取公開URL的服務
TypeScript
259
4.8分
Notion Api MCP
已認證
一個基於Python的MCP服務器，通過Notion API提供高級待辦事項管理和內容組織功能，實現AI模型與Notion的無縫集成。
Python
127
4.5分