CRUD Operations

The everyday operations — create, read, update, delete. Every method is fully typed — TypeScript knows the exact shape of inputs and outputs.

#findMany

Retrieve multiple records matching a filter. Returns a typed array. Without a where clause, returns all records in the table.

TSfind users

7 lines


1const users = await db.user.findMany({
2  where: { role: 'ADMIN' },            // filter
3  orderBy: { createdAt: 'desc' },      // sort
4  take: 10,                            // LIMIT
5  skip: 20,                            // OFFSET (pagination)
6});
7// users: Array<{ id: string, email: string, name: string | null, ... }>

All arguments are optional. db.user.findMany() with no arguments returns every record in the table.

#findFirst

Returns the first record matching the filter, or nullif none found. Useful when you expect zero or one result but don't have a unique identifier.

8 lines


1const user = await db.user.findFirst({
2  where: { email: { contains: 'admin' } },
3});
4// user: { id: string, email: string, ... } | null
5 
6if (user) {
7  console.log(user.email);  // TypeScript knows this is safe
8}

#findUnique

Like findFirst, but semantically intended for unique field lookups — by ID, email, or any other unique column. Returns null if not found.

3 lines


1const user = await db.user.findUnique({
2  where: { id: 'abc-123-def' },
3});

#create

Insert a new record and return it with all fields populated (uses PostgreSQL'sRETURNING *). Fields with defaults (like id, createdAt) are optional in the input.

9 lines


1const user = await db.user.create({
2  data: {
3    email: '[email protected]',
4    name: 'Alice',
5    role: 'ADMIN',
6  },
7});
8// user.id → 'generated-uuid' (auto-created)
9// user.createdAt → 2026-04-09T... (auto-set)

#update

Update an existing record. Only the fields you include in data are changed — everything else stays the same. Fields with autoUpdate() (like updatedAt) are automatically set to the current time.

5 lines


1const user = await db.user.update({
2  where: { id: 'abc-123' },
3  data: { name: 'Alice Updated', role: 'MODERATOR' },
4});
5// user.updatedAt → automatically set to now

#delete

Remove a record from the database. Returns the deleted record so you can confirm what was removed or log it.

4 lines


1const deleted = await db.user.delete({
2  where: { id: 'abc-123' },
3});
4// deleted: { id: 'abc-123', email: '...', ... }

#count

Count records matching a filter. Returns a plain number.

2 lines


1const total = await db.user.count();                        // all users
2const admins = await db.user.count({ where: { role: 'ADMIN' } }); // filtered

#Method summary

Method	Returns	Use case
`findMany(args?)`	`Promise`	Get multiple records with filters, sorting, pagination
`findFirst(args?)`	`Promise`	Get first matching record
`findUnique(args)`	`Promise`	Get by unique field (ID, email)
`create(args)`	`Promise`	Insert a new record
`update(args)`	`Promise`	Update an existing record
`delete(args)`	`Promise`	Remove a record
`count(args?)`	`Promise`	Count matching records