See Database patterns for full reference.
Schema changes:
pnpm prisma migrate dev --name descriptive_name
pnpm check-types
Query rules:
- Always
import { prisma } from '@/lib/prisma' - Always use
selectfor specific fields - Always paginate with
take/skip - Avoid N+1: use
includeor batch withwhere: { id: { in: ids } }
Models: User, Task, Submission, Assessment, Category, Tag, Bookmark