What problem does it solve? Writing correct Prisma Client queries requires knowing dozens of methods, filter operators, and transaction patterns, and mistakes lead to runtime errors or inefficient database access. This Skill gives the AI a complete, structured reference so it generates accurate Prisma Client code on the first attempt. ## Core Features & Use Cases - Model Query Reference: Covers all CRUD methods including findUnique, findMany, create, update, upsert, delete, count, aggregate, and groupBy with return-type documentation. - Filtering and Relations: Documents scalar, logical, relation, array, and JSON filter operators plus nested writes, connectOrCreate, and relation counting. - Transactions and Raw SQL: Explains sequential and interactive $transaction patterns, isolation levels, and safe $queryRaw/$executeRaw usage with SQL injection prevention guidance. - Use Case: When building a Next.js API route that needs paginated, filtered user queries with related posts inside a transaction, the AI consults this reference to produce correct, type-safe Prisma Client code. ## Quick Start Ask the AI to write a Prisma query that finds all published posts with their authors, ordered by creation date with cursor pagination.
