What problem does it solve? Writing correct Prisma Client queries requires knowing dozens of methods, filter operators, and transaction patterns, and mistakes lead to runtime errors or SQL injection vulnerabilities. This Skill gives you an authoritative, structured reference so you can write accurate database queries on the first attempt. ## Core Features & Use Cases - Complete CRUD Reference: Covers findUnique, findMany, create, update, upsert, delete, count, aggregate, and groupBy with typed examples. - Filtering and Relations: Documents scalar, logical, array, JSON, and relation filter operators (some, every, none, is) plus nested writes and connectOrCreate 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 paginates users, filters by role, and includes related posts, consult this Skill to compose the correct findMany call with where, orderBy, take, cursor, and include options. ## Quick Start Ask the AI to write a Prisma query that finds all published posts by a given author with pagination and includes the comment count for each post.
