1. Background
An MCP Server for Kusto which is connected to a Chat app with MCP client for answering user queries related to their data in Kusto cluster
nitishsharma25
README
1. Background
This Chat app can answer kusto queries in conversational manner. In the backend, it uses the MCP Client/Server framework and AzureOpenAI's LLM.
2. Prerequisites
- Python
- pip
- Azure OpenAI's parameters
3. Setup environment
az login
Current code uses Az CLI authentication for connection to kusto, so perform the above step before running the app.
Clone the repo, activate virtual environment and install dependencies for client and server:
git clone <this repo>
virtualenv .venv
.venv/scripts/activate
pip install -r kusto-mcp-client/requirements.txt
pip install -r kusto-mcp-server/requirements.txt
cd kusto-mcp-client
- Create a .env file inside kusto-mcp-client directory and add the following variables:
- Go to the Azure OpenAI Service page in Azure AI Foundry portal.
- Find them as mentioned in the picture below:
AZUREOPENAI_API_KEY = ""
AZUREOPENAI_ENDPOINT = ""
AZUREOPENAI_API_VERSION = ""
AZUREOPENAI_MODEL = ""
4. How to run sample project
From Inside kusto-mcp-client dir, run the below command:
python main.py "../kusto-mcp-server/main.py"
- Enter your queries in the terminal as show in this picture and start chatting
- To start a new session, enter quit and start the client again
Recommended Servers
playwright-mcp
A Model Context Protocol server that enables LLMs to interact with web pages through structured accessibility snapshots without requiring vision models or screenshots.
Magic Component Platform (MCP)
An AI-powered tool that generates modern UI components from natural language descriptions, integrating with popular IDEs to streamline UI development workflow.
MCP Package Docs Server
Facilitates LLMs to efficiently access and fetch structured documentation for packages in Go, Python, and NPM, enhancing software development with multi-language support and performance optimization.
Claude Code MCP
An implementation of Claude Code as a Model Context Protocol server that enables using Claude's software engineering capabilities (code generation, editing, reviewing, and file operations) through the standardized MCP interface.
@kazuph/mcp-taskmanager
Model Context Protocol server for Task Management. This allows Claude Desktop (or any MCP client) to manage and execute tasks in a queue-based system.
Linear MCP Server
Enables interaction with Linear's API for managing issues, teams, and projects programmatically through the Model Context Protocol.
mermaid-mcp-server
A Model Context Protocol (MCP) server that converts Mermaid diagrams to PNG images.
Jira-Context-MCP
MCP server to provide Jira Tickets information to AI coding agents like Cursor
Linear MCP Server
A Model Context Protocol server that integrates with Linear's issue tracking system, allowing LLMs to create, update, search, and comment on Linear issues through natural language interactions.
Sequential Thinking MCP Server
This server facilitates structured problem-solving by breaking down complex issues into sequential steps, supporting revisions, and enabling multiple solution paths through full MCP integration.