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 Prisma ORM 7.x.

Match @prisma/client, the Prisma CLI, and the selected driver adapter at the same stable 7.x version. The currently verified compatible target is 7.10.0; avoid an unbounded latest install while it selects the Prisma 8 release candidate.

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 and adapter wiring
• 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 and extension methods

Client Instantiation (v7)

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 field
const user = await prisma.user.findUnique({
  where: { email: 'alice@prisma.io' }
})

// Find with filter
const users = await prisma.user.findMany({
  where: { role: 'ADMIN' },
  orderBy: { createdAt: 'desc' },
  take: 10
})

Create records

const user = await prisma.user.create({
  data: {
    email: 'alice@prisma.io',
    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 [alice, bob] = await prisma.$transaction([
  prisma.user.create({ data: { email: 'alice@prisma.io' } }),
  prisma.user.create({ data: { email: 'bob@prisma.io' } })
])
// For a post linked to a newly generated user ID, use a nested write or interactive transaction.

Rule Files

Detailed API documentation:

references/constructor.md        - PrismaClient constructor options
references/model-queries.md      - CRUD operations
references/query-options.md      - select, include, omit, where, orderBy
references/filters.md            - Filter conditions and operators
references/relations.md          - Relation queries and nested operations
references/transactions.md       - Transaction API
references/raw-queries.md        - $queryRaw, $executeRaw
references/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.