What Is Drizzle ORM? The Lightweight Type-Safe ORM

Drizzle ORM is a lightweight,TypeScript-first ORM that stays close to SQL. Unlike Prisma, Drizzle doesn't auto-generate a client — you define your schema in TypeScript, write queries that look like SQL, and get full type inference.

How Drizzle Works

import { pgTable, text, timestamp } from 'drizzle-orm/pg-core'
import { drizzle } from 'drizzle-orm/node-postgres'
import { eq } from 'drizzle-orm'

export const deployments = pgTable('deployments', {
  id: text('id').primaryKey(),
  appName: text('app_name').notNull().unique(),
  createdAt: timestamp('created_at').defaultNow(),
})

const db = drizzle(pool)
const result = await db.select().from(deployments).where(eq(deployments.appName, 'my-app'))

Drizzle vs Prisma

Drizzle is more explicit and SQL-like. Prisma is more abstracted and GUI-friendly. Drizzle is lighter (less runtime overhead) and easier to debug. Prisma has better tooling (Studio) and a larger community.

EZClaw Uses Drizzle

EZClaw's database layer uses Drizzle ORM with Neon PostgreSQL. See lib/db/schema.ts and lib/db/index.ts for how it's wired up.