DB Reset Local

Reset and seed the local database for Drasil.

majiayu000 ac5052b 2 files · 1.5 KB Updated 567 repo stars

File contents

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:
    • 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.

majiayu000/claude-skill-registry-data/tree/main/data/db-reset-local commit ac5052b098

Frequently asked questions

npx skillmds add majiayu000/db-reset-local