MCP server

BigQuery MCP server

BigQuery has an official MCP server (2, in fact): One server for Postgres, MySQL, SQL Server, BigQuery, AlloyDB, Spanner and more, with tools you define in YAML. Below are all 2 servers with the setup for 13 clients: Claude Code, Claude Desktop, ChatGPT, Cursor, VS Code, Codex, Gemini CLI and more. Checked 2026-10-24 against each project's own repo, docs and the official MCP Registry.

MCP Toolbox for Databases

Official · GoogleSee docs

One server for Postgres, MySQL, SQL Server, BigQuery, AlloyDB, Spanner and more, with tools you define in YAML.

★ 17kpushed 2026-10-23Apache-2.0

No one-line setup: it needs a build step, an app plugin or account details. Follow the README.

BigQuery

Official · GoogleRemote

Google-hosted server to list BigQuery datasets and tables and run SQL queries.

https://bigquery.googleapis.com/mcp

Run in a terminal, then /mcp inside Claude Code to sign in. Add --scope project to share it via .mcp.json. docs

claude mcp add --transport http bigquery https://bigquery.googleapis.com/mcp

Agent skills for BigQuery

1

The MCP server gives the agent BigQuery's tools; a skill teaches it how to use BigQuery well. Install with the skills CLI or see each skill's page for Claude Code, Codex, Copilot and Cursor.

  • BigQuery BasicsGoogle

    Runs SQL and manages BigQuery datasets, tables, views and load jobs.

    npx skills add google/skills --skill bigquery-basics

Which one to pick

  • Start with MCP Toolbox for Databases: it's maintained by Google and follows its API.
  • A remote server (BigQuery) needs no install and signs you in with OAuth. It's also the only kind ChatGPT and claude.ai can use.

FAQ

Is there an official BigQuery MCP server?+

Yes: MCP Toolbox for Databases and BigQuery, maintained by Google.

How do I connect BigQuery to Claude?+

In Claude Code, run the claude mcp add command shown above. In Claude Desktop, add the server to claude_desktop_config.json (Settings > Developer > Edit Config) and restart the app.

How do I use the BigQuery MCP server in Cursor or VS Code?+

Open the Cursor or VS Code tab on the server above: it has the exact mcp.json entry. The same server also works in Claude Code, Claude Desktop / claude.ai, ChatGPT, Cursor, VS Code and Codex.

Can I use the BigQuery MCP server in ChatGPT?+

ChatGPT connects to remote MCP servers only. BigQuery has a hosted URL: at chatgpt.com/plugins choose + > Add custom MCP server, paste the URL and create it as a plugin.

Is it safe to give an AI agent access to BigQuery?+

Start with the official server, a read-only or test account and approval prompts on for anything that writes. Content the agent reads from BigQuery (tickets, messages, pages) can carry prompt-injection instructions, so don't auto-approve actions.

All database MCP servers · Agent skills · How MCP setup works in each client

MCP servers for similar apps: AlloyDB · Azure SQL · Chroma · ClickHouse · Cloud SQL · CockroachDB · Confluent · Convex · Couchbase · Databricks · Dataplex · dbt · DuckDB · Elasticsearch · Firebase · Firestore · Fivetran · Kafka · MariaDB · Metabase · Milvus · MongoDB · MotherDuck · MySQL