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

1. Clone the repository: git clone https://github.com/ThomAub/clickhouse_mcp_server.git cd clickhouse_mcp_server

2. Install the required packages: uv sync --all-extras

3. Set up your ClickHouse connection details in environment variables or update the get_clickhouse_client function in server.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.