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 the AI a complete, structured Prisma Client API reference so it generates accurate database code instead of guessing at method names or operator syntax. ## 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 operators, logical operators (AND/OR/NOT), relation filters (some/every/none/is), and nested write patterns 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 guidance. - Use Case: When you ask the AI to "write a query that finds all published posts by verified authors with pagination", it consults this reference to produce correct where, orderBy, take, and cursor syntax. ## Quick Start Ask the AI to write a Prisma query for your model, such as fetching filtered records with relations and pagination, and it will apply the correct API patterns from this reference.
