MCP Directory

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.

 DuckDB MCP Server

Query and manage a local DuckDB database from your LLM via the Model Context Protocol.

Unverified
stdio (local)
No auth
Stale
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
CategoryDatabasesDatabases
LanguagePythonGo
Transportstdio (local)stdio (local)
AuthNoneOAuth
GitHub stars17716k
Last commit1 year ago15 days ago
Verified
Actively maintained
Installnpx -y @smithery/cli install mcp-server-duckdb --client claudebrew install mcp-toolbox && toolbox --prebuilt bigquery --stdio
RepoOpen Open

Verdict

Pick DuckDB MCP Server if you want zero-setup with no API key.

Pick MCP Toolbox for Databases (BigQuery) if you want the official, vendor-maintained server, and you prefer the more popular, battle-tested option.

Add DuckDB MCP Server

Install / run
npx -y @smithery/cli install mcp-server-duckdb --client claude

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

{
  "mcpServers": {
    "duckdb-mcp-server": {
      "command": "uvx",
      "args": [
        "mcp-server-duckdb",
        "--db-path",
        "~/mcp-server-duckdb/data/data.db"
      ]
    }
  }
}

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)

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>"
      }
    }
  }
}

FAQ

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

Pick DuckDB MCP Server if you want zero-setup with no API key. Pick MCP Toolbox for Databases (BigQuery) if you want the official, vendor-maintained server, and you prefer the more popular, battle-tested option.

Can I use both 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 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.