Required Packages

These packages are already included in the template. If you are starting from scratch or adding Supabase + Prisma to an existing project, install them with:

npm install @supabase/supabase-js @prisma/client @prisma/adapter-pg prisma dotenv tsx

Package	Version	Purpose
@supabase/supabase-js	^2.106.2	Supabase client for auth and realtime
@prisma/client	^7.8.0	Auto-generated type-safe database client
@prisma/adapter-pg	^7.8.0	PostgreSQL adapter with connection pooling support
prisma	^7.8.0	Prisma CLI — migrations, schema, codegen (devDependency)
dotenv	^17.4.2	Loads .env variables for scripts like the seed runner
tsx	latest	Runs TypeScript files directly (used by the seed script)

package.json Scripts

The template includes the following useful scripts in package.json:

"scripts": {
  "dev":   "next dev",
  "build": "prisma generate && next build",
  "start": "next start",
  "seed":  "tsx prisma/seed-all.ts"
}

Notice that build automatically runs prisma generate before building — this ensures the Prisma client is always up to date when deploying. You can also run the seed script with:

npm run seed