Database

Choose an ORM

Drizzle generates TypeScript schemas, a typed client, migration helpers, and drizzle.config.ts. It is the direct, SQL-oriented option.

Prisma generates prisma/schema.prisma, a Prisma client wrapper, and related types. It is the schema-first option.

Provider	Generated Drizzle driver	Best fit
Neon	`@neondatabase/serverless`	Serverless PostgreSQL on Neon
Supabase	`postgres`	Supabase PostgreSQL over a standard connection string
Local	`postgres`	Local or Docker-hosted PostgreSQL

The local and Supabase paths use drizzle-orm/postgres-js; Neon uses drizzle-orm/neon-http.

Set the generated variable in .env.local:

DATABASE_URL=postgresql://user:password@localhost:5432/mydb

For Drizzle:

pnpm db:push

For Prisma:

pnpm prisma generate
pnpm prisma db push

Run the corresponding generation or migration command whenever the schema changes.