prisma-add-column-existing-db

What problem does it solve?

This Skill solves the critical issue of adding new fields to existing Prisma models when the database is in active production, where running standard Prisma migration commands like prisma migrate dev would either fail due to existing data constraints or cause irreversible data loss from database resets.

Core Features & Use Cases

• Non-Destructive Production Workflow: Provides a safe, step-by-step process to add new columns without resetting the production database or disrupting live services.
• Relation Field Validation Handling: Automatically addresses Prisma's requirement for opposite relation definitions when adding relational fields to avoid schema validation errors.
• Use Case: For example, a backend team running a production PostgreSQL database for a project management tool can use this Skill to safely add a new project relation field to the existing Attachment model without losing any existing attachment data or causing downtime.

Quick Start

Use the prisma-add-column-existing-db skill to safely add a new optional project relation field to the existing Attachment model in your production PostgreSQL database without resetting the database or losing existing attachment data.