| name | db-reset-local |
| description | Reset and seed the local database for Drasil. |
| compatibility | opencode |
Use this when you need a clean local database state.
Canonical command
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:
DATABASE_URL (Prisma connection string)
PRISMA_DB_PASSWORD (used by scripts/create-prisma-user.js)
Notes
- Integration tests may also require
POSTGRES_DB_URL so the test harness can create extensions.