ClickHouse
local MCP serverInstallation
Terminal
claude mcp add mcp-clickhouse -e CLICKHOUSE_HOST=... -e CLICKHOUSE_USER=... -e CLICKHOUSE_PASSWORD=... -e CLICKHOUSE_PORT=... -e CLICKHOUSE_SECURE=... -e CLICKHOUSE_VERIFY=... -e CLICKHOUSE_CA_CERT=... -e CLICKHOUSE_CLIENT_CERT=... -e CLICKHOUSE_CLIENT_CERT_KEY=... -e CLICKHOUSE_TLS_MODE=... -e CLICKHOUSE_DATABASE=... -e CLICKHOUSE_ROLE=... -e CLICKHOUSE_ALLOW_WRITE_ACCESS=... -e CLICKHOUSE_ALLOW_DROP=... -e CLICKHOUSE_MCP_QUERY_TIMEOUT=... -e CLICKHOUSE_MCP_MAX_WORKERS=... -- uvx mcp-clickhouse
Run in your project folder. Add --scope user to use it everywhere.
Claude Desktop, Cursor & other clients
Add to claude_desktop_config.json or .cursor/mcp.json.
{
"mcpServers": {
"mcp-clickhouse": {
"command": "uvx",
"args": [
"mcp-clickhouse"
],
"env": {
"CLICKHOUSE_HOST": "...",
"CLICKHOUSE_USER": "...",
"CLICKHOUSE_PASSWORD": "...",
"CLICKHOUSE_PORT": "...",
"CLICKHOUSE_SECURE": "...",
"CLICKHOUSE_VERIFY": "...",
"CLICKHOUSE_CA_CERT": "...",
"CLICKHOUSE_CLIENT_CERT": "...",
"CLICKHOUSE_CLIENT_CERT_KEY": "...",
"CLICKHOUSE_TLS_MODE": "...",
"CLICKHOUSE_DATABASE": "...",
"CLICKHOUSE_ROLE": "...",
"CLICKHOUSE_ALLOW_WRITE_ACCESS": "...",
"CLICKHOUSE_ALLOW_DROP": "...",
"CLICKHOUSE_MCP_QUERY_TIMEOUT": "...",
"CLICKHOUSE_MCP_MAX_WORKERS": "..."
}
}
}
}Fill in the environment variables with your own credentials.
Summary
Official ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB.
Questions
ClickHouse is a local MCP server distributed as the pypi package mcp-clickhouse.
Run: claude mcp add mcp-clickhouse -e CLICKHOUSE_HOST=... -e CLICKHOUSE_USER=... -e CLICKHOUSE_PASSWORD=... -e CLICKHOUSE_PORT=... -e CLICKHOUSE_SECURE=... -e CLICKHOUSE_VERIFY=... -e CLICKHOUSE_CA_CERT=... -e CLICKHOUSE_CLIENT_CERT=... -e CLICKHOUSE_CLIENT_CERT_KEY=... -e CLICKHOUSE_TLS_MODE=... -e CLICKHOUSE_DATABASE=... -e CLICKHOUSE_ROLE=... -e CLICKHOUSE_ALLOW_WRITE_ACCESS=... -e CLICKHOUSE_ALLOW_DROP=... -e CLICKHOUSE_MCP_QUERY_TIMEOUT=... -e CLICKHOUSE_MCP_MAX_WORKERS=... -- uvx mcp-clickhouse
Run: codex mcp add mcp-clickhouse --env CLICKHOUSE_HOST=... --env CLICKHOUSE_USER=... --env CLICKHOUSE_PASSWORD=... --env CLICKHOUSE_PORT=... --env CLICKHOUSE_SECURE=... --env CLICKHOUSE_VERIFY=... --env CLICKHOUSE_CA_CERT=... --env CLICKHOUSE_CLIENT_CERT=... --env CLICKHOUSE_CLIENT_CERT_KEY=... --env CLICKHOUSE_TLS_MODE=... --env CLICKHOUSE_DATABASE=... --env CLICKHOUSE_ROLE=... --env CLICKHOUSE_ALLOW_WRITE_ACCESS=... --env CLICKHOUSE_ALLOW_DROP=... --env CLICKHOUSE_MCP_QUERY_TIMEOUT=... --env CLICKHOUSE_MCP_MAX_WORKERS=... -- uvx mcp-clickhouse
Similar MCP servers
NameStars
- CCXTio.github.ccxt/ccxt-mcp44K
- PostHog MCP Serverio.github.PostHog/mcp40K
- kaneoio.github.usekaneo/kaneo9,252
- MCP Registry Serverai.com.mcp/registry7,291
- DBHubio.github.bytebase/dbhub3,574
- Usertour MCP Serverio.github.usertour/mcp2,312
- Microsoft Learn MCPcom.microsoft/microsoft-learn-mcp1,916
- Neoncom.neon/mcp649