221 curated data & analytics skills, agents, commands and plugins — from original author repos, ranked by GitHub signal.
jeremylongshore
Phase 2 of the BigQuery schema optimization pipeline — reads the phase 1 report and schema exports to identify fields with >90% null rates, detect never-queried columns, and produce ranked removal and archival recommendations as a markdown report plus strict JSON for phase 3. Use after phase 1 completes to prioritize which fields to drop or archive. Trigger with \"run schema phase 2\", \"analyze field utilization\".
jeremylongshore
Phase 3 of the BigQuery schema optimization pipeline — evaluates proposed schema changes from phases 1-2 against dependent queries and systems, categorizes each change by risk level, estimates storage and cost savings, and produces an impact matrix as a markdown report plus strict JSON for phase 4. Use when deciding which field removals are safe to execute. Trigger with \"run schema phase 3\", \"assess schema change impact\".
jeremylongshore
Runs BigQuery field-utilization shell scripts to empirically validate phase 2-3 conclusions, reconciles manual vs. script findings, and writes a verification report. Use when phase 3 analysis is complete and you need script-backed evidence. Trigger with "run verification", "validate phase 3 findings".