drizzle
Installation
SKILL.md
Drizzle ORM
Drizzle ORM is a lightweight, type-safe TypeScript ORM that mirrors SQL syntax directly, featuring zero runtime overhead, instant cold starts, and seamless edge-runtime support.
When to Use
- TypeScript-First Object Relational Mapping: Lightweight, SQL-like ORM with zero code-generation overhead and maximum type safety.
- Serverless & Edge Runtimes: Next.js, Cloudflare Workers, Bun, Supabase, and AWS Lambda with zero cold-start penalty.
- Relational Databases with Precise Control: PostgreSQL, MySQL, and SQLite requiring explicit query execution and predictable SQL output.
- Schema-as-Code & Declarative Migrations: Managing migrations cleanly with
drizzle-kit.
Quick Start
// schema.ts
import { pgTable, serial, text, timestamp } from "drizzle-orm/pg-core";