drizzle-team/drizzle-orm
Drizzle Orm
Drizzle ORM is a headless TypeScript-native database toolkit designed to provide type-safe SQL query building and schema management. It functions as a lightweight mapper that allows developers to define database schemas using TypeScript classes and functions, ensuring full type safety and autocompletion for all database operations. By constructing SQL strings dynamically at runtime, it maintains a direct, SQL-centric approach to data interaction while leveraging the TypeScript type system to validate queries before execution.
The project distinguishes itself through a zero-dependency architecture that ensures compatibility across diverse serverless, edge, and mobile runtime environments. It provides a unified interface for various database engines by delegating execution to dialect-specific drivers, allowing for consistent data access across PostgreSQL, MySQL, SQLite, and other relational systems. Its relational query builder translates nested object-based queries into optimized SQL joins and subqueries, while the integrated migration engine automatically synchronizes database structures with application code.
Beyond core querying and schema definition, the toolkit includes comprehensive utilities for managing database lifecycles. This includes a command-line interface for generating and applying migrations, tools for deterministic mock data generation, and support for advanced database features like transactions, batch operations, and row-level security. The ecosystem also offers integrations with popular schema validation libraries to further enforce data integrity.
Features
- Object-Relational Mappers - Functions as a headless TypeScript ORM for database interaction.
- Database Query Builders - Enables fetching related data across tables using intuitive relational query syntax.
- Query Builders - Generates type-safe SQL queries at compile time to ensure correctness before execution.
- SQL Data Modeling - Defines database schemas using type-safe code that mirrors standard SQL syntax.
- Type-Safe Query Builders - Provides full TypeScript autocompletion and compile-time validation for database queries.
- Database Access Layers - Enables consistent database querying across server, edge, and mobile environments using a unified API.
- Database Migration Tools - Provides CLI tools to generate and manage database migrations.
- Table Definitions - Provides primitives for defining database tables and mapping them to application properties.
- Database Migrations - Automates schema synchronization between application code and database structures.
- Migration Tools - Automatically generates and applies database schema migrations based on code definitions.
- Polymorphic Data Modeling - Drizzle associates a single entity with multiple different types of tables by using a type identifier and a foreign key to maintain flexible data connections.
- Select Operations - Provides comprehensive support for retrieving and filtering data from database tables.
- SQL Query Builders - If you know SQL, you know Drizzle. Other ORMs and data frameworks tend to deviate/abstract you away from SQL, which leads to a double learning curve: needing to know both SQL and the framework’s API. Drizzle is the o
- Awesome List - A community-curated directory that catalogs and links out to other open-source projects, rather than a standalone tool you run yourself.
- Object Relational Mappers - TypeScript ORM for SQL databases.
- Search and Databases - Delivers a lightweight, type-safe TypeScript ORM.
- Database Introspection Tools - This guide assumes familiarity with: - Get started with Drizzle and drizzle-kit - read here - Drizzle schema fundamentals - read here - Database connection basics - read here - Drizzle migrations fundamentals - read he
- Database Seeding Tools - Enables deterministic generation of test data for database population.
- PostgreSQL Integrations - Provides native support for PostgreSQL-specific column types and features.
- Referential Integrity Constraints - Drizzle validates foreign key values using database-level constraints to prevent inconsistent data states and ensure that all related records remain properly linked within the system.
- Database Management Interfaces - Provides a visual interface for inspecting and managing database schemas and data.
- Database Schema Managers - A declarative toolset for defining, versioning, and synchronizing database structures across multiple environments and SQL dialects.
- Schema Synchronization Tools - This guide assumes familiarity with: - Get started with Drizzle and drizzle-kit - read here - Drizzle schema fundamentals - read here - Database connection basics - read here - Drizzle migrations fundamentals - read he
- Serverless Database Drivers - Optimizes database connectivity for lightweight, stateless serverless environments.
- Row-Level Security - Enables fine-grained access control policies directly on database tables.
- Database Drivers - Provides native support for connecting to SQLite databases via various drivers.
- Database Integrations - Provides native support for MySQL database connections.
- Delete Operations - Supports type-safe deletion of records from database tables.
- Insert Operations - Supports type-safe insertion of new records into database tables.
- Relationship Modeling - Enables definition of database relationships to ensure data integrity and logical linking.
- Schema Validation Libraries - Install the dependencies npm yarn pnpm bun ### Select schema Defines the shape of data queried from the database - can be used to valida
- SQLite Drivers - Drizzle has native support for SQLite connections with the libsql, node:sqlite and better-sqlite3 drivers. There are a few differences between the libsql and node:sqlite/better-sqlite3 drivers that we discove
- Update Operations - Supports type-safe modification of existing records in database tables.
- Validation Integrations - Integrates with schema validation libraries to enforce data structure consistency.
- Serverless Runtimes - The best part is no part. Drizzle has exactly 0 dependencies! Drizzle ORM is dialect-specific, slim, performant and serverless-ready by design. We’ve spent a lot of time to make sure you have best-in-class SQL di
