What problem does it solve? Prisma ORM has non-obvious traps that cause production bugs: updateMany returning counts instead of records, interactive transactions timing out after 5 seconds, migrate dev resetting databases, and @updatedAt silently skipping bulk writes. This Skill provides production-tested patterns and anti-pattern warnings so you avoid these pitfalls when building TypeScript backends. ## Core Features & Use Cases - Schema & Query Patterns: ID strategy selection (cuid vs uuid vs autoincrement), include vs select guidance, N+1 prevention, and cursor-based pagination with stable ordering. - Transaction & Migration Safety: Correct $transaction form selection, expand-and-contract migrations for breaking changes, and migrate deploy vs migrate dev rules for CI/CD. - Serverless & Error Handling: PrismaClient singleton with globalThis caching, connection_limit tuning for Vercel/Lambda, and P2002/P2025/P2003 error translation to domain errors. - Use Case: You are adding a NOT NULL column to a live users table. The Skill walks you through the three-step expand-and-contract migration (add nullable column, backfill data, add constraint) so you never lock the table or drop data in production. ## Quick Start Ask the agent to review your Prisma schema and service layer for common traps like updateMany return values, missing updatedAt on bulk writes, and unsafe migrate dev usage.
