What problem does it solve? Writing correct Prisma Client queries requires knowing dozens of methods, filter operators, relation patterns, and transaction APIs. This Skill gives you an authoritative reference so you can write accurate database queries without guessing syntax or digging through external documentation. ## Core Features & Use Cases - Complete Query Reference: Covers all model query methods including findUnique, findMany, create, update, upsert, delete, count, aggregate, and groupBy with return types. - Filtering and Relations: Documents scalar and logical filter operators, relation filters (some, every, none, is), nested writes, and connect/disconnect patterns. - 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 to fetch paginated users with their published posts inside a transaction, consult this Skill to get the exact query options, cursor pagination syntax, and transaction client patterns. ## Quick Start Ask the AI to write a Prisma query that finds all admin users with their published posts ordered by creation date, and it will apply the correct findMany, where, include, and orderBy syntax from this reference.
