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-review
Review BigQuery SQL for performance 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-review
Context preview
What this command does when you run it.
Review BigQuery SQL for performance anti-patterns. Pass a file path or paste SQL directly.
Command definition
bq-review.mddescription: Review BigQuery SQL for performance anti-patterns. Pass a file path or paste SQL directly. argument-hint: "[file_path]"
BigQuery SQL Review
Review the provided BigQuery SQL against all 11 known anti-patterns using the `bigquery-optimization` skill.
Instructions
1. **Determine the SQL to review:**
- 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. **Run the full anti-pattern check** against all 11 patterns:
- SimpleSelectStar, SemiJoinWithoutAgg, CTEsEvalMultipleTimes, OrderByWithoutLimit,
StringComparison, LatestRecordWithAnalyticFun, DynamicPredicate, WhereOrder, JoinOrder, MissingDropStatement, ConvertTableToTemp.
3. **Output findings** using the standard review format from the bigquery-optimization skill:
- Group by severity (High, Medium, Low).
- Include before/after SQL for each finding.
- Provide a summary count.
4. If no anti-patterns are found, confirm: "No anti-patterns detected. This query follows BigQuery 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-optimize
Optimize BigQuery SQL by fixing all detected anti-patterns. Pass a file path or paste SQL directly.
@justvinhhereView Command