ClickHouse MCP Server vs MotherDuck / DuckDB MCP Server

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	MotherDuck / DuckDB MCP Server Query local DuckDB files, in-memory DBs, S3, or MotherDuck cloud with read/write SQL. Verified stdio (local) API key Python
Category	Databases	Databases
Language	Python	Python
Transport	stdio (local)	stdio (local)
Auth	API key	API key
GitHub stars	1.0k	800
Last commit	1 month ago	28 days ago
Verified
Actively maintained
Install	`uvx mcp-clickhouse`	`uvx mcp-server-motherduck --db-path md: --read-write`
Repo	Open	Open

Verdict

Pick ClickHouse MCP Server if you prefer its approach (official clickhouse server: read-only sql queries plus database/table exploration and chdb support).

Pick MotherDuck / DuckDB MCP Server if you prefer its approach (query local duckdb files, in-memory dbs, s3, or motherduck cloud with read/write sql).

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_SECURE": "true",
        "CLICKHOUSE_PASSWORD": "<clickhouse-password>"
      }
    }
  }
}

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

Add MotherDuck / DuckDB MCP Server

Install / run

uvx mcp-server-motherduck --db-path md: --read-write

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

{
  "mcpServers": {
    "motherduck-duckdb-mcp-server": {
      "command": "uvx",
      "args": [
        "mcp-server-motherduck",
        "--db-path",
        "md:"
      ],
      "env": {
        "motherduck_token": "<your-motherduck-token>"
      }
    }
  }
}

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

FAQ

ClickHouse MCP Server or MotherDuck / DuckDB MCP Server — which is better?

Pick ClickHouse MCP Server if you prefer its approach (official clickhouse server: read-only sql queries plus database/table exploration and chdb support). Pick MotherDuck / DuckDB MCP Server if you prefer its approach (query local duckdb files, in-memory dbs, s3, or motherduck cloud with read/write sql).

Can I use both ClickHouse MCP Server and MotherDuck / DuckDB MCP Server?

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 MotherDuck / DuckDB MCP Server work with Claude, Cursor and Windsurf?

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

View ClickHouse MCP Server →View MotherDuck / DuckDB MCP Server →More comparisons →