justvinhhere

Bq Optimize — Data skill for Claude Code

Data community

Optimize BigQuery SQL by fixing all detected anti-patterns.

How to install Bq Optimize

Installs to ~/.claude/skills/justvinhhere-bigquery-expert-bq-optimize/SKILL.md

Terminal
mkdir -p ~/.claude/skills/justvinhhere-bigquery-expert-bq-optimize && curl -fsSL https://raw.githubusercontent.com/justvinhhere/bigquery-expert/HEAD/commands/bq-optimize.md -o ~/.claude/skills/justvinhhere-bigquery-expert-bq-optimize/SKILL.md

Restart Claude Code, or start a new session, for it to be picked up.

What Bq Optimize does

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 conversati

Alternatives in Data

  • Osint Employees — Gather employee names + email patterns for password spray prep 4.5k ★
  • n8n Code JavaScript — JavaScript in n8n Code nodes with data access patterns 3.6k ★
  • Skill Content Pipeline — Extract patterns and anatomy from URLs — use to reverse-engineer content strategies from live pages 2.8k ★

Full documentation available on GitHub

View Source Repository

Related Skills

Bq Review — Data skill for Claude Code

Bq Review

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

Data community
Bq Generate — Data skill for Claude Code

Bq Generate

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

Data community
Run Analyzer — Data skill for Claude Code

Run Analyzer

Run the weekly channel-patterns analyzer end-to-end. Pulls data-health + canonical queries from BigQuery, draf

Data community
Graph Engineering — Data skill for Claude Code

Graph Engineering

Graph engineering for AI agents: the 9-stage knowledge-graph pipeline (translated from SEU's graduate course)

Data community
Wp Perf Review — Data skill for Claude Code

Wp Perf Review

WordPress performance code review - detects database anti-patterns, caching issues, hook problems, and scalabi

Data community
UX Dashboard — Data skill for Claude Code

UX Dashboard

Specialized dashboard generation. Data density, tabular monospace, sparkline patterns, anti-card-overuse, sema

Data community

Related Agents

Missing Metadata Schema Curator — Development agent for Claude Code

Missing Metadata Schema Curator

Autonomously picks up pre-generated _missing_metadata.yaml files from bigquery_etl/schema/missing_metadata/ an

Development community
DB — Data & AI agent for Claude Code

DB

Database workflow specialist — migration generation (up + down), breaking change detection, index recommendati

Data & AI community
Verify Duplication — Content & Marketing agent for Claude Code

Verify Duplication

STAGE 4 VERIFICATION - Code duplication detection. Uses token-based and structural analysis to find copy-paste

Content & Marketing community