Does this skill work with BigQuery?

Yes, it is specifically configured to handle BigQuery JSON exports, though the orchestration pattern can be adapted for other data sources.

What kind of output does the orchestrator provide?

It generates a suite of Markdown reports for each phase and a final JSON summary detailing total tables, fields, optimization opportunities, and estimated savings.

How does the skill handle errors during the optimization process?

If any phase fails validation, the orchestrator stops execution immediately, returns a detailed error status, and preserves all partial reports for debugging.

What is the primary purpose of the Schema Optimization Orchestrator?

It manages a complex, multi-step process to analyze database schemas, identify unused fields, and provide validated recommendations for optimization and cost savings.

Schema Optimization Orchestrator

Name: Schema Optimization Orchestrator
Author: jeremylongshore

byjeremylongshore

•

983

•

Database Management

Automates multi-phase database schema optimization workflows through structured validation and comprehensive reporting.

The Schema Optimization Orchestrator is a sophisticated workflow manager designed to streamline complex database audits and schema refinements. It utilizes a test-harness pattern to guide users through five distinct phases: initial analysis, field utilization tracking, impact assessment, script-based verification, and final recommendation generation. By enforcing strict JSON validation at every step and generating isolated session reports, this skill ensures that database optimizations—particularly for platforms like BigQuery—are data-driven, safe to implement, and focused on cost efficiency.

Key Features

01983 GitHub stars

02Isolated session tracking with timestamped documentation and evidence collection

03Sequential multi-phase orchestration with automated state management

04Script-based verification for accurate field utilization analysis

05Strict JSON validation of outputs and file artifacts after every step

06Detailed impact assessment to identify high and medium risk changes

Use Cases

01Optimizing BigQuery data exports to reduce storage and processing costs

02Generating evidence-based implementation plans for database migrations

03Auditing large-scale database schemas for unused or low-utilization fields

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jeremylongshore/claude-code-plugins-plus-skills schema-optimization

For use in Claude.ai and ChatGPT

Download Skill