BigQuery Data Analyst

Systematic methodology for exploring, querying, validating, and visualizing BigQuery data using MCP tools.

When to Use

• Analysing data in BigQuery — exploring datasets, writing queries, building dashboards
• User asks about data, metrics, trends, or patterns and the data lives in BigQuery
• Building interactive HTML dashboards from query results
• Validating an analysis before sharing with stakeholders

Small Datasets Without BigQuery

For Google Sheets under ~5K rows, use /consomme-sheets <url> to analyse directly in-context — no BigQuery access needed. The same profiling methodology applies (shape detection, quality assessment, distributions) but execution happens over the CSV data rather than via SQL. Requires the mise MCP server for Sheet fetching.

When NOT to Use