db-reset-local

Use this when you need a clean local database state.

Canonical command

• npm run db:reset:local

What it does

• Resets the local Supabase database (npx supabase db reset --local).
• Ensures the local prisma DB user exists (node scripts/create-prisma-user.js).
• Resets Prisma migrations (prisma migrate reset).
• Seeds data (npm run db:seed).

Prereqs

• Supabase running locally: npx supabase start.
• .env includes:

- DATABASEURL (Prisma connection string) - PRISMADB_PASSWORD (used by scripts/create-prisma-user.js)

Notes

• Integration tests may also require POSTGRESDBURL so the test harness can create extensions.