Google launches BigQuery AI agent connector toolset
Google introduces a new toolset to connect AI agents with BigQuery data, requiring integration with its Agent Development Kit and MCP Toolbox.
Google has introduced a new toolset designed to help enterprises connect their AI agents to data stored in BigQuery, addressing the growing demand for agentic applications. These applications, which operate autonomously, are increasingly popular as they enable businesses to maximize efficiency with limited resources.
Key Features of the Toolset
The toolset includes several tools to facilitate interaction with BigQuery:
- list_dataset_ids: Retrieves all dataset IDs within a Google Cloud project.
- get_dataset_info: Provides detailed metadata about a specific dataset.
- list_table_ids: Lists all table IDs within a dataset.
- get_table_info: Fetches metadata for individual tables.
- execute_sql: Allows users to run SQL queries directly in BigQuery and retrieve results.
Integration Requirements
The toolset cannot be used standalone. Enterprises must integrate it with Google’s open-source offerings:
- Agent Development Kit (ADK): Requires assigning the toolset to an agent created within the ADK framework.
- MCP Toolbox for Databases: Natively supports BigQuery’s pre-built toolset.
Implementation Steps
- For ADK: Import the toolset from the
agents.toolsmodule in a Python environment via the ADK CLI or SDK. - For MCP Toolbox: Create an
mcp-toolboxfolder in the same directory as the ADK application and install the toolbox.
Industry Perspective
Charlie Dai, Forrester VP and principal analyst, highlighted the toolset’s potential:
"Google’s ADK and MCP integration provides pre-built frameworks to connect AI agents directly to BigQuery data. This eliminates custom integration work, reducing development overhead, and enables agents to leverage enterprise context for accurate responses."
Competitive Landscape
Google joins rivals like Databricks, Snowflake, and Teradata, which have also introduced MCP-related offerings to connect AI agents with enterprise data. Google plans to expand the toolset but has not disclosed a timeline.
External Links
Google’s move underscores the intensifying race to bridge AI agents with enterprise data platforms.
Related News
AWS extends Bedrock AgentCore Gateway to unify MCP servers for AI agents
AWS announces expanded Amazon Bedrock AgentCore Gateway support for MCP servers, enabling centralized management of AI agent tools across organizations.
CEOs Must Prioritize AI Investment Amid Rapid Change
Forward-thinking CEOs are focusing on AI investment, agile operations, and strategic growth to navigate disruption and lead competitively.
About the Author
Dr. Emily Wang
AI Product Strategy Expert
Former Google AI Product Manager with 10 years of experience in AI product development and strategy formulation. Led multiple successful AI products from 0 to 1 development process, now provides product strategy consulting for AI startups while writing AI product analysis articles for various tech media outlets.