How do I install the Bigquery SQL skill?

Run npx skillmds@latest add gemini-cli-extensions-data-agent-kit-starter-pack/bigquery-sql in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

Is Bigquery SQL safe to use?

This skill has not completed SkillMD's automated safety review yet. Capability flags: docs only. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Bigquery SQL?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Bigquery SQL free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

Who published Bigquery SQL?

gemini-cli-extensions (@gemini-cli-extensions-data-agent-kit-starter-pack) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Bigquery SQL by gemini-cli-extensions-data-agent-kit-starter-pack

Name: Bigquery SQL
Rating: 4.666666666666667 (3 reviews)
Author: gemini-cli-extensions

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.

File contents

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.

Always Rewrite (Mandatory)

WHERE <col> IN (SELECT ...): Replace With WHERE EXISTS (SELECT 1 FROM ...)
WHERE (SELECT COUNT(*) ...) > 0: Replace With WHERE EXISTS (SELECT 1 FROM ...)

Propose with Confirmation (Conditional)

UNION → UNION ALL: Faster (skips deduplication), but permits duplicate rows.
COUNT(DISTINCT) → APPROX_COUNT_DISTINCT: Faster and lower memory, but approximate.

Frequently asked questions