database-migration

The database-migration skill provides expert guidance for safely managing and evolving database schemas using Alembic in combination with SQLAlchemy models. It ensures that all changes to database models are accompanied by the appropriate migration scripts, maintaining data integrity and preventing potential disruptions. This skill addresses common challenges encountered during schema evolution, such as modifying existing tables, adding or removing columns, creating foreign key relationships, and handling rollback scenarios, all while preserving a stable database state.

Key features include step-by-step guidance for modifying models, generating migrations, reviewing and testing migrations, and safely committing changes. The skill outlines patterns for common operations, including adding nullable or non-nullable columns, creating indexes, and establishing foreign key constraints. It emphasizes safe practices, such as backfilling data when adding non-nullable columns and verifying migrations through upgrade and downgrade operations, ensuring that developers can confidently apply schema changes without risking data loss or corruption.

This skill is particularly useful for backend developers, database administrators, and DevOps engineers who work with Python applications using SQLAlchemy and Alembic. It supports tasks ranging from routine schema updates to complex migrations, including troubleshooting migration errors. Users seeking structured guidance for maintaining consistent database evolution, ensuring smooth rollbacks, and enforcing best practices in version-controlled migrations will benefit most from this skill.