This MCP server integrates with ClickHouse, providing a bridge between MCP and ClickHouse's powerful analytical database capabilities. Developed by iskakaushik, it enables seamless interaction with ClickHouse features like executing SQL queries, listing databases, and retrieving table information through the MCP protocol. The implementation is built using Python 3.13+ and leverages libraries like FastMCP and clickhouse-connect for MCP and ClickHouse compatibility respectively. It's designed for data analysts and engineers who want to incorporate AI assistance into their ClickHouse workflows, allowing for natural language queries and exploration of large datasets while maintaining read-only safeguards.
暂无评论. 成为第一个评论的人!
登录以参与讨论
Execute SQL queries on your ClickHouse cluster. Input: sql (string): The SQL query to execute.
List all databases on your ClickHouse cluster.
List tables in a database with pagination. Required input: database (string). Optional inputs: like / not_like (string), page_token (string), page_size (int, default 50), include_detailed_columns (bool, default true).
Execute SQL queries using chDB's embedded ClickHouse engine. Input: sql (string): The SQL query to execute.