Prisma Patterns

This is the Prisma skill you reach for when you're past the getting-started docs and need production patterns. It covers the traps that bite you at scale: updateMany returning counts instead of records, @updatedAt silently skipping bulk writes, migrate dev resetting your database, and serverless connection pool exhaustion. You'll find cursor pagination with the limit-plus-one trick, soft delete patterns without middleware magic, transaction form selection (array vs interactive), and schema design decisions around ID strategies and indexing. Tested against Prisma 5 and 6, with notes on relationJoins and when it causes row explosion. Written for TypeScript backends where one bad query pattern can tank your API latency.

skills.sh installs: 1.4K
GitHub stars: 229.1K
last updated: Jul 14, 2026

View on GitHub

Install

$ npx -y skills add affaan-m/everything-claude-code --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