What problem does it solve? Writing correct Prisma Client queries requires knowing dozens of methods, filter operators, relation patterns, and transaction options. This Skill provides a structured API reference so you can write accurate database queries without guessing syntax or digging through external documentation. ## 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 operators, logical operators (AND, OR, NOT), relation filters (some, every, none, is), and nested writes. - 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 an Express endpoint that paginates users filtered by role, consult the query-options and filters references to compose the correct where, orderBy, take, and skip clauses. ## Quick Start Ask the AI to write a Prisma query that finds all published posts with their authors, ordered by creation date and limited to ten results.
