BigQuery Toolbox

Connect to Google’s managed BigQuery MCP server to discover datasets and tables, inspect metadata, and run read-only or general SQL queries.

See Google’s official BigQuery MCP documentation for setup instructions, authentication requirements, and current capabilities.

What you’ll need to connect

Ask your Google Cloud administrator to:

1. Select or create a Google Cloud project and enable the BigQuery API. BigQuery Sandbox can be used without enabling billing.
2. Grant your Google identity the MCP Tool User, BigQuery Job User, and BigQuery Data Viewer roles, or equivalent permissions appropriate for the data you need to access.
3. Ensure your Obot administrator has configured a Google Web OAuth client for this catalog entry.

When you connect, Google asks you to authorize Obot. Tool calls use your Google identity and its IAM permissions.

See Google’s MCP authentication guide for complete authentication instructions.

Important differences

This managed server provides fixed tools rather than the custom parameterized tools previously supported by this entry. Query execution is limited to three minutes and 3,000 result rows, and queries over Google Drive external tables are not supported.

⚠️ Upgrade notice

If you’re upgrading this server, note that this replaces the Obot-hosted BigQuery Toolbox server with Google’s managed BigQuery MCP server.

• Reconnect required: Connect with Google OAuth. The previous service-account JSON, project, dataset, and custom tools YAML settings are no longer used.
• Tool changes: Tool names and parameters change, and custom parameterized tools are no longer supported.
• New limits: Managed queries have documented duration and result-size limits.