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

typeorm/typeorm

36,540View on GitHub

TypeORM is an object-relational mapper for TypeScript and JavaScript that bridges the gap between object-oriented application code and relational database tables. It provides a comprehensive data persistence layer that allows developers to define database entities using class decorators or configuration objects, enabling seamless interaction with data through object-oriented patterns. The project distinguishes itself through a flexible architecture that supports both the data mapper and repository patterns, alongside a fluent query builder that translates high-level method calls into platform

sequelize/sequelize

30,349View on GitHub

Sequelize is an object-relational mapping library that provides a unified interface for managing relational data through code. By implementing the Active Record pattern, it maps database tables to application objects, allowing developers to perform standard create, read, update, and delete operations using high-level method calls. The library abstracts complex database interactions by translating these calls into optimized, engine-specific SQL statements, ensuring consistent behavior across different database systems. The project distinguishes itself through a comprehensive suite of tools for

mikro-orm/mikro-orm

9,085View on GitHub

Mikro-ORM is a TypeScript-based object-relational mapping system that provides a unified persistence layer for Node.js applications. It translates TypeScript entities into relational or document-based database schemas, supporting a variety of engines including PostgreSQL, MySQL, MariaDB, MS SQL Server, SQLite, and MongoDB. The project implements the data mapper pattern to decouple in-memory domain models from the database persistence layer. It utilizes a unit of work pattern to track entity changes in memory and commit them in a single coordinated database transaction. The library covers com

prisma/prisma

46,366View on GitHub

Prisma is a database toolkit that provides a unified access layer for interacting with relational and document databases. It centers on a declarative schema modeling approach, where developers define their data structures in a human-readable language. This schema serves as the single source of truth, from which the toolkit automatically generates type-safe database clients that provide compile-time validation and editor autocomplete for all data operations. The project distinguishes itself through a high-performance, Rust-based query engine that handles query planning and connection pooling o

drizzle-teamdrizzle-orm

Features