Google BigQuery MCP connector

Google BigQuery is Google's fully managed, serverless data warehouse for running large-scale analytics and SQL queries across petabyte-scale datasets. The Google BigQuery MCP connector allows AI agents to manage datasets and tables, insert records, and execute SQL queries to analyze data. It also supports retrieving table schemas, listing available datasets, and performing data warehouse operations across your BigQuery projects.

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 sales trends across millions of transaction records in seconds
• Build automated dashboards that track key business metrics in real time
• Combine data from multiple sources to create unified customer insights
• Generate monthly financial reports by querying structured accounting data
• Monitor data quality by running validation checks on warehouse tables
• Archive historical records and organize data by business department
• Segment customers for targeted marketing campaigns using SQL queries

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 customer orders from Google BigQuery that were placed in the last 30 days.
• Create a new dataset in Google BigQuery called 'Q4_Analytics' for our sales team.
• How many unique customers purchased products in Google BigQuery last quarter?
• Delete the outdated 2022 inventory table from Google BigQuery.
• Add 500 new employee records to the HR dataset in Google BigQuery.
• Generate a report in Google BigQuery showing revenue by region and product category.
• List all the tables we have in the finance dataset in Google BigQuery.
• Create a table in Google BigQuery to track monthly marketing campaign performance.
• Find the top 10 best-selling products from our sales data in Google BigQuery.
• Update customer contact information in Google BigQuery based on our CRM data.

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	Retrieves all datasets available in the BigQuery project.
createDataset	Creates a new dataset with specified configuration settings.
getDataset	Retrieves detailed information about a specific dataset.
deleteDataset	Removes a dataset from the BigQuery project.
listTables	Retrieves all tables within a specified dataset.
createTable	Creates a new table with defined schema and settings.
getTable	Retrieves detailed information about a specific table.
updateTable	Modifies the schema or properties of an existing table.
deleteTable	Removes a table from a dataset.
insertRecords	Adds new rows of data into a specified table.
executeQuery	Runs a SQL query and returns the results.