MCP server
BigQuery MCP server
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.
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
Customize > Connectors > Add > Add custom connector, paste this URL and sign in. It syncs to Claude Desktop and mobile. docs
https://bigquery.googleapis.com/mcp
The free plan allows one custom connector. On Team and Enterprise an owner adds it under Organization settings > Connectors.
chatgpt.com/plugins > + > Add custom MCP server, paste the URL, set up sign-in and create it as a plugin. Then @-mention it in a chat. docs
https://bigquery.googleapis.com/mcp
Workspace admins can turn custom MCP plugins off.
Add to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (this project), or use the install button. docs
{
"mcpServers": {
"bigquery": {
"url": "https://bigquery.googleapis.com/mcp"
}
}
}Add to .vscode/mcp.json (note the "servers" key and the type), or use the install button. Command Palette > "MCP: Open User Configuration" for all workspaces. docs
{
"servers": {
"bigquery": {
"type": "http",
"url": "https://bigquery.googleapis.com/mcp"
}
}
}Run codex mcp add bigquery --url https://bigquery.googleapis.com/mcp (then codex mcp login bigquery), or add this to ~/.codex/config.toml. The CLI, IDE extension and Codex app share it. docs
[mcp_servers.bigquery] url = "https://bigquery.googleapis.com/mcp"
Run in a terminal (-s user adds it for all projects), then /mcp auth to sign in. In ~/.gemini/settings.json the key is httpUrl. docs
gemini mcp add -s user --transport http bigquery https://bigquery.googleapis.com/mcp
Run in a terminal; it writes ~/.copilot/mcp-config.json. docs
copilot mcp add --transport http bigquery https://bigquery.googleapis.com/mcp
Add to mcp_config.json: ~/.config/devin/mcp_config.json on macOS and Linux (older installs: ~/.codeium/windsurf/mcp_config.json), %APPDATA%\devin\ on Windows. docs
{
"mcpServers": {
"bigquery": {
"serverUrl": "https://bigquery.googleapis.com/mcp"
}
}
}Add to Zed's settings.json (or Settings > AI > MCP Servers > Add Server). Remote servers without an Authorization header sign in with OAuth. docs
{
"context_servers": {
"bigquery": {
"url": "https://bigquery.googleapis.com/mcp"
}
}
}Add to opencode.json in the project (or ~/.config/opencode/opencode.json). Sign in with opencode mcp auth bigquery. docs
{
"$schema": "https://opencode.ai/config.json",
"mcp": {
"bigquery": {
"type": "remote",
"url": "https://bigquery.googleapis.com/mcp",
"enabled": true
}
}
}Add to ~/.kiro/settings/mcp.json (all projects) or .kiro/settings/mcp.json (this project). docs
{
"mcpServers": {
"bigquery": {
"url": "https://bigquery.googleapis.com/mcp"
}
}
}MCP Servers > Configure > Configure MCP Servers opens cline_mcp_settings.json; add this entry. docs
{
"mcpServers": {
"bigquery": {
"type": "streamableHttp",
"url": "https://bigquery.googleapis.com/mcp"
}
}
}Agent skills for BigQuery
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