kusto-mcp
If you are the rightful owner of kusto-mcp and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
A configurable MCP server that converts natural language into Kusto queries and executes them against a Kusto database.
The Natural Language to Kusto Query MCP Server is a powerful tool designed to bridge the gap between human language and database query languages. By leveraging the capabilities of Azure OpenAI and Kusto databases, this server allows users to input natural language prompts and receive corresponding Kusto queries. The server is highly configurable, allowing users to define multiple databases and tables within a `settings.yaml` file. This flexibility ensures that the server can be tailored to meet the specific needs of various database environments. The server not only generates queries but can also execute them, providing results in JSON or CSV formats. This makes it an invaluable tool for data analysts and developers who need to quickly translate business questions into actionable database queries.
Features
- Fully configurable: Provide a `settings.yaml` file to customize the query generation for any database.
- Generate: Converts natural language prompts into Kusto queries.
- Execute: Generates and executes queries, outputting results in JSON or CSV.
- Multiple databases: Supports configuration of multiple databases in `settings.yaml`.
Tools
list-supported-tables
Lists the supported tables as provided in the
settings.yamlfile.generate-kusto-query
Generates a Kusto query against the provided table for the given prompt.
execute-kusto-query
Generates and executes a Kusto query against the provided table for the given prompt.
