skills.rest
bcastelino
bcastelinoCOMMUNITY
Explore all skills by this author →
Website𝕏@cas7elinoGitHub

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
One-click install
npx skills add https://github.com/bcastelino/agent-skills-kit --skill database-migration-bcastelino
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
TorbenMerraldTorbenMerrald
1

Backend Models

Define and enforce database models and entity schemas across ORM and migration scripts.

Community
Advanced
layeddielayeddie
1

migration-patterns

Plan and execute zero-downtime Elixir/Phoenix database migrations with reversible rollbacks.

Community
Advanced
cbbkrd-techcbbkrd-tech

ln-514-regression-checker

Automates execution of pytest, jest, vitest and go test suites to detect regressions.

Community
Intermediate
dbrijeshdbrijesh

database-migrations

Guide database migration strategies for schema changes, data migrations, and rollbacks.

Community
Advanced