drizzle-orm

Drizzle ORM

Overview

Drizzle ORM is a lightweight, performant, TypeScript-first ORM with zero dependencies. It is headless (not a data framework), SQL-like at its core, and serverless-ready by design. Drizzle supports PostgreSQL, MySQL, SQLite, SingleStore, MSSQL, and CockroachDB.

Key principles:

• Headless ORM — a library, not a framework; build your project however you want
• SQL-like — if you know SQL, you know Drizzle; zero to no learning curve
• Relational Queries API — optional db.query API for nested relational data (outputs exactly 1 SQL query)
• Serverless-ready — 0 dependencies, dialect-specific, works with all major database drivers
• Full TypeScript — schema definitions, query results, and insert types are all inferred

Skill Files

File	Description
getting-started.md	Overview, philosophy, installation (PostgreSQL/MySQL/SQLite), schema definition, drizzle.config.ts, push & migrate workflow, CRUD basics
api.md	Full API reference: column types per dialect, SQL builder (select/insert/update/delete), joins, filter operators, relational queries (RQB), sql template tag, transactions, Drizzle Kit migrations, defineRelations
guides.md	Tutorials (platform integrations), zod/valibot schema generation, performance tips, deployment patterns

Quick Reference

Define a schema (PostgreSQL)

import { integer, pgTable, varchar, serial, timestamp } from "drizzle-orm/pg-core";

export const users = pgTable("users", {
  id: serial().primaryKey(),
  name: varchar({ length: 255 }).notNull(),
  email: varchar({ length: 255 }).notNull().unique(),
  createdAt: timestamp("created_at").defaultNow().notNull(),
});

Initialize the database

import { drizzle } from "drizzle-orm/node-postgres";
import * as schema from "./schema";

const db = drizzle(process.env.DATABASE_URL!, { schema });

CRUD

import { eq } from "drizzle-orm";

// Insert
await db.insert(users).values({ name: "John", email: "[email protected]" });

// Select
const allUsers = await db.select().from(users);
const user = await db.query.users.findFirst({ where: eq(users.email, "[email protected]") });

// Update
await db.update(users).set({ name: "Jane" }).where(eq(users.id, 1));

// Delete
await db.delete(users).where(eq(users.id, 1));