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 an AI assistant a complete, structured Prisma Client reference so it generates accurate database code instead of guessing at method names or filter syntax. ## Core Features & Use Cases - Model Query Reference: Covers all CRUD methods including findUnique, findMany, create, update, upsert, deleteMany, 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: Ask the assistant to write a paginated query that filters users by role, includes their published posts, and wraps a balance transfer in an interactive transaction — it produces correct Prisma Client code using the reference files. ## Quick Start Ask the assistant to write a Prisma Client query that finds all admin users with their published posts, ordered by creation date with pagination.
