MCP Directory

MCP Toolbox for Databases (BigQuery) vs MotherDuck / DuckDB MCP Server

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

 MCP Toolbox for Databases (BigQuery)

Google's official MCP server with prebuilt BigQuery tools, querying datasets via Application Default Credentials.

Verified
stdio (local)
OAuth
Go
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
CategoryDatabasesDatabases
LanguageGoPython
Transportstdio (local)stdio (local)
AuthOAuthAPI key
GitHub stars16k800
Last commit1 month ago2 months ago
Verified
Actively maintained
Installbrew install mcp-toolbox && toolbox --prebuilt bigquery --stdiouvx mcp-server-motherduck --db-path md: --read-write
RepoOpen Open

Verdict

Pick MCP Toolbox for Databases (BigQuery) if you prefer the more popular, battle-tested option, and you need the broadest set of tools.

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 MCP Toolbox for Databases (BigQuery)

Install / run
brew install mcp-toolbox && toolbox --prebuilt bigquery --stdio

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

{
  "mcpServers": {
    "mcp-toolbox-for-databases-bigquery": {
      "command": "/absolute/path/to/toolbox",
      "args": [
        "--prebuilt",
        "bigquery",
        "--stdio"
      ],
      "env": {
        "BIGQUERY_PROJECT": "<your-gcp-project-id>"
      }
    }
  }
}

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

MCP Toolbox for Databases (BigQuery) or MotherDuck / DuckDB MCP Server — which is better?

Pick MCP Toolbox for Databases (BigQuery) if you prefer the more popular, battle-tested option, and you need the broadest set of tools. 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 MCP Toolbox for Databases (BigQuery) 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 MCP Toolbox for Databases (BigQuery) 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.