%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
A Kusto query chat application based on Azure OpenAI, implementing client/server interaction through the MCP framework.
rating : 2 points
downloads : 10
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
Featured MCP Services
Duckduckgo MCP Server
Certified
The DuckDuckGo Search MCP Server provides web search and content scraping services for LLMs such as Claude.
Python
837
4.3 points
Markdownify MCP
Markdownify is a multi-functional file conversion service that supports converting multiple formats such as PDFs, images, audio, and web page content into Markdown format.
TypeScript
1.7K
5 points
Gitlab MCP Server
Certified
The GitLab MCP server is a project based on the Model Context Protocol that provides a comprehensive toolset for interacting with GitLab accounts, including code review, merge request management, CI/CD configuration, and other functions.
TypeScript
97
4.3 points
Notion Api MCP
Certified
A Python-based MCP Server that provides advanced to-do list management and content organization functions through the Notion API, enabling seamless integration between AI models and Notion.
Python
150
4.5 points
Unity
Certified
UnityMCP is a Unity editor plugin that implements the Model Context Protocol (MCP), providing seamless integration between Unity and AI assistants, including real - time state monitoring, remote command execution, and log functions.
C#
572
5 points
Figma Context MCP
Framelink Figma MCP Server is a server that provides access to Figma design data for AI programming tools (such as Cursor). By simplifying the Figma API response, it helps AI more accurately achieve one - click conversion from design to code.
TypeScript
6.7K
4.5 points
Context7
Context7 MCP is a service that provides real-time, version-specific documentation and code examples for AI programming assistants. It is directly integrated into prompts through the Model Context Protocol to solve the problem of LLMs using outdated information.
TypeScript
5.2K
4.7 points
Gmail MCP Server
A Gmail automatic authentication MCP server designed for Claude Desktop, supporting Gmail management through natural language interaction, including complete functions such as sending emails, label management, and batch operations.
TypeScript
289
4.5 points