Google BigQuery MCP connector
Updated
Google BigQuery is Google Cloud's fully managed, serverless data warehouse for large-scale analytics and SQL queries. The Google BigQuery MCP connector allows AI agents to organize datasets and tables and manage their structure and lifecycle. It also supports inserting and querying records, enabling agents to analyze large volumes of data directly within workflows.
Authentication type
- OAuth 2.0 Authorization Code - Requires a one-time user login to authorize the agent to access the service on their behalf.
Uses
Use the Google BigQuery MCP connector to perform the following actions:
- Analyze large datasets instantly with SQL queries in Google BigQuery
- Organize business data into structured datasets and tables for reporting
- Load new records into Google BigQuery tables without manual uploads
- Track sales, marketing, or operations metrics through custom SQL queries
- Automate dataset and table creation for recurring analytics workflows
- Retrieve schema details to validate table structures before reporting
- Clean up outdated datasets and tables to reduce storage costs
- Sync operational data from other systems into Google BigQuery for analysis
Example prompts
Use the following example prompts to invoke Google BigQuery MCP connector tools from your AI assistant or Boomi Connect workflow:
Show me all the datasets available in our Google BigQuery project.Create a new dataset in Google BigQuery for this quarter's sales data.Pull the total revenue by region from Google BigQuery for last month.Add these new customer records to our Google BigQuery table.List all the tables inside our marketing dataset in Google BigQuery.Delete the outdated test dataset from Google BigQuery.Show me the structure of our orders table in Google BigQuery.Update the schema of our inventory table in Google BigQuery.Run a query to find our top ten customers by spend in Google BigQuery.Get details about our shipping dataset in Google BigQuery.
Google BigQuery MCP connector tools
The Google BigQuery MCP connector provides the following tools. Each tool maps to a specific action you can invoke from your AI agent or automation.
| Tool | Description |
|---|---|
| listDatasets | List datasets |
| createDataset | Create a dataset |
| getDataset | Get a dataset |
| deleteDataset | Delete a dataset |
| listTables | List tables |
| createTable | Create a table |
| getTable | Get a table |
| updateTable | Update a table |
| deleteTable | Delete a table |
| insertRecords | Insert records |
| executeQuery | Execute a SQL query |
