What problem does it solve? Writing correct Prisma Client queries requires knowing dozens of methods, filter operators, relation patterns, and transaction APIs, and mistakes like SQL injection in raw queries or missing rollback logic cause production bugs. ## Core Features & Use Cases - Model Query Reference: Covers all CRUD methods including findUnique, findMany, createManyAndReturn, upsert, aggregate, and groupBy with return-type tables. - Filtering and Relations: Documents scalar operators, logical AND/OR/NOT combinations, relation filters (some, every, none, is), and nested writes like connectOrCreate and disconnect. - Transactions and Raw SQL: Explains sequential versus interactive $transaction patterns, isolation levels, and safe $queryRaw usage with parameterization to prevent SQL injection. - Use Case: When building a paginated user list filtered by role with post counts, consult the query-options and relations references to compose select, orderBy, cursor pagination, and _count correctly on the first attempt. ## Quick Start Ask the AI to write a Prisma query that finds all verified users with at least one published post, ordered by creation date with cursor pagination.
