The new toolset contains tools that will allow AI agents to execute queries inside BigQuery as well as fetch metadata from the cloud-based data warehouse.
These tools include the list_dataset_ids tool, which retrieves all dataset IDs within a Google Cloud project; get_dataset_info tool, which provides detailed metadata about a specific dataset; list_table_ids tool, which lists all table IDs within a dataset; get_table_info tool, which fetches metadata for individual tables; and execute_sql tool, which allows users to run SQL queries directly in BigQuery and retrieve results.
The toolset, nonetheless, cannot be implemented in itself, and enterprises need to use the toolset in combination with Google’s open source offerings — Agent Development Kit (ADK) and its MCP Toolbox for Databases, formerly called Generative AI Toolbox for Databases, to be able to connect their agents to BigQuery.
If an enterprise wants to use the ADK, it needs to assign the toolset to an agent created within the framework itself.
