Drizzle ORM

Lightweight, type-safe TypeScript ORM with SQL-like and relational query APIs. Zero dependencies, serverless-ready.

Reference versions: drizzle-orm 0.45.1, drizzle-kit 0.31.10 (stable, March 2026). v1.0.0 is in beta (1.0.0-beta.19). Relations v2 (defineRelations) landed in 0.38.x. If working with an older codebase, check which API is in use. Run npm ls drizzle-orm to verify the project's version before applying patterns from this skill.

When to Use

• Defining database schemas with pgTable, mysqlTable, sqliteTable
• Writing select/insert/update/delete queries
• Setting up relational queries with db.query
• Configuring drizzle-kit for migrations
• Debugging type errors or query issues in Drizzle code

Not for: General SQL questions unrelated to Drizzle, other ORMs (Prisma, TypeORM, Sequelize).

Connection Setup