justvinhhere

justvinhhere/bigquery-expert

Plugin Claude Code

Comprehensive BigQuery skill suite for Claude Code.

justvinhhere/bigquery-expert

Plugin Claude Code

Comprehensive BigQuery skill suite: query optimization, SQL generation, schema design, cost optimization, and feature guidance.

justvinhhere/bigquery-expert

Agent

Use when asked to analyze BigQuery SQL files across a project for cost optimization opportunities, estimate total query costs, or audit a codebase for expensive query patterns. Analyze all my SQL files for cost optimization opportunities Which queries in this project are the most expensive? Audit my BigQuery queries…

justvinhhere/bigquery-expert

Agent

Use when asked to review all SQL files in a project or directory for BigQuery anti-patterns, scan a codebase for SQL performance issues, or audit BigQuery queries across multiple files. Scan all SQL files in this project for BigQuery anti-patterns Audit my BigQuery queries for performance issues Review all the SQL in…

justvinhhere/bigquery-expert

Agent

Use when asked to analyze table schemas across a project, recommend partitioning and clustering strategies for existing tables, audit schema design, or optimize table structure across a dataset or project. Analyze my BigQuery schemas and recommend partitioning strategies Audit the table designs in this project and…

justvinhhere/bigquery-expert

Command

Design a BigQuery table schema with optimal partitioning, clustering, and data types. Describe your data or paste a sample.

justvinhhere/bigquery-expert

Command

Estimate the cost of a BigQuery query or table. Pass a query, file path, or table description.

justvinhhere/bigquery-expert

Command

Explain a BigQuery feature, function, or concept with working examples. Pass the feature name or question.

justvinhhere/bigquery-expert

Command

Generate optimized BigQuery SQL from a natural language description. Pass a description of the data you need.

justvinhhere/bigquery-expert

Command

Optimize BigQuery SQL by fixing all detected anti-patterns. Pass a file path or paste SQL directly.

justvinhhere/bigquery-expert

Command

Review BigQuery SQL for performance anti-patterns. Pass a file path or paste SQL directly.

justvinhhere/bigquery-expert

Skill Claude CodeCodex

Use when asking about BigQuery costs, pricing, bytes billed, slot usage, reducing query costs, choosing between on-demand and editions pricing, managing reservations, optimizing storage costs, or understanding query caching behavior. Triggers on: "cost", "pricing", "bytes billed", "slot", "reservation", "on-demand"…

justvinhhere/bigquery-expert

Skill Claude CodeCodex

Use when asking about BigQuery-specific features, syntax, or capabilities including: STRUCT/ARRAY/UNNEST patterns, MERGE statements, BigQuery scripting (DECLARE, IF, LOOP, BEGIN/END), scheduled queries, remote functions, JSON functions, approximate aggregation (APPROXCOUNTDISTINCT, HLLCOUNT), geography/GIS functions…

justvinhhere/bigquery-expert

Skill Claude CodeCodex

Use when writing, reviewing, or optimizing BigQuery SQL, asking about BigQuery best practices, working with .sql files targeting BigQuery, or troubleshooting slow/expensive BigQuery queries. Symptoms: high slot consumption, full table scans, expensive joins, slow queries, high bytes billed.

justvinhhere/bigquery-expert

Skill Claude CodeCodex

Use when generating BigQuery SQL from natural language descriptions, converting queries from other SQL dialects to BigQuery, writing new BigQuery queries from scratch, or when the user describes what data they need and expects SQL output. Triggers on: "write me a query", "generate SQL", "how do I query", "convert this…

justvinhhere/bigquery-expert

Skill Claude CodeCodex

Use when designing BigQuery table schemas, choosing partitioning or clustering strategies, deciding between nested/repeated fields vs flat schemas, selecting table types (native, external, views, materialized views), choosing data types, or planning denormalization. Triggers on: "partition", "cluster", "STRUCT"…