What problem does it solve?
This Skill eliminates the risk of Silver data transformation layer drift when upstream specifications (logical layer designs, data models, transformation rules, data quality rules) are updated, avoiding broken downstream pipelines and manual full rewrites of unchanged code.
Core Features & Use Cases
- Controlled Update Modes: Apply only story-authorized changes, diff current code against approved upstream artifacts, or fully regenerate all Silver modules as needed.
- Automated Versioning & Synchronization: Enforce 3-scenario versioning rules, update contracts, DQ rules, and migration DDL to match upstream changes.
- Downstream Ripple Protection: Automatically surface required Gold layer updates to prevent breakages from Silver schema or logic changes.
- Use Case: When a data model adds a new patient race column, the skill updates only the affected Silver transform, its contract, DQ rules, and migration DDL while leaving all other Silver modules untouched.
Quick Start
Use the update-silver skill to align your existing Silver data layer with the latest approved upstream specifications and apply any required downstream ripple updates.