MCP server · ClickHouse
ClickHouse MCP Server
⚠ No independent security audit: entries summarize official sources only. Review permissions and code before installing.
- Type
- MCP server
- Tasks
- Databases & SQL
- Compatible agents
- Claude Code, Claude Desktop, Codex, OpenCode, Cursor (source: clients with setup steps in ClickHouse's official docs (clickhouse.com/docs remote MCP and MCP guides) and the ClickHouse/mcp-clickhouse README)
- Verdict
- Pick it to let the agent explore schemas and write analytical SQL against ClickHouse; keep write access off and connect with a read-only database user.
- Permissions
- Open-source server: lists databases and tables and runs SQL via run_query, read-only by default (writes only if CLICKHOUSE_ALLOW_WRITE_ACCESS=true); optional chDB tool queries files/URLs locally. Cloud remote server: list databases/tables, inspect schemas and run read-only SELECTs, plus service, backup, ClickPipes and billing tools, scoped to what your user or API key can access.
- Credentials
- Open-source: ClickHouse connection settings (CLICKHOUSE_HOST, CLICKHOUSE_USER, CLICKHOUSE_PASSWORD, optional role). Cloud remote: ClickHouse Cloud OAuth or a Cloud API key via HTTP Basic auth; MCP must be enabled per service.
- Maintenance
- Official repo ClickHouse/mcp-clickhouse, release v0.7.0 on 2026-09-21 (PyPI mcp-clickhouse 0.7.0), last commit 2026-10-21; managed remote server at https://mcp.clickhouse.cloud/mcp for ClickHouse Cloud
- License
- Apache-2.0
- Install
- Self-hosted or any ClickHouse: stdio `uv run --with mcp-clickhouse --python 3.12 mcp-clickhouse` with CLICKHOUSE_HOST/PORT/USER/PASSWORD and CLICKHOUSE_SECURE=true. ClickHouse Cloud: enable MCP under Connect → MCP, then e.g. `claude mcp add --transport http clickhouse-cloud https://mcp.clickhouse.cloud/mcp`. Official install docs ↗
- Source
- https://github.com/ClickHouse/mcp-clickhouse
- Verified on
- 2026-10-25
Compared in: Best MCP servers for Databases & SQL in Cursor · Best MCP servers for Databases & SQL
Badge for your README
Maintain this project? Show that it's listed here. The badge only says it's listed; it is not a security review or an endorsement.
