Local database mode

Run the app on a local Supabase with row-level security and sign in as the seeded users.

Local database mode runs the app against a real Postgres with every access rule switched on. Use it to see what each role can and cannot do.

You also need Docker, because Supabase runs its services in containers. Supabase uses ports 4420 to 4429.

pnpm db:start

pnpm db:reset

This creates the schema, the row-level security policies and the guard triggers.

pnpm db:seed

The seed uses the same generator as demo mode, so the numbers match.

pnpm local

The app runs on http://localhost:4400 with DEMO_MODE=false.

Every seeded user has the password pruva-local. These accounts exist only on your local database.

Email	Person	Role	What to try
`maren@aurora-marine.example`	Maren Holt, fleet manager	owner	Everything, including billing
`kaan@aurora-marine.example`	Kaan Erdem, superintendent	admin	Notify crew, manage members
`ravi@aurora-marine.example`	Ravi Menon, chief engineer	member	Acknowledge alerts, but not notify crew
`sofia@aurora-marine.example`	Sofia Lindqvist, emissions officer	member	Submit reports
`tom@northquay.example`	Tom Achebe, underwriter	member	Sees only the vessels shared with the insurer

Stop Supabase with pnpm db:stop when you are done.

Sign inCopy Anchor Link