Headless TypeScript ORM

Build type-safe SQL queries with zero dependencies. Drizzle ORM is lightweight, performant, and works everywhere.

\~7.4kb

Minified + gzipped

Zero

Dependencies

100%

Type-safe

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

                                const users = pgTable('users', {
                                id: serial('id').primaryKey(),
                                name: text('name').notNull(),
                                });

                                const db = drizzle(process.env.DATABASE_URL);
                                const result = await db.select().from(users);`}

Quick start

Get up and running with Drizzle ORM in minutes

Install Drizzle ORM and your database driver using your preferred package manager. ```bash npm theme={null} npm install drizzle-orm npm install -D drizzle-kit ``` ```bash yarn theme={null} yarn add drizzle-orm yarn add -D drizzle-kit ``` ```bash pnpm theme={null} pnpm add drizzle-orm pnpm add -D drizzle-kit ``` ```bash bun theme={null} bun add drizzle-orm bun add -D drizzle-kit ``` Create a schema file and define your database tables with full TypeScript support. ```typescript schema.ts theme={null} import { pgTable, serial, text, timestamp } from 'drizzle-orm/pg-core'; export const users = pgTable('users', { id: serial('id').primaryKey(), email: text('email').notNull().unique(), name: text('name').notNull(), createdAt: timestamp('created_at').defaultNow(), }); ``` Initialize your database connection and start querying with type-safe operations. ```typescript index.ts theme={null} import { drizzle } from 'drizzle-orm/node-postgres'; import { users } from './schema'; const db = drizzle(process.env.DATABASE_URL!); // Type-safe insert await db.insert(users).values({ email: 'user@example.com', name: 'John Doe', }); // Type-safe select const allUsers = await db.select().from(users); ``` Your queries are fully typed based on your schema definition. IDEs will provide autocomplete and type checking.

Explore by database

Drizzle ORM supports all major SQL databases with native drivers

Full support for PostgreSQL with native types, schemas, and advanced features. Complete MySQL and MariaDB support with all column types and constraints. Lightweight SQLite support for edge, mobile, and embedded databases.

Core features

Everything you need to build modern database applications

Write SQL queries with full TypeScript inference and compile-time validation. Define your database schema in TypeScript with intuitive builder syntax. Generate and run migrations automatically with Drizzle Kit. Define and query table relationships with type-safe join operations. Execute multiple queries atomically with full ACID guarantees. Optimize performance with reusable prepared statements.

Ecosystem tools

Powerful tools to enhance your development workflow

CLI companion for schema migrations, introspection, and database management. Visual database browser to explore and manipulate your data effortlessly. Generate realistic test data and seed your database for development. Integrate with Zod, Valibot, TypeBox, and ArkType for runtime validation.

Ready to get started?

Join thousands of developers building type-safe database applications with Drizzle ORM

Start Building