ANALYTICS DATABASES / ClickHouse
ClickHouse MCP Server
Queries ClickHouse and inspects table metadata, with read-only SQL by default and separate authentication for network transports.
“An MCP server for ClickHouse.”
01 / THE REASONING
Why this made the selection.
- Documents query permissions and HTTP caller authentication separately.
- Supports metadata inspection and parameterized SQL, useful for targeted analytics investigations.
02 / THE REVIEW RECORD
What we actually inspected.
Source review has boundaries.
A clear record is more useful than a “safe” badge.
Material inspected
- README.md (installation, capability and permission sections)
- pyproject.toml
- mcp_clickhouse/mcp_server.py
- LICENSE
Our findings
- CLICKHOUSE_ALLOW_WRITE_ACCESS defaults false; writes require an explicit change.
- HTTP/SSE requires a configured bearer token or FastMCP auth provider unless authentication is deliberately disabled; the health probe is unauthenticated.
Not established by this review
- Server startup, authentication and tool execution were not tested.
The review applies to the material and revision named here. A newer upstream release can change its behavior.
03 / PUT IT TO WORK
Connect a server deliberately.
DOCUMENTED COMMAND
uv run --with mcp-clickhouse --python 3.12 mcp-clickhouseCopying does not execute this command. It may retrieve a newer version than the reviewed source.
- Follow the documented client launch configuration and configure the ClickHouse connection.
- Keep write access disabled for exploration; configure caller authentication before using a network transport.
Before you start
- Python/uv or the documented container runtime and a ClickHouse user.
04 / FOLLOW THE EVIDENCE
The source trail.
Our notes are separate from the original resource.
Check upstream before adopting a new version.
- Official documentation ↗Checked
https://github.com/ClickHouse/mcp-clickhouse/blob/80128445639794fa161179608c4862e9829a65fd/README.md
Supports: summary, whySelected, bestFor, limitations, install, access, compatibility, transports
- Applicable source licence ↗Checked
https://github.com/ClickHouse/mcp-clickhouse/blob/80128445639794fa161179608c4862e9829a65fd/LICENSE
Supports: license
https://github.com/ClickHouse/mcp-clickhouse/blob/80128445639794fa161179608c4862e9829a65fd/pyproject.toml
Supports: language, review
https://github.com/ClickHouse/mcp-clickhouse/blob/80128445639794fa161179608c4862e9829a65fd/mcp_clickhouse/mcp_server.py
Supports: language, review