prisma-migration-assistant

Plan and execute Prisma schema migrations with SQL preview and rollback strategies.

Updated Jan 24, 2026
One-click install
npx skills add https://github.com/Camilo8902/GabyCosmetics --skill prisma-migration-assistant-camilo8902
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: prisma-migration-assistant
Source: https://github.com/Camilo8902/GabyCosmetics/tree/main/.claude/skills/prisma-migration-assistant
Command: npx skills add https://github.com/Camilo8902/GabyCosmetics --skill prisma-migration-assistant-camilo8902

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines the process of managing database schema changes with Prisma, ensuring data integrity and providing safety nets for complex migrations.

Core Features & Use Cases

  • Safe Schema Changes: Guides users through additive, renaming, transformation, and type-change migrations.
  • Data Backfills & Rollbacks: Provides strategies for handling data during and after migrations, including rollback scripts.
  • Testing & Preview: Includes methods for testing migrations and previewing SQL changes before execution.
  • Use Case: Safely refactor your database schema by splitting a name field into firstName and lastName, including data migration and rollback plans.

Quick Start

Use the prisma-migration-assistant skill to preview a migration named 'add_user_email_unique'.

Frequently Asked Questions about prisma-migration-assistant

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

FAQPage Schema
How do I handle data backfill when renaming a column in a Prisma migration?

To handle data backfill during a Prisma migration, you can use strategies that split fields, like separating a name into firstName and lastName, while executing scripts to migrate existing data and prepare rollback plans.

What is the best way to preview SQL changes before executing a Prisma schema migration?

Previewing SQL changes before a Prisma schema migration involves generating detailed SQL examples and backfill scripts, allowing you to verify additive changes, data transformations, and type changes before actual execution.

Can I create a rollback strategy for complex Prisma schema changes involving type changes?

Yes, you can create rollback strategies for complex Prisma schema changes, including type changes and data transformations, ensuring data integrity by providing specific scripts to revert modifications safely.

How do you safely transform data types in a Prisma database migration?

Safely transforming data types in a Prisma database migration requires planning patterns for type changes, executing data backfills to maintain integrity, and testing the migration before applying it to the production database.

When do I need to use an additive migration pattern for Prisma schema changes?

You need an additive migration pattern for Prisma schema changes when adding new fields or tables without altering existing structures, ensuring zero downtime and providing a safe path for subsequent data backfills.