BigQuery MCP
Run BigQuery SQL, inspect datasets and tables, export results, and manage jobs in Google Cloud.
Overview
| Catalog ID | mcp-bigquery |
| Category | database |
| Auth method | OAuth |
| Blast radius | moderate |
| Trust | Verified — published by cendriix |
| Version | 1.0.0 |
| Regions | us-east-1, eu-west-1 |
Tools
| Tool | Description |
|---|---|
run_query | Execute a BigQuery SQL query. |
list_datasets | List datasets in a project. |
describe_table | Get schema of a BigQuery table. |
create_table | Create a new table. |
export_to_gcs | Export a table to GCS. |
Tool parameters
run_query
Execute a BigQuery SQL query.
| Parameter | Type | Description | |
|---|---|---|---|
query | string | required | SQL query (GoogleSQL) |
project_id | string | optional | GCP project ID |
max_results | integer | optional | Max rows |
list_datasets
List datasets in a project.
| Parameter | Type | Description | |
|---|---|---|---|
project_id | string | optional | GCP project ID |
describe_table
Get schema of a BigQuery table.
| Parameter | Type | Description | |
|---|---|---|---|
dataset_id | string | required | Dataset ID |
table_id | string | required | Table ID |
create_table
Create a new table.
| Parameter | Type | Description | |
|---|---|---|---|
dataset_id | string | required | Dataset ID |
table_id | string | required | Table ID |
schema | array | required | Schema fields |
export_to_gcs
Export a table to GCS.
| Parameter | Type | Description | |
|---|---|---|---|
dataset_id | string | required | Dataset ID |
table_id | string | required | Table ID |
destination_uri | string | required | GCS URI (gs://…) |
format | string | optional | Export format |
Installing
- In Cendriix, go to Settings → MCPs
- Find BigQuery and click Install
- Click Authorize after installing. Cendriix completes the OAuth flow with the provider and refreshes tokens automatically — you never paste a long-lived secret.
- Click Test Connection to run a health check and list available tools
Authentication. Click Authorize after installing. Cendriix completes the OAuth flow with the provider and refreshes tokens automatically — you never paste a long-lived secret.
Blast radius
This MCP is classified moderate. This MCP can create and update records in the connected service, but cannot delete infrastructure.
Every tool invocation is recorded in your Audit Log. You can remove this MCP at any time from Settings → MCPs, which revokes tool access immediately.
Further reading
- MCP Marketplace — browse and install MCPs
- Policies & Guardrails — approval gates and blast radius
- Audit Log — review tool invocations
Last updated on