Prisma Patterns

This is the Prisma cheat sheet you wish you'd had before running `updateMany` and wondering why it returned a count instead of records, or before `migrate dev` reset your local database mid-sprint. It covers the traps that actually bite: `@updatedAt` skipped on bulk writes, `$transaction` timeouts in long operations, serverless connection pool exhaustion, and the N+1 problem with eager loading. You also get practical patterns for cursor pagination, soft delete filtering, singleton client setup, and when to use the interactive versus array transaction form. Activate it when writing queries, designing schemas, or deploying to serverless, especially if you're past the tutorial phase and dealing with production edge cases.

skills.sh installs: 5.5K
GitHub stars: 300.3K
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add affaan-m/ecc --skill prisma-patterns --agent claude-code

Installs into .claude/skills of the current project.

Files

Prisma Patterns

Production patterns and non-obvious traps for Prisma ORM in TypeScript backends.

Check your version before applying patterns. The Prisma API surface has evolved across major releases:
npx prisma --version
Notable API differences across versions:

relationJoins can load relations via JOIN rather than separate queries, but may cause row explosion on large 1:N relations or deep include — benchmark both approaches

omit field modifier and prisma.$extends Client Extensions API were added

Newer installs: the package may be named prisma instead of @prisma/client; PrismaClient may require a driver adapter (e.g. @prisma/adapter-pg); datasource.url may live in prisma.config.ts instead of schema.prisma

CLI commands (migrate dev, migrate deploy, generate) are unchanged across versions