Migrations and Seeding

Prisma workflow

# Create and apply a new migration to developer database
pnpm prisma migrate dev --name <migration-name>

# Regenerate the Prisma client after schema changes
pnpm prisma generate

# Apply pending migrations to the production database
pnpm migrate:prod

# Seed the database
pnpm seed

# Remove just your namespaced seed data from the shared dev database
pnpm seed:clean

Important safety notes

• pnpm seed automatically clears the current namespace before reseeding.
• Never run pnpm prisma migrate deploy directly because it can pick up .env.local.
• Always use pnpm migrate:prod for production migration deployment.
• pnpm seed:clean uses the same SEED_NAMESPACE resolution as pnpm seed.

Adding a new model

1. Add the model to prisma/schema.prisma.
2. Create the migration with pnpm prisma migrate dev --name <migration-name>.
3. Deploy to CI automatically.
4. If production already has the table, resolve the migration as applied and run pnpm migrate:prod.