bigquery-sql
Provides BigQuery SQL query optimization techniques, execution best practices, and performance tuning rules for high-efficiency querying. Use when optimizing BigQuery SQL queries, reducing query costs, or designing performant SQL transformations.
Install
With your agent
Install OMGSkills skill "googlecloudplatform/data-agent-kit-plugin:skills/bigquery-sql" into this agent's normal skills directory: call the OMGSkills MCP get_install_plan tool for your agent and run the script it returns (it installs only the pinned commit and verifies SKILL.md), and stop if MCP or the pin is unavailable. Do not overwrite or change existing skills without asking me.
Manual command
git clone https://github.com/GoogleCloudPlatform/data-agent-kit-plugin /tmp/data-agent-kit-plugin && ln -s /tmp/data-agent-kit-plugin/skills/bigquery-sql ~/.claude/skills/bigquery-sqlFrom README
BigQuery SQL Optimization Performance and efficiency guidelines for BigQuery SQL queries. Includes rules for column pruning, predicate pushdown, join optimization, and materialization strategies. SQL Optimization Rules [!TIP] Always include a "Summary of Optimizations" section listing only the optimizations applied. Always Apply (Automatic) Column Pruning: Remove unnecessary columns from all query stages. Common Subexpression Reuse: Factor out identical expressions to avoid redundant computation. Predicate Pushdown: Apply WHERE filters as early as possible. Early Aggregation: Perform GROUP BY before joins when possible. Intermediate Materialization: Choose VIEW vs TABLE for intermediate nodes based on efficiency. Intermediate Node Strategy VIEW: Small datasets or simple transformations. TABLE: Large datasets, expensive computations, or nodes reused multiple times.
More from this repo
accidental-data-loss-prevention
**STOP AND VERIFY**: Before running any command or tool that results in irreversible data loss, you MUST obtain...
bigquery-ai-ml
Leverages BigQuery's built-in machine learning and GenAI capabilities for advanced data analytics.
bigquery-bigframes
Generates Python code using BigQuery DataFrames (BigFrames).