Reads

Every table delegate exposes the same read methods. They differ in how many rows they return and how they handle "not found".

findMany

Returns every matching row. The default when you want a list, a feed, or relation loading.

const users = await client.users.findMany({
	where: { active: true },
	orderBy: [{ id: 'asc' }],
	take: 25,
});

findMany accepts the full query surface: where, select / include, orderBy, take, skip, and cursor.

findFirst

The first row after filtering and ordering. Use it when the query can match many rows but you only want one.

const newest = await client.users.findFirst({
	where: { active: true },
	orderBy: [{ id: 'desc' }],
});

findOne

An alias for findFirst, read for intent: a single nullable row where the caller owns the not-found decision.

const user = await client.users.findOne({
	where: { id: 42 },
});

findUnique

Reads best when the lookup is driven by a unique field such as email or a slug.

const user = await client.users.findUnique({
	where: { email: 'alice@example.com' },
});

count and exists

count returns the number of matching rows. exists is a cheap existence check that never materializes a row.

const activeCount = await client.users.count({
	where: { active: true },
});

const taken = await client.users.exists({
	where: { email: 'alice@example.com' },
});

Ordering, limit, and offset

const page = await client.posts.findMany({
	orderBy: [{ published: 'desc' }, { id: 'desc' }],
	skip: 20,
	take: 10,
});

• orderBy takes one field map or an array for multi-column ordering.
• take caps the number of rows. A negative take reverses the order and takes from the end.
• skip offsets from the start.

For full pages with metadata (count, hasNext, hasPrevious), use paginate instead of assembling it by hand.

Throwing when a row is required

findFirst, findOne, and findUnique return a value that is both awaitable as Row | null and exposes .throw():

// Treat not-found as null
const maybeUser = await client.users.findUnique({
	where: { email },
});

// Treat not-found as exceptional
const user = await client.users
	.findUnique({ where: { email } })
	.throw(() => new Error('User not found'));

See throwing results for the full pattern.

Choosing a read method