Clickhouse Mcp Server
What is Clickhouse Mcp Server
clickhouse_mcp_server is a Model Context Protocol (MCP) server designed for ClickHouse, enabling integration with Large Language Models (LLMs) and other AI applications.
Use cases
Use cases include integrating ClickHouse with AI models for data analysis, building intelligent applications that require real-time data access, and enhancing data-driven decision-making processes.
How to use
To use clickhouse_mcp_server, clone the repository, install the required packages, set up ClickHouse connection details, and run the server using the command ‘python clickhouse_mcp_server/server.py’.
Key features
Key features include listing ClickHouse databases and tables as resources, retrieving table schemas, executing SELECT queries, and ensuring secure communication via the MCP protocol.
Where to use
clickhouse_mcp_server is suitable for applications that require data retrieval and manipulation from ClickHouse databases, particularly in AI and machine learning contexts.
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Overview
What is Clickhouse Mcp Server
clickhouse_mcp_server is a Model Context Protocol (MCP) server designed for ClickHouse, enabling integration with Large Language Models (LLMs) and other AI applications.
Use cases
Use cases include integrating ClickHouse with AI models for data analysis, building intelligent applications that require real-time data access, and enhancing data-driven decision-making processes.
How to use
To use clickhouse_mcp_server, clone the repository, install the required packages, set up ClickHouse connection details, and run the server using the command ‘python clickhouse_mcp_server/server.py’.
Key features
Key features include listing ClickHouse databases and tables as resources, retrieving table schemas, executing SELECT queries, and ensuring secure communication via the MCP protocol.
Where to use
clickhouse_mcp_server is suitable for applications that require data retrieval and manipulation from ClickHouse databases, particularly in AI and machine learning contexts.
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Content
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_server -
Install the required packages:
uv sync --all-extras -
Set 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.
Dev Tools Supporting MCP
The following are the main code editors that support the Model Context Protocol. Click the link to visit the official website for more information.
