database-migration-helper

To create a database migration with rollback support, generate a SQL or code-based migration file containing both the schema alteration and its reverse operation. This Skill provides examples for adding columns and reversing changes safely across supported ORMs.

Yes, this database migration helper works with Prisma and TypeORM, alongside Knex.js and Sequelize. It provides specific structural examples for managing schema modifications and rollbacks across these ORM tools.

Best practices for safe database schema changes in production include ensuring idempotency, testing migrations thoroughly, creating backups, and performing incremental rollouts. This Skill emphasizes these principles to maintain data integrity during schema evolution.

To migrate data during a schema alteration, you execute data transformation logic within the migration file alongside the structural schema changes. This Skill demonstrates how to handle data migration safely while modifying table columns or constraints.

Yes, you can manage foreign keys and indexes using SQL migrations. This Skill includes examples for adding indexes and managing foreign keys to ensure relational database integrity is maintained during schema evolution.