migration-schema-change

What problem does it solve?

This skill guides engineers in performing database migrations safely, ensuring data integrity and minimal downtime by planning changes, validating effects on HRIS sync, and mapping dependencies before applying schema updates.

Core Features & Use Cases

• Impact-driven migration planning: Evaluate how adding, altering, or removing columns, modifying enums, or changing foreign keys affects production data and related systems.
• Data migration patterns: Provide templates for migrating data prior to constraints, handling large datasets, and preserving rollback capability.
• HRIS sync awareness: Identify HRIS-managed fields and adjust migrations to avoid disrupting HRIS synchronization.
• Downgrade safety: Ensure each migration has a downgrade path and safe rollback steps.

Quick Start

Create a new Alembic revision with autogenerate and review the generated script for data migrations, then apply to a staging database and verify by running the downgrade.