---
name: prisma-workflow
description: Prisma workflow for schema changes, migrations, and common pitfalls in this repo.
compatibility: opencode
---

Use this when changing the database schema or repository layer.

## Key files

- Schema: `prisma/schema.prisma`
- Migrations: `prisma/migrations/`
- Seed: `prisma/seed.ts`

## Common commands

- Generate client: `npm run prisma:generate`
- Create/apply migration (dev): `npm run prisma:migrate:dev`
- Introspect DB -> schema: `npm run prisma:db:pull`
- Explore data: `npm run prisma:studio`

## Nullability gotcha

- Prisma maps SQL `NULL` to JavaScript `null`.
- Prefer `value !== null` (or truthiness checks) over `value !== undefined` for DB-nullable fields.