ClickHouse MCP Server
This project implements a Model Context Protocol (MCP) server for ClickHouse, allowing seamless integration of ClickHouse databases with Large Language Models (LLMs) and other AI applications.
Features
- List ClickHouse databases and tables as resources
- Retrieve table schemas
- Execute SELECT queries on ClickHouse databases
- Secure and efficient communication using the MCP protocol
Requirements
- Python 3.10+
- ClickHouse server
Installation
Clone the repository:
git clone https://github.com/ThomAub/clickhouse_mcp_server.git cd clickhouse_mcp_serverInstall the required packages:
uv sync --all-extrasSet up your ClickHouse connection details in environment variables or update the
get_clickhouse_clientfunction inserver.py.
Usage
Run the server:
python clickhouse_mcp_server/server.py
The server will start and listen for MCP requests.
Testing
Run the tests using pytest:
pytest tests/
Contributing
Contributions are welcome! Please feel free to submit a Pull Request.
License
This project is licensed under the MIT License.
ClickHouse MCP Server
Project Details
- ThomAub/clickhouse_mcp_server
- MIT License
- Last Updated: 12/18/2024
Recomended MCP Servers
Monitor browser logs directly from Cursor and other MCP compatible IDEs.
A Model Context Protocol server providing LLM Agents a second opinion via AI-powered Deepseek-Reasoning R1 mentorship capabilities, including...
MCP server that connects to Replicate image generation api - example to connect to Windsurfer
A high-throughput and memory-efficient inference and serving engine for LLMs
An MCP (Model Context Protocol) server for interacting with Android devices through ADB in TypeScript.
Talk to your cloud data using CloudZero API and Model Context Protocol (MCP) server for LLM tool calling
This package lets you start Vapi calls directly in your Python application.
MCP server for Liveblocks.
MCP server to work with Telegram through MTProto
Featured Templates
View More
