← all servers
~/mcps.gallery/servers/clickhouse
[databases][OFFICIAL]

ClickHouse

Run read-only SQL queries against a ClickHouse database and inspect its schema.

[databases][analytics][sql]

ClickHouse's own MCP server, giving a model a safe way to explore a ClickHouse database: listing databases and tables, reading table schemas, and running read-only SQL queries against your data.

Ships as a Python package and connects to any self-hosted ClickHouse server or ClickHouse Cloud instance.

install

uvx mcp-clickhouse
{
  "mcpServers": {
    "clickhouse": {
      "command": "uvx",
      "args": ["mcp-clickhouse"],
      "env": {
        "CLICKHOUSE_HOST": "localhost",
        "CLICKHOUSE_USER": "default",
        "CLICKHOUSE_PASSWORD": ""
      }
    }
  }
}