ClickHouse MCP

ClickHouse MCP is the official Model Context Protocol server for ClickHouse, the column-oriented database used for analytics at high volume. It gives an assistant a direct SQL path into a ClickHouse deployment, whether that is ClickHouse Cloud, a self-managed cluster, or the embedded engine, so questions get answered against real rows instead of a summary somebody pasted into the chat. The tool surface is small on purpose. The server lists the databases on a server, lists the tables in a database with their schemas, and runs a SELECT query returning the result set. Queries execute with read-only settings applied, so an agent cannot mutate or drop anything even if it generates a statement that tries, and the connection uses whatever ClickHouse user you configure, meaning row and column grants still hold. Some builds also expose the cloud management API so an agent can inspect services in a ClickHouse Cloud organization. Schema introspection matters more than it sounds. An agent that reads table definitions first writes far better ClickHouse SQL, a dialect with its own table engines, materialized views and functions that a general model tends to guess at. Data engineers use it for exploratory analysis, for checking whether a pipeline landed, and for letting less technical teammates question an events table in plain language while the read-only guardrail keeps the cluster safe.