clickhouse-mcp-agent 0.5.0b0

AI agent for ClickHouse database analysis via MCP

ClickHouse MCP Agent

AI agent for ClickHouse database analysis via MCP (Model Context Protocol).

Features

• Query ClickHouse databases using AI models
• Structured output: analysis, SQL used, confidence
• Easy connection management (predefined or custom)
• Conversational context and message history with robust summarization/pruning
• No CLI or environment setup required

Supported Providers

• OpenAI
• Anthropic
• Google Gemini
• Groq
• Mistral
• Cohere

Usage

• Configure your model, API key, and connection using the runtime config API.
• Run queries using the ClickHouseAgent.
• Multi-model/provider support is automatic—just set the API key for each provider.

See the examples/ directory for full, canonical usage scripts

Output

Each call to ClickHouseAgent.run() returns a RunResult object with the following fields:

• messages: The full (pruned) message history after the run (for conversational context).
• new_messages: Only the new messages generated in the latest turn.
• last_message: The last message in the conversation (usually the latest assistant response).
• usage: Token and usage statistics for the run.
• analysis: Natural language results with SQL queries (from the model output).
• sql_used: The SQL query that was executed.
• confidence: Confidence level (1-10) for the analysis.

This structure allows you to maintain conversational context, track usage, and access both the structured and conversational outputs of each query.

Requirements

• Python 3.10+
• AI API key for your chosen provider (OpenAI, Anthropic, Google/Gemini, Groq, Mistral, Cohere)

All dependencies are handled by pyproject.toml.

Roadmap

✅ Completed Features

• MCP Integration: PydanticAI + ClickHouse MCP server integration
• Query Execution: SQL query generation and execution via MCP
• Schema Inspection: Database, table, and column exploration
• Connection Management: Multiple connection configurations (playground, custom)
• RBAC Support: Per-query user credentials via config
• Dynamic Connections: Runtime connection configuration, no environment dependencies
• Direct API Key Passing: Pass AI API keys directly to agent (model_api_key)
• Structured Output: ClickHouseOutput with analysis, SQL, and confidence
• Type Safety: Full type annotations and mypy compliance
• Code Quality: Black formatting, isort, flake8 linting
• Multi-Model Support: Runtime selection of provider/model and API key management
• Message History: Robust message_history parameter for conversational context with summarization and pruning
• Conversational Agent: Persistent memory and context across queries

🚧 Planned / In Progress

• Improved Error Handling: More robust error and exception management
• Advanced Output Formatting: Customizable output for downstream applications

---

Contributing

Open an issue or pull request for features or fixes.