Beyond Dashboards: Architecting a GenAI FinOps Analyst using BigQuery Native MCP

Google Cloud bills are larger and more complex to understand. You get a PDF summary that says "Compute Engine: $5,000", but when you ask why , you're tasked with downloading a massive CSV or wrestling with the Google Cloud Billing Console's filters (at SKU's level). For true FinOps visibility, most engineering teams turn to the Cloud Billing Export . This feature dumps every line item of your usage down to the SKU and timestamp into a BigQuery dataset. It is the single source of truth. But here is the catch: querying that data requires complex SQL. You need to know that cost is in one column, credits are nested in a JSON array, and project.labels requires unnesting. We need a better way. A user can just ask: "Why is the dev environment costing 20% more this week?" To build this, we do not write 1,000 lines of SQL-generation code. Instead, we can use Google's Native BigQuery MCP Server with Gemini. Here is how I built a "FinOps for Everyone" agent (architecture design) that lets you cha