bq-design-table
CommandDesign a BigQuery table schema with optimal partitioning, clustering, and data types. Describe your data or paste a sample.
@justvinhhereInstall CommandData
Command
/bq-review
Review BigQuery SQL for performance anti-patterns. Pass a file path or paste SQL directly.
> /plugin marketplace add justvinhhere/bigquery-expert> /plugin install bigquery-expert@justvinhhere-bigquery-expert
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."
Stats
17
Stars
1
Forks
Quiet
Maintenance
Apache-2.0
License
Last commit
Created
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.
175 skills3 agents
Stars on GitHub
Momentum
- stars in total
- 17
Other commands on bigquery-expert.
@justvinhhereInstall Commandbq-estimate-cost
CommandEstimate the cost of a BigQuery query or table. Pass a query, file path, or table description.
@justvinhhereInstall Commandbq-explain
CommandExplain a BigQuery feature, function, or concept with working examples. Pass the feature name or question.
@justvinhhereInstall Commandbq-generate
CommandGenerate optimized BigQuery SQL from a natural language description. Pass a description of the data you need.
@justvinhhereInstall Commandbq-optimize
CommandOptimize BigQuery SQL by fixing all detected anti-patterns. Pass a file path or paste SQL directly.
@justvinhhereInstall CommandMore commands from other plugins.
Auto-invoked
recall
CommandSearch past session observations and lessons for relevant context. Wrap the `memory_smart_search` and `memory_lesson_recall` MCP…
@rohitg00Install Commandcreate-skill
CommandCreate an AI skill from any source (URL, repo, PDF, video, notebook, etc.)
@yusufkaraaslanInstall Command