# Google BigQuery (MCP Server)

> Google-managed remote MCP server for BigQuery datasets and SQL

- Type: MCP server
- Publisher: Google Cloud (official)
- Categories: Data & Analytics, DevOps & Cloud
- Website: https://docs.cloud.google.com/bigquery/docs/use-bigquery-mcp
- Docs: https://docs.cloud.google.com/mcp/supported-products
- Transport: streamable-http
- Server URL: https://bigquery.googleapis.com/mcp
- Sign-in: oauth
- Listed: 2025-12-10

## About

Google Cloud's managed remote MCP server for BigQuery (GA) lets agents list datasets and tables, inspect metadata and run SQL. It uses OAuth 2.0 with IAM and requires the MCP Tool User role plus BigQuery permissions. It is one of several Google-managed MCP endpoints, alongside GKE, Compute Engine, Cloud Run, Cloud Logging and more.

## Install

1. **Connect it in ChatGPT** Turn on Developer mode in ChatGPT (Settings → Security and login), open Plugins, select + and paste https://bigquery.googleapis.com/mcp as the MCP server URL, then sign in with OAuth. Add it to a chat from the composer's tools menu.

2. **Or add it to Codex or the API**

   Codex CLI:

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

   config.toml:

   ```toml
   [mcp_servers.google-bigquery]
   url = "https://bigquery.googleapis.com/mcp"
   ```

   Responses API:

   ```python
   import os
   from openai import OpenAI
   
   client = OpenAI()
   
   response = client.responses.create(
       model="gpt-6-astra",
       tools=[{
           "type": "mcp",
           "server_label": "google_bigquery",
           "server_url": "https://bigquery.googleapis.com/mcp",
           "authorization": os.environ["GOOGLE_BIGQUERY_API_KEY"],
           "require_approval": "never",
       }],
       input="List the datasets in my analytics project",
   )
   print(response.output_text)
   ```

## Tools

- `list_dataset_ids`
- `get_dataset_info`
- `list_table_ids`
- `get_table_info`
- `execute_sql`
- `execute_sql_readonly`

## Example prompts

- "List the datasets in my analytics project"
- "Describe the schema of the events table"
- "What were daily active users over the last 7 days?"
- "Run a read-only query for the top 10 products by revenue"

## Also available as

- plugin: [BigQuery](https://chatgptplugins.directory/plugins/bigquery.md)

## Related

- [GitHub](https://chatgptplugins.directory/mcp/github.md): Manage repos, issues, pull requests and Actions from your AI agent
- [Supabase](https://chatgptplugins.directory/mcp/supabase.md): Manage Supabase databases, migrations, edge functions and logs
- [Sentry](https://chatgptplugins.directory/mcp/sentry.md): Search Sentry errors, issues and traces and debug them with Seer
- [Graphiti MCP](https://chatgptplugins.directory/mcp/graphiti.md): Temporal knowledge graph memory for agents, by Zep
- [Cloudflare API](https://chatgptplugins.directory/mcp/cloudflare-api.md): Access 2,500+ Cloudflare API endpoints through two Code Mode tools
- [Vercel](https://chatgptplugins.directory/mcp/vercel.md): Manage Vercel projects, deployments, logs and docs from AI tools

---
Source: https://chatgptplugins.directory/mcp/google-bigquery · Index: https://chatgptplugins.directory/llms.txt · Independent and community-run. Not affiliated with or endorsed by OpenAI. ChatGPT is a trademark of OpenAI.