Command
bq-design-table
Design a BigQuery table schema with optimal partitioning, clustering, and data types. Describe your data or paste a sample.
@justvinhhereView CommandData
Command
/bq-optimize
Optimize BigQuery SQL by fixing all detected anti-patterns. Pass a file path or paste SQL directly.
Install
> /plugin marketplace add justvinhhere/bigquery-expert > /plugin install bigquery-expert@justvinhhere-bigquery-expert
How it fires
How this command gets triggered: by you, by Claude, or both.
- Fires itselfClaude auto-loads it when your prompt matches the work.
- You can call itInvoke it directly when you want it.
- Slash command
/bq-optimize
Context preview
What this command does when you run it.
Optimize BigQuery SQL by fixing all detected anti-patterns. Pass a file path or paste SQL directly.
Command definition
bq-optimize.mddescription: Optimize BigQuery SQL by fixing all detected anti-patterns. Pass a file path or paste SQL directly.
argument-hint: "[file_path]"
BigQuery SQL Optimize
Rewrite the provided BigQuery SQL with all detected anti-patterns fixed, using the `bigquery-optimization` skill.
Instructions
1. **Determine the SQL to optimize:**
- If a file path argument is provided, read that file.
- If no argument is provided, look for the most recent BigQuery SQL in the current conversation.
- If no SQL is found, ask the user to provide a query or file path.
2. **Detect all anti-patterns** by running the full 11-pattern check.
3. **Apply all fixes** to produce an optimized version of the query:
- Preserve the original query semantics exactly -- the optimized query must return the same data.
- Apply fixes in this order: SimpleSelectStar, SemiJoinWithoutAgg, DynamicPredicate,
OrderByWithoutLimit, StringComparison, CTEsEvalMultipleTimes, LatestRecordWithAnalyticFun, JoinOrder, WhereOrder, MissingDropStatement, ConvertTableToTemp.
4. **Output the result:**
## Optimized Query
(fully rewritten SQL)
## Changes Applied
1. **PatternName**: What was changed and why.
2. **PatternName**: What was changed and why.
## Summary
X anti-pattern(s) fixed. The optimized query preserves the original semantics.
5. If no anti-patterns are found, return the original query and confirm it already follows best practices.
Read more
description: Optimize BigQuery SQL by fixing all detected anti-patterns. Pass a file path or paste SQL directly. argument-hint: "[file_path]"
BigQuery SQL Optimize
Rewrite the provided BigQuery SQL with all detected anti-patterns fixed, using the `bigquery-optimization` skill.
Instructions
1. **Determine the SQL to optimize:**
- If a file path argument is provided, read that file.
- If no argument is provided, look for the most recent BigQuery SQL in the current conversation.
- If no SQL is found, ask the user to provide a query or file path.
2. **Detect all anti-patterns** by running the full 11-pattern check.
3. **Apply all fixes** to produce an optimized version of the query:
- Preserve the original query semantics exactly -- the optimized query must return the same data.
- Apply fixes in this order: SimpleSelectStar, SemiJoinWithoutAgg, DynamicPredicate,
OrderByWithoutLimit, StringComparison, CTEsEvalMultipleTimes, LatestRecordWithAnalyticFun, JoinOrder, WhereOrder, MissingDropStatement, ConvertTableToTemp.
4. **Output the result:**
## Optimized Query (fully rewritten SQL) ## Changes Applied 1. **PatternName**: What was changed and why. 2. **PatternName**: What was changed and why. ## Summary X anti-pattern(s) fixed. The optimized query preserves the original semantics.
5. If no anti-patterns are found, return the original query and confirm it already follows best practices.
Ships withbigquery-expert
A comprehensive BigQuery plugin for Claude Code. Five integrated skill areas that activate automatically -- writing queries, designing schemas, optimizing costs, detecting anti-patterns, and navigating BigQuery-specific features.
Get the whole plugin
Stats
15
Stars
1
Forks
Maintained
Maintenance
Apache-2.0
License
5mo ago
Last commit
5mo ago
Created
Repo: justvinhhere/bigquery-expert
Other commands on bigquery-expert.
@justvinhhereView CommandCommand
bq-estimate-cost
Estimate the cost of a BigQuery query or table. Pass a query, file path, or table description.
@justvinhhereView CommandCommand
bq-explain
Explain a BigQuery feature, function, or concept with working examples. Pass the feature name or question.
@justvinhhereView CommandCommand
bq-generate
Generate optimized BigQuery SQL from a natural language description. Pass a description of the data you need.
@justvinhhereView CommandCommand
bq-review
Review BigQuery SQL for performance anti-patterns. Pass a file path or paste SQL directly.
@justvinhhereView Command