detecting-schema-drift

What problem does it solve?

This Skill addresses the critical issue of database schema drift, where production schemas diverge from version-controlled definitions, leading to silent migration failures and recovery divergence.

Core Features & Use Cases

• Catalog-vs-VCS Comparison: Compares production database schemas against version-controlled definitions using tools like Atlas.
• Automated Drift Checks: Implements hourly or scheduled checks to detect drift automatically.
• Dynamic Partition Exclusions: Manages expected drift from dynamically created partitions.
• Emergency Hotfix Reconciliation: Provides a workflow for backporting and reconciling out-of-band production changes.
• Use Case: When a production database schema is found to be out of sync with the codebase's migration files, this Skill can be used to identify the discrepancies, understand their cause, and generate the necessary migration scripts to bring them back into alignment.

Quick Start

Use the detecting-schema-drift skill to compare the production database schema against the version-controlled migrations.