Google BigQuery MCP integration
Query, inspect, and write Google BigQuery projects, datasets, tables, jobs, and rows.
Sign in, add Google BigQuery in Apps, then choose the account your AI can use.
Tools
| Name | Description |
|---|---|
list_projectsList BigQuery projects available to the connected Google account. | List BigQuery projects available to the connected Google account. |
list_datasetsList datasets in a BigQuery project. | List datasets in a BigQuery project. |
get_datasetGet metadata for a BigQuery dataset. | Get metadata for a BigQuery dataset. |
list_tablesList tables, views, and external tables in a BigQuery dataset. | List tables, views, and external tables in a BigQuery dataset. |
get_tableGet BigQuery table metadata and schema. | Get BigQuery table metadata and schema. |
list_table_rowsList table rows with a capped page size and flattened BigQuery row objects. | List table rows with a capped page size and flattened BigQuery row objects. |
run_queryRun a BigQuery SQL query and return flattened rows, schema, job metadata, and pagination cursors. | Run a BigQuery SQL query and return flattened rows, schema, job metadata, and pagination cursors. |
get_query_resultsFetch or paginate rows for a completed or running BigQuery query job. | Fetch or paginate rows for a completed or running BigQuery query job. |
list_jobsList BigQuery jobs in a project for operational inspection and pagination. | List BigQuery jobs in a project for operational inspection and pagination. |
get_jobGet metadata, status, statistics, and errors for a BigQuery job. | Get metadata, status, statistics, and errors for a BigQuery job. |
cancel_jobRequest cancellation of a BigQuery job. BigQuery may still charge for work already performed. | Request cancellation of a BigQuery job. BigQuery may still charge for work already performed. |
insert_rowsStream up to 500 JSON rows into a BigQuery table with insertAll and return row-level insert errors. | Stream up to 500 JSON rows into a BigQuery table with insertAll and return row-level insert errors. |
custom_api_callCall a Google BigQuery REST API v2 path on bigquery.googleapis.com. | Call a Google BigQuery REST API v2 path on bigquery.googleapis.com. |
Quick Start
import { WeavzClient } from '@weavz-io/sdk'
const weavz = new WeavzClient({ apiKey: 'wvz_...' })
const result = await weavz.actions.execute('google-bigquery', 'list_projects', {
workspaceId: '550e8400-e29b-41d4-a716-446655440000',
integrationAlias: 'google-bigquery',
input: { /* ... */ },
})Related Integrations
Works well with
Frequently Asked Questions
Is there a Google BigQuery MCP server through Weavz?
Yes. Add the Google BigQuery integration to a Weavz workspace, enable the actions you need and connect any required account. Weavz provides the workspace MCP endpoint in Tool Mode or Code Mode. The catalog currently lists 13 Google BigQuery actions.
What can an AI agent do with Google BigQuery?
Available actions include List Projects, List Datasets, Get Dataset, List Tables, Get Table, and more. Your workspace exposes only the actions you enable. The agent also needs the intended account access and any required input values.
How do I connect Google BigQuery to Claude or ChatGPT?
Use a compatible remote MCP client, add the Weavz connector and choose a workspace. Add Google BigQuery, connect the required account and review the enabled actions. Client availability and account requirements vary; adding the connector does not authorize every app automatically.
Can I use Google BigQuery through an API or SDK?
Yes, supported actions can run through the Weavz REST API, TypeScript SDK or Python SDK. Configure a workspace and the required connections, use scoped access, and pass the intended end-user context when acting for a customer.
What authentication does Google BigQuery require?
The catalog lists OAuth2 for Google BigQuery. Use Hosted Connect to authorize the intended account. Required permissions, provider app access and available connection methods depend on the integration.
How do I review sensitive Google BigQuery actions?
Limit enabled actions, scope credentials to the intended user and configure Human Gates for the operations that need review. A matching policy can pause a send, record change or other sensitive action for an approver before execution.
What limits or costs apply to Google BigQuery?
Weavz plan limits apply to the actions and resources you use. The external provider may also require an account, a paid plan, API credits or specific permissions, and may enforce its own rate limits. Check current Weavz pricing and the provider’s terms before rollout.
Connect Google BigQuery in minutes
Get 20,000 free action executions every month. No credit card required.