Talking to Your Cloud Bill: An AI-Powered GCP Cost Agent with Agno and BigQuery How we turned a mountain of billing data into a conversational AI teammate — and what we learned about teaching LLMs …

Trendyol Tech Blog offers a glimpse into the technology and engineering practices powering one of Turkey's leading e-commerce platforms. With a focus on scalability, performance, and innovation, Trendyol Tech shares insights into microservices architecture, data engineering, and machine learning. Developers can learn about building high-traffic e-commerce systems, optimizing delivery pipelines, and leveraging  technologies to drive business growth.

Trendyol Tech

Trendyol's Data Warehouse team built a conversational AI agent using the Agno framework that lets anyone query GCP billing data in plain language. The agent pre-loads metadata (projects, services, SKUs) to avoid LLM hallucinations, uses fuzzy matching to resolve informal user terms to exact GCP names, and generates production-grade BigQuery SQL following strict guardrails: no LIKE wildcards, unique CTE aliases, mandatory cost/credits/net-cost triple, and dynamic date functions. A custom BigQuery tool executes queries safely. Data governance is embedded directly in the agent's instructions, enforcing project-level access control with clear denial messages. Key lessons include the value of pre-loaded context, SQL guardrails as reliability features, and the necessity of fuzzy matching since users rarely type exact service names.