BigQuery remote MCP server
Google's hosted MCP server for BigQuery, switched on together with the BigQuery API and reached over Streamable HTTP at bigquery.googleapis.com/mcp.
このサーバーについて
Google's hosted MCP server for BigQuery, switched on together with the BigQuery API and reached over Streamable HTTP at bigquery.googleapis.com/mcp. An agent can list dataset and table IDs, read dataset and table metadata, and run SQL through one general tool or a read-only variant that rejects DML, DDL and Python UDFs. Sign-in is OAuth 2.0 with IAM, and the caller needs the MCP Tool User, BigQuery Job User and BigQuery Data Viewer roles. Queries stop after three minutes by default, results are capped at 3,000 rows, and Drive-backed external tables are not supported. Google gives setup notes for Antigravity, ChatGPT, Claude and custom apps.
できること
- List BigQuery dataset and table IDs
- Read dataset and table metadata
- Run SQL queries in a project
- Run read-only SQL that rejects DML and DDL