Enables seamless integration with ClickHouse databases, allowing listing of databases and tables, retrieving table schemas, and executing SELECT queries against ClickHouse data.
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.
List ClickHouse databases and tables as resources
Retrieve table schemas
Execute SELECT queries on ClickHouse databases
Secure and efficient communication using the MCP protocol
Python 3.10+
ClickHouse server
Clone the repository:
Install the required packages:
Set up your ClickHouse connection details in environment variables or update the get_clickhouse_client function in server.py.
Run the server:
The server will start and listen for MCP requests.
Run the tests using pytest:
Contributions are welcome! Please feel free to submit a Pull Request.
This project is licensed under the MIT License.
This server cannot be installed
hybrid server
The server is able to function both locally and remotely, depending on the configuration or use case.
A Model Context Protocol server that enables Large Language Models to seamlessly interact with ClickHouse databases, supporting resource listing, schema retrieval, and query execution.
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/ThomAub/clickhouse_mcp_server'
If you have feedback or need assistance with the MCP directory API, please join our Discord server