Feature
Postgres and Drizzle
Drizzle schemas and migrations, a local Supabase stack, and backup and restore scripts.
packages/db holds the Drizzle client, the identity schema, the clientos schema and the migrations. `pnpm db:migrate` and `pnpm db:seed` apply them, and CI proves the migrations apply cleanly to an empty Postgres.
Locally, `pnpm supabase:start` runs Postgres, Auth and Storage in Docker on their own port block, so the stack does not collide with other projects. scripts/db-backup.sh and scripts/db-restore.sh dump and reload the data schemas.
More features
All features →- 01
Typed API with OpenAPI
A Hono API whose routes are OpenAPI definitions, with a generated client for the web.
- 02
Next.js web app
A Next.js 16 App Router app with a login page and a signed-in dashboard shell.
- 03
Organizations and roles
Every record is scoped to an Organization, and every caller holds a Role in it.