mbettan/bq-finops-optimizer ? reverse-engineered prompt

Build me a BigQuery FinOps optimizer web app that helps a team understand where their BigQuery money is going and what to do about it.

I want a clean dashboard where someone can plug in BigQuery telemetry and get practical recommendations for storage, compute, and reservation costs. It should compare logical and physical storage options, simulate different Editions capacity choices, show likely savings, and help attribute wasted reservation costs back to the right projects or teams. It should also flag common SQL waste like inefficient joins, repeated jobs, DML abuse, redundant materialized views, and other easy fixes.

Please include an interactive simulator view, exportable results, and clear links back to the BigQuery console for each finding. If it makes sense, add an AI assisted query review mode for spotting bad SQL patterns, but keep the rest of the analysis deterministic and explainable. Make it feel like a polished enterprise tool, not a prototype, and use current docs online if you need to.