clickhouse-mcp-server
If you are the rightful owner of clickhouse-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
A Clickhouse database MCP server project.
The Clickhouse MCP server is a specialized server designed to facilitate seamless interaction with Clickhouse databases using the Model Context Protocol (MCP). It provides tools for connecting to databases and executing SQL queries, making it an essential component for developers and data analysts working with Clickhouse. The server can be installed using either 'uv' or 'pip', and it supports configuration through environment variables to specify connection details such as host, user, and password. The server is also compatible with Claude Desktop and can be installed via Smithery for easy integration. Additionally, it offers development tools for building, publishing, and debugging, ensuring a smooth workflow for developers.
Features
- Easy installation via 'uv' or 'pip'.
- Supports connection to specific Clickhouse databases.
- Executes SQL queries and returns results in JSON format.
- Configurable through environment variables for flexible setup.
- Compatible with Claude Desktop and Smithery for seamless integration.
Tools
connect_database
Connect to a specific Clickhouse database
execute_query
Execute Clickhouse query