What problem does it solve? Writing correct Prisma Client queries requires knowing dozens of methods, filter operators, and transaction patterns. This Skill gives the AI a complete, structured reference so it generates accurate Prisma Client code for CRUD operations, filtering, relations, and raw SQL without guesswork. ## Core Features & Use Cases - Model Query Reference: Covers all CRUD methods including findUnique, findMany, create, update, upsert, delete, count, aggregate, and groupBy with return types. - Filtering and Relations: Documents scalar, logical, relation, array, and JSON filter operators plus nested writes like connect, connectOrCreate, and disconnect. - Transactions and Raw SQL: Explains sequential and interactive $transaction patterns, isolation levels, and safe $queryRaw/$executeRaw usage with SQL injection prevention. - Use Case: When building a Next.js API route that needs paginated, filtered user queries with relation counts, the AI consults this Skill to produce correct Prisma Client code with proper select, include, and cursor pagination. ## Quick Start Ask the AI to write a Prisma query that finds all published posts with their authors, ordered by creation date and paginated by cursor.
