prisma-client-api

Type-safe Prisma queries use the generated client to apply where clauses, select, include, and relation filters. This Skill guides building correct query shapes for CRUD operations with nested relations while maintaining strict TypeScript safety.

Prisma transactions handle nested writes and relation updates through sequential or interactive transaction APIs. This Skill provides guidance on structuring relation filters, nested data operations, and transaction control to ensure safe multi-record database modifications.

Raw SQL queries work safely with Prisma Client using tagged template literals for parameterization. This Skill covers when to use raw queries instead of model methods and how to execute them without risking SQL injection in modern SQL provider workflows.

Prisma Client supports cursor-based pagination and multi-field sorting through query parameters like take, skip, orderBy, and cursor. This Skill helps structure these query patterns correctly for efficient filtered retrieval in TypeScript projects.

Prisma Client configuration involves instantiating with custom adapters, logging settings, and client extensions. This Skill offers version-aware guidance on client setup and TypeScript query fragments to ensure correct provider workflow integration.

Unexpected Prisma relation query shapes often stem from incorrect select, include, or omit usage. This Skill clarifies how to apply these parameters properly alongside relation filters and counts to get the exact nested data structure you need.