What problem does it solve? Writing correct Prisma Client queries requires knowing dozens of methods, filter operators, relation patterns, and transaction options. This Skill gives you an authoritative, example-driven reference so you write correct database queries the first time without digging through external documentation. ## Core Features & Use Cases - Complete CRUD Reference: Covers findUnique, findMany, create, update, upsert, delete, bulk operations, aggregations, and groupBy with return-type tables. - Filtering and Query Options: Documents scalar, string, logical, relation, array, and JSON filter operators plus select, include, omit, orderBy, and cursor pagination. - Transactions and Raw SQL: Explains sequential and interactive $transaction patterns, isolation levels, and safe $queryRaw/$executeRaw usage with SQL injection prevention. - Use Case: You need to paginate users by role, include their published posts, and wrap a balance transfer in a serializable transaction. Open the matching reference file and copy the exact typed pattern. ## Quick Start Ask the AI to write a Prisma query that finds all admin users with their published posts, ordered by creation date and paginated by cursor.
