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.

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

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

Method	Description
findUnique()	Find one record by unique field
findUniqueOrThrow()	Find one or throw error
findFirst()	Find first matching record
findFirstOrThrow()	Find first or throw error
findMany()	Find multiple records
create()	Create a new record
createMany()	Create multiple records
createManyAndReturn()	Create multiple and return them
update()	Update one record
updateMany()	Update multiple records
updateManyAndReturn()	Update multiple and return them
upsert()	Update or create record
delete()	Delete one record
deleteMany()	Delete multiple records
count()	Count matching records
aggregate()	Aggregate values (sum, avg, etc.)
groupBy()	Group and aggregate

Query Options

Option	Description
where	Filter conditions
select	Fields to include
include	Relations to load
omit	Fields to exclude
orderBy	Sort order
take	Limit results
skip	Skip results (pagination)
cursor	Cursor-based pagination
distinct	Unique values only

Client Methods

Method	Description
$connect()	Explicitly connect to database
$disconnect()	Disconnect from database
$transaction()	Execute transaction
$queryRaw()	Execute raw SQL query
$executeRaw()	Execute raw SQL command
$on()	Subscribe to events
$extends()	Add extensions

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 [user, post] = await prisma.$transaction([
  prisma.user.create({ data: { email: 'alice@prisma.io' } }),
  prisma.post.create({ data: { title: 'Hello', authorId: 1 } })
])

Rule Files

Detailed API documentation:

rules/constructor.md        - PrismaClient constructor options
rules/model-queries.md      - CRUD operations
rules/query-options.md      - select, include, omit, where, orderBy
rules/filters.md            - Filter conditions and operators
rules/relations.md          - Relation queries and nested operations
rules/transactions.md       - Transaction API
rules/raw-queries.md        - $queryRaw, $executeRaw
rules/client-methods.md     - $connect, $disconnect, $on, $extends

Filter Operators

Operator	Description
equals	Exact match
not	Not equal
in	In array
notIn	Not in array
lt, lte	Less than
gt, gte	Greater than
contains	String contains
startsWith	String starts with
endsWith	String ends with
mode	Case sensitivity

Relation Filters

Operator	Description
some	At least one related record matches
every	All related records match
none	No related records match
is	Related record matches (1-to-1)
isNot	Related record doesn't match

Resources

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