Skip to content
Home / Migrations / Prisma → Drizzle ORM

Prisma → Drizzle ORM

medium

Drizzle is lighter, faster, SQL-first. No code generation step, better serverless cold starts.

Estimated: 4-8h · 5 steps
Progress0%
Step 1: Install Drizzle
npm install drizzle-orm postgres && npm install -D drizzle-kit
Step 2: Convert schema

Map Prisma schema.prisma models to Drizzle table definitions in TypeScript. Use drizzle-kit introspect to auto-generate from existing DB.

npx drizzle-kit introspect
Step 3: Replace queries

Prisma: prisma.user.findMany(). Drizzle: db.select().from(users). SQL-like syntax.

Step 4: Update migrations

Switch from prisma migrate to drizzle-kit push or drizzle-kit generate.

npx drizzle-kit generate && npx drizzle-kit migrate
Step 5: Remove Prisma
npm uninstall prisma @prisma/client && rm -rf prisma/
✓ All queries work, tests pass