MCP Directory

ClickHouse MCP Server vs DBHub

A side-by-side comparison of two Databases servers — tools, transport, auth, maintenance, and copy-paste config for each.

 ClickHouse MCP Server

Official ClickHouse server: read-only SQL queries plus database/table exploration and chDB support.

Verified
stdio (local)
API key
Python
DBHub

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, and SQLite.

Unverified
stdio (local)
No auth
TypeScript
CategoryDatabasesDatabases
LanguagePythonTypeScript
Transportstdio (local)stdio (local)
AuthAPI keyNone
GitHub stars1.0k3.0k
Last commit2 months ago1 month ago
Verified
Actively maintained
Installuvx mcp-clickhousenpx @bytebase/dbhub@latest --transport stdio --dsn "postgres://user:password@localhost:5432/dbname"
RepoOpen Open

Verdict

Pick ClickHouse MCP Server if you want the official, vendor-maintained server, and you want a verified, documented setup.

Pick DBHub if you prefer the more popular, battle-tested option, and you want zero-setup with no API key.

Add ClickHouse MCP Server

Install / run
uvx mcp-clickhouse

Paste into ~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "clickhouse-mcp-server": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse"
      ],
      "env": {
        "CLICKHOUSE_HOST": "<clickhouse-host>",
        "CLICKHOUSE_PORT": "8443",
        "CLICKHOUSE_USER": "<clickhouse-user>",
        "CLICKHOUSE_PASSWORD": "<clickhouse-password>",
        "CLICKHOUSE_SECURE": "true"
      }
    }
  }
}

Requires `uv` (the Python package runner). Install it from https://docs.astral.sh/uv/ if `uvx` is not found.

Add DBHub

Install / run
npx @bytebase/dbhub@latest --transport stdio --dsn "postgres://user:password@localhost:5432/dbname"

Paste into ~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "dbhub": {
      "command": "npx",
      "args": [
        "@bytebase/dbhub@latest",
        "--transport",
        "stdio",
        "--dsn",
        "postgres://user:password@localhost:5432/dbname"
      ]
    }
  }
}

FAQ

ClickHouse MCP Server or DBHub — which is better?

Pick ClickHouse MCP Server if you want the official, vendor-maintained server, and you want a verified, documented setup. Pick DBHub if you prefer the more popular, battle-tested option, and you want zero-setup with no API key.

Can I use both ClickHouse MCP Server and DBHub?

Yes — MCP clients let you enable multiple servers at once. Add both configs to your client's mcpServers and use whichever tool fits the task.

Do ClickHouse MCP Server and DBHub work with Claude, Cursor and Windsurf?

Both do. Copy the per-client config below into Claude Desktop, Cursor, or Windsurf.