What problem does it solve? Prisma projects often suffer from N+1 queries, failed migrations, connection pool exhaustion in serverless environments, and schema design mistakes that are hard to diagnose without deep ORM expertise. ## Core Features & Use Cases - Schema Design Review: Validates relation definitions, indexes, cascade behaviors, and naming conventions with npx prisma validate and @@map/@@index patterns. - Safe Migration Workflows: Guides development migrations with migrate dev and production deployments with migrate deploy, including conflict resolution via migrate resolve. - Query Optimization: Detects N+1 problems and over-fetching, then applies include, select, and $queryRaw fixes with query logging for diagnosis. - Connection & Transaction Management: Implements the global singleton pattern for serverless (Vercel/Lambda), pool limits in DATABASE_URL, and interactive transactions with isolation levels and optimistic concurrency. - Use Case: A Next.js app on Vercel hits "too many connections" errors in production; the skill diagnoses the hot-reload client recreation issue and applies the global singleton pattern plus connection_limit tuning. ## Quick Start Ask the assistant to review your prisma/schema.prisma file and diagnose any slow queries or migration errors in your project.
