Drizzle ORM

TypeScript ORM for SQL databases with zero dependencies.

Why Drizzle?

• ✅ Full TypeScript support
• ✅ SQL-like syntax
• ✅ Lightweight (no dependencies)
• ✅ Edge-ready
• ✅ Multiple databases (PostgreSQL, MySQL, SQLite)
• ✅ Automatic migrations

Quick Start

npm install drizzle-orm
npm install -D drizzle-kit

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

// Define schema
export const users = pgTable('users', {
  id: serial('id').primaryKey(),
  name: text('name').notNull(),
  email: text('email').notNull(),
})

// Query
const db = drizzle(pool)
const allUsers = await db.select().from(users)

Core Features

• Schema - Type-safe table definitions
• Queries - SQL-like query builder
• Migrations - Automatic migration generation
• Relations - Join tables easily

Resources

• Official Docs
• GitHub