What problem does it solve? Prisma developers frequently hit subtle production traps: N+1 query loops, interactive transactions timing out after 5 seconds, updateMany returning counts instead of records, migrate dev resetting databases, and connection pool exhaustion in serverless deployments. This Skill provides version-aware patterns and anti-patterns to avoid these failures. ## Core Features & Use Cases - Schema and Query Patterns: ID strategy selection, index justification, include vs select trade-offs, cursor pagination with stable secondary ordering, and soft-delete filtering. - Transaction and Error Handling: Array vs interactive transaction selection, PrismaClient singleton setup with adapter or direct initialization, and mapping P2002/P2025/P2003 errors to domain exceptions. - Migration and Serverless Safety: Guidance on migrate dev vs migrate deploy, expand-and-contract migration planning, and connection pool sizing for Vercel, Lambda, and PgBouncer environments. - Use Case: When debugging a "Transaction already closed" error in a Next.js API route, use this Skill to identify that an external email call inside an interactive transaction exceeded the 5-second default timeout and restructure the code to move external calls outside the transaction. ## Quick Start Review my Prisma schema and query code for performance traps, transaction misuse, and serverless connection pool issues.
