Google Cloud Blog
Follow
Agentic analytics with the Data Agent Kit
Data practitioners face challenges with open-ended questions requiring data from diverse sources. The Data Agent Kit addresses this by enabling data workflows directly within an IDE. It utilizes the Model Context Protocol (MCP) to connect agents to various data systems. Skills, defined in markdown, teach the agent how to interact with a specific data stack. Instead of manual querying, agents execute queries and retrieve results on behalf of the user. For instance, an investigation into a dropped average order value involved querying BigQuery, Cloud SQL, and Cloud Storage. The agent discovered a new wholesale channel with a low average order value due to a promotional code. It then identified new wholesale accounts and confirmed the promotional code’s impact. The entire investigation, from data analysis to executive summary generation, occurred within a single chat session. Finally, the agent can transform ad-hoc analysis into a reproducible dbt project, including writing and correcting data quality tests.