Local database
Run against a local Supabase with sign-in and row-level security.
Local database mode runs the app against a real Postgres with the same rules as production: row-level security, triggers and check constraints. Use it to test access rules and the invariants.
You need Docker running for the local Supabase stack.
Start Supabase
pnpm db:startApply migrations and seed
pnpm db:reset
pnpm db:seeddb:reset rebuilds the schema from the migrations. db:seed writes the same Northwind story the demo uses, with one sign-in per person.
Local services
| Service | URL / port |
|---|---|
| Supabase API | http://localhost:4341 |
| Postgres | port 4342 |
| Supabase Studio | http://localhost:4343 |
| Mail catcher | http://localhost:4344 |
Sign in
Sign in as any seeded person, for example avery@northwind.test (owner). Every seeded person uses the same local password: skyward-local.
The password only exists in your local database. It is never used anywhere real.
| Person | Role | Fleet | Missions | Maintenance | Safety | Compliance | |
|---|---|---|---|---|---|---|---|
| Avery MorganHead of operations | avery@northwind.test | owner | publish | publish | publish | publish | publish |
| Jamie PatelMaintenance lead | jamie@northwind.test | admin | view | view | publish | edit | view |
| Deniz YılmazSafety & compliance officer | deniz@northwind.test | admin | view | publish | view | publish | publish |
| Sam RiveraRemote pilot | sam@northwind.test | member | publish | publish | view | edit | view |
| Taylor KimTechnician | taylor@northwind.test | member | view | view | edit | view | none |
| Alex MorganTechnician | alex@northwind.test | member | view | none | edit | view | none |
| Priya NairMission planner | priya@northwind.test | member | view | edit | none | view | view |
| Preflight AgentAI agent · drafts and checks missions | agent-preflight@northwind.test | agent | view | edit | view | view | none |
| Maintenance PlannerAI agent · proposes work orders | agent-maint@northwind.test | agent | view | none | edit | none | none |