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
An MCP (Model Context Protocol) server for performing accessibility audits on webpages using axe-core. Use the results in...
An MCP server for creating 2D/3D game assets from text using Hugging Face AI models.
A basic JS VM as an MCP server
Query MCP enables end-to-end management of Supabase via chat interface: read & write query executions, management API support,...
This repository hosts the “Weapon Recoil Generator” MCP Server deployed on Smithery.
An MCP server implementation that provides tools for interacting with the [Twitter/X API v2](https://docs.x.com/x-api/introduction).
A TypeScript-based MCP-server tool enabling concurrent chains of thought with real-time reinforcement learning. Seamlessly integrates with Neo4j for...
Featured Templates
View More
