migration-strategies

Name: migration-strategies
Availability: InStock
Author: MolcajeteAI

Guide database schema and data migrations with Prisma and Drizzle.

2|1|Updated Nov 13, 2025

Search Tags:#best practices #database #drizzle #schema #migration #sql #prisma

Ready to run

npx skills add https://github.com/MolcajeteAI/plugin --skill migration-strategies

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: migration-strategies
Source: https://github.com/MolcajeteAI/plugin/tree/main/deprecated/tech-stacks/js/node/skills/migration-strategies
Command: npx skills add https://github.com/MolcajeteAI/plugin --skill migration-strategies

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill addresses the complexities and risks associated with managing database schema changes and data migrations, ensuring smooth and safe updates.

Core Features & Use Cases

Safe Migration Patterns: Provides strategies for adding/removing columns, renaming columns, and adding indexes without downtime.
Workflow Guidance: Details best practices for both Prisma and Drizzle ORMs, including development and production commands.
Data Migration: Offers patterns for backfilling and transforming data safely.
Use Case: When deploying a new feature that requires adding a non-nullable column to a critical users table, this skill guides you through the multi-step process to avoid application errors and downtime.

Quick Start

Use the migration-strategies skill to learn how to safely add a new column to the users table using Prisma.

Frequently Asked Questions about migration-strategies

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

FAQPage Schema

How do I safely add a non-nullable column to a database schema without downtime?▼

To safely add a non-nullable column without downtime, you must follow a multi-step migration pattern: first add the column as nullable, backfill the data, update the application to use it, and finally enforce the non-nullable constraint. This strategy prevents application errors and database locks.

Does this database migration guidance cover both Prisma and Drizzle ORM?▼

Yes, this database migration guidance covers workflow best practices for both Prisma and Drizzle ORMs. It provides specific development and production commands, safe schema evolution patterns, and zero-downtime checklists tailored to these frameworks.

What is the best way to backfill data during a database migration?▼

The best way to backfill data during a database migration is to use safe data transformation patterns that operate in batches. This skill provides strategies for backfilling data safely without locking tables or causing downtime during schema evolution.

How do I create database indexes on large tables without locking?▼

Creating indexes without locking requires using specific safe migration patterns outlined in this guidance. It details strategies for adding indexes to critical tables without downtime, ensuring continuous application availability during schema changes.

What are the rollback procedures for failed database schema changes?▼

Rollback procedures for failed database schema changes are included as a core component of this migration guidance. It provides strategies to safely reverse column alterations, index creations, and data backfills to restore your database to its previous stable state.

When do I need a zero-downtime database migration checklist?▼

You need a zero-downtime database migration checklist when deploying schema changes to critical production tables. This skill includes checklists and CI/CD integration examples to verify that column alterations, data backfills, and index creations proceed safely.