How to use Postgres

export default defineConfig({
  db: { enabled: true, migrations: "migrations" },
});

DATABASE_URL=postgres://user:pass@127.0.0.1:5432/mydb

create table notes (
  _id text primary key check (keja_is_typeid(_id)),
  _object text not null check (keja_is_object_type(_object)),
  _tenant text not null check (keja_is_tenant(_tenant)),
  _archived boolean not null default false,
  "_createdAt" timestamptz not null,
  "_updatedAt" timestamptz not null,
  check (keja_timestamps("_createdAt", "_updatedAt")),
  message text not null
);

keja migrate

import { defineRepositories } from "@veducio/keja";

export default defineRepositories({
  notes: { list: true, get: true },
});

keja generate

import { defineRoute, response } from "@veducio/keja";
import { z } from "zod";
import { notes } from "../db/repositories.ts";

export default defineRoute({
  method: "get",
  path: "/notes",
  version: "v1",
  request: { query: notes.list.schema },
  responses: {
    Notes: response({
      code: 200,
      json: z.object({
        notes: z.array(notes.meta),
        nextCursor: z.string().nullable(),
      }),
    }),
  },
  handler: async ({ query, respond }) => {
    const page = await notes.list(query, {
      tenant: "tenant_01h455vb4pex5vsknk084sn02q",
    });
    return respond.Notes({
      notes: page.items,
      nextCursor: page.nextCursor,
    });
  },
});

import { defineSeeder } from "@veducio/keja";

const at = new Date("2026-01-15T00:00:00.000Z");

export default defineSeeder({
  table: "notes",
  objects: [
    {
      _id: "notes_01h455vb4pex5vsknk084sn02q",
      _object: "v1.notes",
      _tenant: "tenant_01h455vb4pex5vsknk084sn02q",
      _archived: false,
      _createdAt: at,
      _updatedAt: at,
      message: "hello",
    },
  ],
});

keja seed