typescript:drizzle-orm

What problem does it solve?

Drizzle ORM provides a type-safe way to define database schemas and write SQL-like queries in TypeScript without sacrificing runtime performance or type safety.

Core Features & Use Cases

• Type-safe schema definitions (pgTable/sqliteTable) and automatic type inference with $inferSelect and $inferInsert.
• Support for relations, joins, transactions, and migrations across PostgreSQL, SQLite, Cloudflare D1, and Durable Objects.
• Rich API coverage for inserts, updates, deletes, and complex queries with type-safe results.

Quick Start

Create a type-safe Drizzle ORM schema in TypeScript, define two tables, and run a basic query to fetch records.