Official ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB.
Indexed, not yet reviewed
We found ClickHouse in the official MCP registry. Our automated check passed on Nov 1, 2026 (it confirms the server is published and reachable), but no one at CuratedMCP has reviewed its code, permissions or credentials handling. Check what it can access before you give it keys. Scan your machine free to see every MCP server you have installed.
mcp-clickhouse@0.7.0| Environment variable | Required | What it is |
|---|---|---|
| CLICKHOUSE_HOST | Yes | Hostname of the ClickHouse server |
| CLICKHOUSE_USER | Yes | Username for ClickHouse authentication |
| CLICKHOUSE_PASSWORDsecret | No | Password for ClickHouse authentication. Required unless a client certificate uses the default or mutual TLS mode |
| CLICKHOUSE_PORT | No | ClickHouse HTTP(S) port. Defaults to 8443 when CLICKHOUSE_SECURE=true, 8123 otherwise |
| CLICKHOUSE_SECURE | No | Use HTTPS to connect to ClickHouse |
| CLICKHOUSE_VERIFY | No | Verify SSL certificates |
| CLICKHOUSE_CA_CERT | No | Path to a PEM CA bundle for ClickHouse server certificate verification |
| CLICKHOUSE_CLIENT_CERT | No | Path to a PEM client certificate for the ClickHouse HTTPS connection |
| CLICKHOUSE_CLIENT_CERT_KEY | No | Path to the PEM private key for CLICKHOUSE_CLIENT_CERT |
| CLICKHOUSE_TLS_MODE | No | Client certificate mode: mutual, proxy, or strict |
| CLICKHOUSE_DATABASE | No | Default database to use |
| CLICKHOUSE_ROLE | No | ClickHouse role to activate for the session |
| CLICKHOUSE_ALLOW_WRITE_ACCESS | No | Allow write operations (DDL and DML). Queries run read-only by default |
| CLICKHOUSE_ALLOW_DROP | No | Allow destructive operations (DROP, TRUNCATE, DELETE, UPDATE, REPLACE, CLEAR, and DETACH PERMANENTLY) when write access is also enabled |
| CLICKHOUSE_MCP_QUERY_TIMEOUT | No | Query tool timeout in seconds |
| CLICKHOUSE_MCP_MAX_WORKERS | No | Maximum query worker thread pool size |
This checks that the server is published and reachable. It is not a security review. Source: the official MCP registry (io.github.ClickHouse/mcp-clickhouse) and GitHub.
Claim this page to get a full CuratedMCP listing: edit your description, see listing analytics, and add our README badge. Listing is free, and a person checks every submission before it goes live. We'll pre-fill the form from the registry.
CloudBase
CloudBase MCP: DB, functions, storage, hosting via @cloudbase/cloudbase-mcp
Codebase Memory
Codebase knowledge graph for AI agents — 162 languages, sub-ms queries, 99% fewer tokens.
Codeman
Start, prompt and read AI coding agent sessions (Claude Code, Codex, Gemini CLI and more) in Codeman
color-space
Conversions across 221 color spaces, tested against cited sources: CSS strings, gamut, LUTs