ClickHouse MCP Server

Example Use Cases

• 1

  Execute safe, readonly SQL queries on a ClickHouse cluster to fetch analytics or metadata without risking data modifications.

• 2

  Query heterogeneous data sources (files, URLs, other databases) directly via chDB's embedded ClickHouse engine without performing ETL.

• 3

  A health-checked, environment-configurable MCP endpoint (stdio/http/sse) to integrate ClickHouse access into automated workflows or inspections.

Description

This MCP server provides tools to run readonly SQL against ClickHouse (run_select_query, list_databases, list_tables) and to execute queries using chDB's embedded ClickHouse engine (run_chdb_select_query). It supports stdio, HTTP, and SSE transports, includes a health-check endpoint, and is configurable entirely via environment variables. chDB support lets agents query data from files, URLs, and databases without ETL, while the ClickHouse tools let agents interact with existing ClickHouse clusters securely (readonly mode). The project is packaged for easy installation via PyPI and includes development/testing guidance.