YepAPI/skills

Prisma

Rules

• Schema in prisma/schema.prisma — single source of truth
• Use select over include — fetch only needed fields
• Transactions for multi-step mutations: prisma.$transaction([...])
• Soft deletes via deletedAt DateTime? field + middleware filter
• Indexes on frequently queried fields: @@index([fieldName])
• Relations: always define both sides (@relation)
• Migrations: npx prisma migrate dev --name descriptive-name
• Connection pooling for serverless: use Prisma Accelerate or PgBouncer
• Type generation: npx prisma generate after schema changes

Avoid

• include: { relation: true } when you only need one field — use select instead
• N+1 queries — use include or select with nested relations
• Raw SQL when Prisma API can handle it — only use $queryRaw for complex aggregations
• prisma.table.findMany() without take limit — always paginate