Drizzle ORM

Start with this

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

export const tools = pgTable('tools', {
  id: serial('id').primaryKey(),
  name: text('name').notNull(),
  price: text('price').notNull(),
});

const db = drizzle(process.env.DATABASE_URL!);

// fully typed, SQL-shaped queries
const free = await db.select().from(tools).where(eq(tools.price, 'free'));

The take, for AI builders

For AI builders, Drizzle's thin, SQL-shaped API is a gift: agents generate correct queries because the code reads like the SQL it becomes, and the types catch mistakes before they run. Reach for it when you want to understand your data layer rather than hand it to a black box. If you'd rather have more conventions and a visual studio, Prisma is the heavier, friendlier option.

When to reach for it

Alternatives

• Prisma ↗

  More conventions, a visual studio and a bigger ecosystem, at the cost of a heavier runtime.

• Supabase →

  If you want the database, auth and APIs together rather than just an ORM.