clickhouse-mcp
If you are the rightful owner of clickhouse-mcp 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.
ClickHouse Readonly MCP is a FastMCP server designed for executing read-only ClickHouse queries, supporting local Python API integration and standalone service operation.
ClickHouse Readonly MCP is a specialized server that facilitates the execution of read-only SQL queries on ClickHouse databases. It is designed to integrate seamlessly with Python applications or operate as a standalone service. The server ensures that only non-destructive operations such as SELECT, SHOW, DESCRIBE, and EXPLAIN are executed, providing a secure environment for data retrieval. It supports both HTTP and native ClickHouse connection methods, with automatic failover to ensure reliability. The server outputs results in a simple tabular format and supports parameterized queries, enhancing flexibility and performance. With its high-performance query execution and result processing capabilities, ClickHouse Readonly MCP is an ideal solution for applications requiring efficient data access without the risk of data modification.
Features
- Supports execution of read-only SQL queries via MCP tools
- Input validation to ensure only SELECT, SHOW, DESCRIBE, EXPLAIN operations
- Supports HTTP and native ClickHouse connection with automatic failover
- Simple tabular format for output results
- Supports parameterized queries for enhanced flexibility
