ClickHouse

ClickHouse is a local MCP server: Official ClickHouse MCP server for querying and exploring ClickHouse clusters and chDB. Install it from pypi as mcp-clickhouse.

Claude CodeCodexAntigravity

commandprompt

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.

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.

• Runtime: Python with uv (runs with uvx) or Docker.
• MCP client: Claude Code, Codex, Antigravity, Claude Desktop, Cursor or any other client that speaks MCP over stdio.
• Environment variables: 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