Official ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB.
Use this profile to copy client config, check auth requirements, review tools and resources, and compare related MCP servers before adding it to an AI client.
Get practical integration notes and launch examples for MCP servers like ClickHouse.
uvx mcp-clickhouse{
"CLICKHOUSE_HOST": "YOUR_VALUE_HERE",
"CLICKHOUSE_USER": "YOUR_VALUE_HERE",
"CLICKHOUSE_PASSWORD": "YOUR_SECRET_VALUE",
"CLICKHOUSE_PORT": "YOUR_VALUE_HERE",
"CLICKHOUSE_SECURE": "true",
"CLICKHOUSE_VERIFY": "true",
"CLICKHOUSE_DATABASE": "YOUR_VALUE_HERE",
"CLICKHOUSE_ROLE": "YOUR_VALUE_HERE",
"CLICKHOUSE_ALLOW_WRITE_ACCESS": "false",
"CLICKHOUSE_ALLOW_DROP": "false",
"CLICKHOUSE_MCP_QUERY_TIMEOUT": "30"
}Add this server entry to the mcpServers object in your Claude Desktop config, then restart the app.
{
"mcpServers": {
"io-github-clickhouse-mcp-clickhouse": {
"command": "uvx",
"args": [
"mcp-clickhouse"
],
"env": {
"CLICKHOUSE_HOST": "YOUR_VALUE_HERE",
"CLICKHOUSE_USER": "YOUR_VALUE_HERE",
"CLICKHOUSE_PASSWORD": "YOUR_SECRET_VALUE",
"CLICKHOUSE_PORT": "YOUR_VALUE_HERE",
"CLICKHOUSE_SECURE": "true",
"CLICKHOUSE_VERIFY": "true",
"CLICKHOUSE_DATABASE": "YOUR_VALUE_HERE",
"CLICKHOUSE_ROLE": "YOUR_VALUE_HERE",
"CLICKHOUSE_ALLOW_WRITE_ACCESS": "false",
"CLICKHOUSE_ALLOW_DROP": "false",
"CLICKHOUSE_MCP_QUERY_TIMEOUT": "30"
}
}
}
}~/Library/Application Support/Claude/claude_desktop_config.json%APPDATA%\Claude\claude_desktop_config.jsonNo remote HTTP endpoint is advertised. Use the package or stdio setup shown in Install.
ClickHouse is an MCP server for Official ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB.. It supports STDIO transport.
Use the generated config in Install. This server runs with uvx mcp-clickhouse; add any required environment variables before starting your client.
Choose the Claude Desktop tab in Install and copy the config for uvx mcp-clickhouse. Add required environment variables before starting Claude Desktop.
Choose the Claude Code tab in Install and copy the config for uvx mcp-clickhouse. Add required environment variables before starting Claude Code.
Choose the Codex tab in Install and copy the config for uvx mcp-clickhouse. Add required environment variables before starting Codex.
Choose the Cursor or VS Code tab in Install and copy the config for uvx mcp-clickhouse. Add required environment variables before starting Cursor or VS Code.
ClickHouse uses STDIO transport. Use the package or command config in Install.
ClickHouse inventory is listed when the MCP endpoint exposes tools, resources, or prompts. Some servers require auth first.
ClickHouse is marked with Auth required by registry metadata auth. You may need provider login, an API key, a bearer token, or a session header.
| Package | Registry | Version | Inputs |
|---|---|---|---|
mcp-clickhousestdio | pypi | 0.4.1 | Env: CLICKHOUSE_HOST required Env: CLICKHOUSE_USER required Env: CLICKHOUSE_PASSWORD required secret Env: CLICKHOUSE_PORT Env: CLICKHOUSE_SECURE Env: CLICKHOUSE_VERIFY Env: CLICKHOUSE_DATABASE Env: CLICKHOUSE_ROLE Env: CLICKHOUSE_ALLOW_WRITE_ACCESS Env: CLICKHOUSE_ALLOW_DROP Env: CLICKHOUSE_MCP_QUERY_TIMEOUT |
ghcr.io/clickhouse/mcp-clickhouse:0.4.1stdio | oci | Not captured | Env: CLICKHOUSE_HOST required Env: CLICKHOUSE_USER required Env: CLICKHOUSE_PASSWORD required secret Env: CLICKHOUSE_PORT Env: CLICKHOUSE_SECURE Env: CLICKHOUSE_VERIFY Env: CLICKHOUSE_DATABASE Env: CLICKHOUSE_ROLE Env: CLICKHOUSE_ALLOW_WRITE_ACCESS Env: CLICKHOUSE_ALLOW_DROP Env: CLICKHOUSE_MCP_QUERY_TIMEOUT |