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 | |
|---|---|---|
| Category | Databases | Databases |
| Language | Go | Python |
| Transport | stdio (local) | stdio (local) |
| Auth | OAuth | API key |
| GitHub stars | 16k | 800 |
| Last commit | 1 month ago | 2 months ago |
| Verified | ||
| Actively maintained | ||
| Install | brew install mcp-toolbox && toolbox --prebuilt bigquery --stdio | uvx mcp-server-motherduck --db-path md: --read-write |
| Repo | Open | 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)
brew install mcp-toolbox && toolbox --prebuilt bigquery --stdioPaste 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
uvx mcp-server-motherduck --db-path md: --read-writePaste 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.