MotherDuck / DuckDB MCP Server vs MCP Toolbox for Databases (BigQuery)
A side-by-side comparison of two Databases servers — tools, transport, auth, maintenance, and copy-paste config for each.
| 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 | 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 | |
|---|---|---|
| Category | Databases | Databases |
| Language | Python | Go |
| Transport | stdio (local) | stdio (local) |
| Auth | API key | OAuth |
| GitHub stars | 800 | 16k |
| Last commit | 1 month ago | 13 days ago |
| Verified | ||
| Actively maintained | ||
| Install | uvx mcp-server-motherduck --db-path md: --read-write | brew install mcp-toolbox && toolbox --prebuilt bigquery --stdio |
| Repo | Open | Open |
Verdict
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).
Pick MCP Toolbox for Databases (BigQuery) if you prefer the more popular, battle-tested option, and you need the broadest set of tools.
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.
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>"
}
}
}
}FAQ
MotherDuck / DuckDB MCP Server or MCP Toolbox for Databases (BigQuery) — which is better?
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). Pick MCP Toolbox for Databases (BigQuery) if you prefer the more popular, battle-tested option, and you need the broadest set of tools.
Can I use both MotherDuck / DuckDB MCP Server and MCP Toolbox for Databases (BigQuery)?
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 MotherDuck / DuckDB MCP Server and MCP Toolbox for Databases (BigQuery) work with Claude, Cursor and Windsurf?
Both do. Copy the per-client config below into Claude Desktop, Cursor, or Windsurf.