Reading data

Fetch one record or many with Strata ORM, then filter, select, sort, paginate and iterate the results.

Every query chains methods on a model, and the last call in the chain says what you want back and runs the query — usually .all() or .first().

Example schema

The examples on this page use the User and Post models from the data contract.

Fetch many records or one

import { db } from "./strata/db";

// Every published post
const posts = await db.post.where({ published: true }).all();

// One user, or null
const user = await db.user.where({ email: "ada@example.com" }).first();

import { db } from "./strata/db";

const posts = await db.post.where({ published: 1 }).all();
const user = await db.user.where({ email: "ada@example.com" }).first();

Filter records

Filters are plain objects. Several keys mean and; use or for alternatives.

const recent = await db.post
  .where({
    published: true,
    createdAt: { gte: new Date("2026-01-01") },
    or: [{ title: { contains: "launch" } }, { title: { contains: "release" } }],
  })
  .all();

Filter operators

Select fields

const emails = await db.user.select({ id: true, email: true }).all();
// ^? { id: string; email: string }[]

Sort and paginate

const page2 = await db.post.orderBy({ createdAt: "desc" }).skip(20).take(20).all();

Cursor pagination

Offset pagination slows down as the offset grows. For long lists, page by a cursor instead:

const next = await db.post.orderBy({ id: "asc" }).after({ id: lastId }).take(50).all();

Count records

const drafts = await db.post.where({ published: false }).count();

Iterate a large result

.iterate() streams rows in batches so a million-row export never sits in memory at once.

for await (const post of db.post.iterate({ batchSize: 500 })) {
  await index(post);
}

Common mistakes