bigquery-report

What problem does it solve?

It removes the manual, error-prone steps of exploring BigQuery datasets, building safe SQL, and controlling query cost so analysts can get actionable insights quickly without risking unexpected billing or out-of-scope data access.

Core Features & Use Cases

• Dataset & Table Discovery: List projects, datasets, and tables to understand data surface area before querying.
• Schema Inspection: Retrieve table schemas (including nested fields) to build correct SQL and avoid runtime errors.
• SELECT-only SQL Execution with Guardrails: Construct and run read-only queries with project/dataset scope validation, secret detection, row and byte limits, and dry-run cost estimates.
• Common Use Cases: GA4 export analysis (event trends, page views), e-commerce revenue and product ranking reports, ad-hoc trend and top-N aggregations.
• Result Interpretation: Parse JSON output into a concise, actionable Japanese summary with trend insights, rankings, anomalies, and improvement suggestions.

Quick Start

Ask the agent to show datasets in project my-project and then summarize daily page_view counts from analytics.events for the past 7 days.