Open Source TypeScript Object-Relational Mapping (ORM) Software

Prisma helps app developers build faster and make fewer errors with an open source ORM for PostgreSQL, MySQL and SQLite. Central to Prisma is the schema, a declarative way to define your app's data models and their relations that's human-readable. And you don't have to painstakingly create it from scratch if you already have a database - prisma introspect takes care of that. Prisma Client is a query builder that composes the way you think and gets auto-generated from the Prisma schema with types tailored to your app. We designed the API to be intuitive for both SQL veterans and people brand new to databases. Auto-completion, linting, formatting and more help Prisma developers in VSCode stay confident without distractions. Prisma Client puts extra emphasis on extensive type safety for more productive development in TypeScript. Prisma is a server-side library that helps your app read and write data to the database in an intuitive and safe way.

Drizzle ORM is a lightweight, TypeScript-first Object-Relational Mapping (ORM) tool designed for modern JavaScript runtimes. It supports environments like Node.js, Bun, Deno, and even edge runtimes, providing developers with a flexible and type-safe way to interact with databases. Drizzle ORM emphasizes performance and developer experience.

TypeScript ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns. MikroORM allows handling transactions automatically. When you call em.flush(), all computed changes are wrapped inside a database transaction. Uses source code analysis so you do not have to repeat yourself when defining entities. Simply define correct TypeScript types and you are good to go! Supports MongoDB, MySQL, MariaDB, PostgreSQL and SQLite databases, and more can be supported via custom drivers right now. Keep your schema in sync with SchemaGenerator and Migrator. Supports both up and down migrations. With the Seeder and seeding factories, we can generate fake data of any volume/shape and seed the database with ease. Thanks to the UnitOfWork, all queries it fires are automatically batched. Inserts, updates, deletes - you name it! Powerful event system allows to hook into not only the entity lifecycle. Want to alter how the UnitOfWork works? Try onFlush event!