prisma-migrationslisted

# Prisma Migrations Skill This skill provides best practices for managing database schema changes with Prisma Migrate, covering development workflows, production deployments, CI/CD integration, and handling existing databases. ## Overview Prisma Migrate is a declarative database migration tool that keeps your database schema in sync with your Prisma schema. It creates a migration history (SQL files) that can be version-controlled and deployed consistently across environments. **Key Concepts:** - **Migration files**: SQL files stored in `prisma/migrations/` that represent schema changes - **Migration history**: The `_prisma_migrations` table tracks which migrations have been applied - **Shadow database**: A temporary database used during `migrate dev` to detect drift ## When to Use Prisma Migrate | Scenario | Tool | Reason | | ----------------------------------------------- | ----------------------- | ---------------------------------------- | | Adding/modifying tables in development | `prisma migrate dev` | Creates versioned migration files | | Deploying to staging/production | `prisma migrate deploy` | Applies pending migrations safely | | Quick prototyping (no migration history needed) | `prisma db push` | Syncs schema without creating migrations | | Checking migration status | `prisma migrate status` | Sho