database-migration

Execute database migrations across Sequelize, TypeORM, and Prisma with rollback procedures.

2|Updated Feb 6, 2026

Search Tags:#database #schema #migration #orm #data transformation #zero-downtime

Ready to run

npx skills add https://github.com/bcastelino/agent-skills-kit --skill database-migration-bcastelino

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-migration
Source: https://github.com/bcastelino/agent-skills-kit/tree/main/skills/database-migration
Command: npx skills add https://github.com/bcastelino/agent-skills-kit --skill database-migration-bcastelino

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) and assets (resource) and resources (resource) components.

What problem does it solve?

This Skill addresses the complexities and risks associated with modifying database schemas and migrating data, ensuring data integrity and minimizing downtime.

Core Features & Use Cases

ORM Support: Handles migrations for popular ORMs like Sequelize, TypeORM, and Prisma.
Zero-Downtime Strategies: Implements advanced techniques for schema changes without interrupting service.
Data Transformation: Provides patterns for complex data manipulation during migration.
Rollback Procedures: Ensures safe reversion in case of migration failures.
Use Case: You need to add a new, non-nullable column to a large users table in production. This Skill provides the step-by-step process to do so safely, including backfilling data and adding the constraint without locking the table for an extended period.

Quick Start

Use the database-migration skill to generate a Sequelize migration script for adding a new 'status' column to the 'users' table.

Frequently Asked Questions about database-migration

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I add a non-nullable column to a large production table without locking it?▼

Zero-downtime database migration strategies allow adding non-nullable columns to large tables without extended locks. This involves backfilling data and adding constraints incrementally to maintain service availability.

Can I execute schema migrations for TypeORM and Prisma using the same process?▼

Yes, you can execute database migrations across TypeORM, Prisma, and Sequelize using a unified process. It manages platform-specific schema changes, data transformations, and rollback procedures across these ORMs.

What is the safest way to rollback a failed database schema migration?▼

The safest way to rollback a failed database migration is using structured rollback procedures. These ensure safe reversion of schema changes and data manipulations to restore the prior database state.

How do I handle complex data transformation during a zero-downtime migration?▼

Handle complex data transformation during zero-downtime migration by applying dedicated data manipulation patterns. This ensures data integrity is maintained while modifying schemas without interrupting active service.

Does zero-downtime database migration work with Sequelize?▼

Yes, zero-downtime database migration works with Sequelize. It supports generating Sequelize migration scripts that implement advanced schema change techniques without locking tables or interrupting service.