skills.rest
drgaciw
drgaciwCOMMUNITY
Explore all skills by this author →
GitHub

database-migration

Execute database schema and data migrations across Sequelize, TypeORM, and Prisma.

Updated Dec 23, 2025
Search Tags:#rollback#database#schema#migration#orm#zero-downtime
One-click install
npx skills add https://github.com/drgaciw/academic-compliance-hub-glm --skill database-migration-drgaciw
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-migration
Source: https://github.com/drgaciw/academic-compliance-hub-glm/tree/main/agents/plugins/framework-migration/skills/database-migration
Command: npx skills add https://github.com/drgaciw/academic-compliance-hub-glm --skill database-migration-drgaciw

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines the complex and often risky process of migrating database schemas and data, ensuring data integrity and minimizing downtime.

Core Features & Use Cases

  • ORM Agnostic Migrations: Supports Sequelize, TypeORM, and Prisma.
  • Schema Transformations: Safely add, rename, or change column types.
  • Zero-Downtime Strategies: Implements blue-green deployments and phased rollouts.
  • Rollback Procedures: Ensures data can be restored in case of failure.
  • Use Case: Migrating your application's user table from an old schema to a new one without interrupting service.

Quick Start

Use the database-migration skill to execute a new migration script for your Prisma database.

Frequently Asked Questions about database-migration

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

FAQPage Schema
How do I execute zero-downtime database schema migrations?▼

Zero-downtime database migrations are executed using blue-green deployments and phased rollouts to ensure data integrity and minimize downtime during schema upgrades. This approach allows seamless database version refactoring.

Can I run database migrations using TypeORM, Sequelize, and Prisma?▼

Yes, this ORM agnostic approach supports running database migrations across Sequelize, TypeORM, and Prisma. It facilitates schema transformations and data migrations between these different Object-Relational Mappers.

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

The best way to rollback a failed database schema migration is by executing dedicated down migration scripts. These rollback procedures restore the database schema and data to their previous state in case of failure.

How do I safely rename or change column types without dropping data?▼

Safely renaming or changing column types requires careful planning and execution of schema transformations. Using phased rollouts ensures data is preserved while the database structure is updated without interrupting service.

Do I need to write separate up and down scripts for every database migration?▼

Yes, you need to write separate up and down scripts for every database migration. The up scripts apply schema changes, while the down scripts define the rollback procedures to reverse those changes if needed.

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
cdalsoniiicdalsoniii

Schema Migration

Generate SQL schema migrations with rollback procedures and multi-phase execution.

Community
Advanced
saeed-vayghansaeed-vayghan
30

deployment-engineer

Automate CI/CD pipeline design and deployment strategies.

Community
Advanced
linenoizelinenoize
1

db

Generate rollback-aware database migration files and validate schema changes.

Community
Advanced