gabrielmoreira Skill: prisma-schema-designer
Provides reference patterns for Prisma schema design, safe migration sequencing, and seed data.
When to use
- Designing a new data model
- Adding fields or relations to existing models
- Planning a migration strategy for backward-compatible and breaking schema changes
Files
schema.template.prisma— Reference Prisma model with documentation conventionsmigration-checklist.md— Pre-migration safety checklistseed.template.ts— Idempotent seed script pattern
Conventions
- All models use
id String @id @default(cuid())as the primary key. - All models include
createdAt DateTime @default(now())andupdatedAt DateTime @updatedAt. - Use
deletedAt DateTime?for soft-deletable user data. - Enum alternatives: use
Stringfields with Zod enum validation at the application layer. - Foreign keys always have an explicit
@@indexunless included in a unique constraint.