prisma-client-api

Prisma Client API Reference

Complete API reference for Prisma Client. This skill provides guidance on model queries, filtering, relations, and client methods for current Prisma projects.

When to Apply

Reference this skill when:

• Writing database queries with Prisma Client
• Performing CRUD operations (create, read, update, delete)
• Filtering and sorting data
• Working with relations
• Using transactions
• Configuring client options

Rule Categories by Priority

Quick Reference

• constructor - PrismaClient setup, adapter wiring, logging, and SQL commenter plugins
• model-queries - CRUD operations and bulk operations
• query-options - select, include, omit, sort, pagination
• filters - scalar and logical filter operators
• relations - relation reads and nested writes
• transactions - array and interactive transaction patterns
• raw-queries - $queryRaw and $executeRaw safety
• client-methods - lifecycle methods, extensions, and satisfies patterns for prisma-client

Client Instantiation

import { PrismaClient } from '../generated/client'import { PrismaPg } from '@prisma/adapter-pg'const adapter = new PrismaPg({  connectionString: process.env.DATABASE_URL})const prisma = new PrismaClient({ adapter })

Model Query Methods

Query Options

Client Methods

Quick Examples

Find records

// Find by unique fieldconst user = await prisma.user.findUnique({  where: { email: '[email protected]' }})// Find with filterconst users = await prisma.user.findMany({  where: { role: 'ADMIN' },  orderBy: { createdAt: 'desc' },  take: 10})

Create records

const user = await prisma.user.create({  data: {    email: '[email protected]',    name: 'Alice',    posts: {      create: { title: 'Hello World' }    }  },  include: { posts: true }})

Update records

const user = await prisma.user.update({  where: { id: 1 },  data: { name: 'Alice Smith' }})

Delete records

await prisma.user.delete({  where: { id: 1 }})

Transactions

const [user, post] = await prisma.$transaction([  prisma.user.create({ data: { email: '[email protected]' } }),  prisma.post.create({ data: { title: 'Hello', authorId: 1 } })])

Rule Files

Detailed API documentation:

references/constructor.md        - PrismaClient constructor optionsreferences/model-queries.md      - CRUD operationsreferences/query-options.md      - select, include, omit, where, orderByreferences/filters.md            - Filter conditions and operatorsreferences/relations.md          - Relation queries and nested operationsreferences/transactions.md       - Transaction APIreferences/raw-queries.md        - $queryRaw, $executeRawreferences/client-methods.md     - $connect, $disconnect, $on, $extends

Filter Operators

Relation Filters

Resources

• Prisma Client API Reference
• CRUD Operations
• Filtering and Sorting

How to Use

Pick the category from the table above, then open the matching reference file for implementation details and examples.