Google BigQueryvf.sr

listing.by · home.legend.verified

List datasets, inspect tables and run SQL queries in Google BigQuery projects, with job status and cancellation.

state.auth.long (state.auth.title)Streamable HTTP

listing.connect

listing.explain.oauth

https://bigquery.googleapis.com/mcp

listing.note.oauth

listing.share.h

listing.share.p

mcp.tc/i/bigquery

listing.about

Connects an assistant to Google BigQuery. It can list datasets and tables, read their metadata (including BigLake namespaces and tables), run SQL queries, fetch paged results and check or cancel query jobs.

It runs as a hosted streamable HTTP endpoint at bigquery.googleapis.com/mcp. Access uses Google OAuth 2.0 and IAM permissions on the target project. The read-only SQL tool is limited to SELECT statements, while the general SQL tool can run statements that change data.

listing.can

  • List dataset IDs and BigLake namespaces in a project
  • Read metadata for datasets and tables
  • List table IDs in a dataset
  • Run read-only SELECT queries
  • Run any SQL statement, including writes and DDL
  • Page through results of long-running query jobs
  • Check job status and cancel running jobs

listing.tools 9

  • list_dataset_idslisting.hint.ro

    List BigQuery dataset IDs and BigLake namespaces in a project, with pagination.

  • get_dataset_infolisting.hint.ro

    Get metadata about a BigQuery dataset or BigLake namespace.

  • list_table_idslisting.hint.ro

    List table IDs in a dataset or BigLake namespace, with pagination.

  • get_table_infolisting.hint.ro

    Get metadata about a BigQuery table or BigLake table.

  • execute_sql_readonlylisting.hint.ro

    Run a read-only SELECT query in the project and return the result.

  • execute_sqllisting.hint.delete

    Run any BigQuery SQL, including INSERT, UPDATE, DELETE, CREATE and ML functions.

  • get_query_resultslisting.hint.ro

    Poll or paginate results of a query job by job ID.

  • cancel_joblisting.hint.delete

    Cancel a running BigQuery job.

  • get_joblisting.hint.ro

    Get status, statistics and configuration of a BigQuery job.

listing.prov.live_on listing.prov.hints

listing.prompts

  • List the datasets in my project my-analytics-prod

  • Show the schema of the orders table in the sales dataset

  • Run a query for daily signups over the last 30 days

  • Check the status of my last BigQuery job and cancel it if it is still running

listing.setup.h

listing.setup.oauth

Claude Code

  1. Run this in a terminal, in your project folder:
claude mcp add --transport http bigquery https://bigquery.googleapis.com/mcp
  1. Start Claude Code, type /mcp, pick bigquery and choose Authenticate. A browser window opens for the Google Cloud sign-in.

Add --scope user to make it available in every project, not just this one.

Claude Desktop

  1. Open Settings → Connectors and click Add custom connector.
  2. Name it Google BigQuery and paste this URL:
https://bigquery.googleapis.com/mcp
  1. Click Add, then Connect, and sign in when Google Cloud asks.

Claude Desktop's JSON config file only starts local servers. Remote servers go through Connectors, and connectors you add on claude.ai show up here too.

claude.ai

  1. Open the connector form on claude.ai. This button fills in the name and URL for you:
  1. Check that the URL reads https://bigquery.googleapis.com/mcp and click Add.
  2. Click Connect and sign in when Google Cloud asks.

Free plans allow one custom connector. On Team and Enterprise plans an owner adds it under Organization settings → Connectors.

ChatGPT

  1. On chatgpt.com, open Settings → Security and login and turn on Developer mode.
  2. Go to chatgpt.com/plugins and click + to create an app for a remote MCP server.
  3. Paste https://bigquery.googleapis.com/mcp as the server URL and choose OAuth. ChatGPT sends you to Google Cloud to sign in.

Developer mode is available on the web for Plus, Pro, Business, Enterprise and Education accounts.

Cursor

Or add it by hand to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (this project):

mcp.json
{
  "mcpServers": {
    "bigquery": {
      "url": "https://bigquery.googleapis.com/mcp"
    }
  }
}

Cursor shows Needs login next to the server. Click it to sign in.

VS Code

Or from a terminal:

code --add-mcp '{"name":"bigquery","type":"http","url":"https://bigquery.googleapis.com/mcp"}'

Or commit it to the repo in .vscode/mcp.json:

.vscode/mcp.json
{
  "servers": {
    "bigquery": {
      "type": "http",
      "url": "https://bigquery.googleapis.com/mcp"
    }
  }
}

VS Code asks you to sign in the first time the server starts.

Devin Desktop

  1. Add it to ~/.config/devin/mcp_config.json (macOS and Linux) or %APPDATA%\devin\mcp_config.json (Windows):
mcp_config.json
{
  "mcpServers": {
    "bigquery": {
      "serverUrl": "https://bigquery.googleapis.com/mcp"
    }
  }
}
  1. Refresh the MCP server list in Cascade and sign in when asked.

Devin Desktop is the new name for Windsurf. It reads serverUrl (or url) for remote servers.

Codex

codex mcp add bigquery --url https://bigquery.googleapis.com/mcp
codex mcp login bigquery

Or edit ~/.codex/config.toml directly:

config.toml
[mcp_servers.bigquery]
url = "https://bigquery.googleapis.com/mcp"

Gemini CLI

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

Then, inside Gemini CLI, run /mcp auth bigquery to sign in.

This adds it to the current project. Add -s user to use it everywhere.

Any client

Most clients accept this shape. Some name the URL field differently: serverUrl in Devin Desktop, httpUrl in Gemini CLI's settings file.

{
  "mcpServers": {
    "bigquery": {
      "type": "http",
      "url": "https://bigquery.googleapis.com/mcp"
    }
  }
}

Zed puts servers under context_servers in its settings. Cline needs "type": "streamableHttp", or it assumes SSE.

Client only starts local servers? Bridge it with npx -y mcp-remote https://bigquery.googleapis.com/mcp.

listing.faq

Can I paste mcp.tc/i/bigquery into my MCP client?

No. mcp.tc links are pages, not server addresses. Connect with https://bigquery.googleapis.com/mcp, so your client talks to Google BigQuery directly. The sign-in token only works there anyway. The quick link is for sharing: it opens this page, with setup steps for every client.

Does Google BigQuery need an API key or a sign-in?

Yes, you need a Google Cloud account. The first time your client connects, it opens Google Cloud's sign-in page. The token goes straight to the server's own URL, never through mcp.tc.

Is Google BigQuery a remote or a local server?

Remote. Google Cloud hosts it at https://bigquery.googleapis.com/mcp, and it speaks Streamable HTTP. There's nothing to install.

What can Google BigQuery do?

It has 9 tools, including list_dataset_ids, get_dataset_info and list_table_ids. You can list dataset IDs and BigLake namespaces in a project, read metadata for datasets and tables and list table IDs in a dataset.

Which clients can use it?

Any client that supports remote MCP servers: Claude Code, Claude Desktop, claude.ai, ChatGPT in developer mode, Cursor, VS Code, Devin Desktop, Codex, Gemini CLI, Zed and others. The setup steps cover each one.

Who wrote this page?

mcp.tc's robot read Google BigQuery's own metadata (its MCP handshake, tool list and public pages), and an AI model drafted the text from it. A person reviews anything the checks can't confirm. The text can still be wrong, so if you spot a mistake, use Report this listing on this page.

listing.em.h

listing.em.lead listing.em.how

listing.em.badge

em.prev_lightem.prev_dark
Markdown
[![Google BigQuery on mcp.tc](https://mcp.tc/i/bigquery/badge.svg)](https://mcp.tc/i/bigquery)
HTML
<a href="https://mcp.tc/i/bigquery"><img src="https://mcp.tc/i/bigquery/badge.svg" alt="Google BigQuery on mcp.tc" height="20"></a>

listing.em.badge_note

listing.em.widget

HTML
<script src="https://mcp.tc/w/bigquery.js" async></script>

listing.em.widget_note

iframe

HTML
<iframe src="https://mcp.tc/embed/bigquery" title="Google BigQuery on mcp.tc" width="420" height="200" loading="lazy" allow="clipboard-write" style="border:0;border-radius:8px;max-width:100%"></iframe>

listing.em.iframe_note

JSON

listing.em.json

https://mcp.tc/i/bigquery.json

listing.em.fields

listing.disclaimer_checked