PRISMA SCHEMA

Data model you can read

The Prisma schema is intuitive and lets you declare your database tables in a human-readable way — making your data modeling experience a delight. You define your models by hand or introspect them from an existing database.

PRISMA CLIENT

Type-safe database client

Prisma Client is a query builder that’s tailored to your schema. We designed its API to be intuitive, both for SQL veterans and developers brand new to databases. The auto-completion helps you figure out your query without the need for documentation.

PRISMA MIGRATE

Hassle-free migrations

Prisma Migrate auto-generates SQL migrations from your Prisma schema. These migration files are fully customizable, giving you full control and ultimate flexibility — from local development to production environments.

PRISMA STUDIO

Visual database browser

Prisma Studio is the easiest way to explore and manipulate data in your Prisma projects. Understand your data by browsing across tables, filter, paginate, traverse relations and edit your data with safety.

Free

Data Modeling

Define your models with ease and make optional use of automatic database synchronization.

Associations

Define associations between models and let Sequelize handle the heavy lifting.

Soft deletion

Mark data as deleted instead of removing it once and for all from the database.

Open source and free

• Schemas and Models for your NoSQL database
• Validators, pre and post middleware hooks
• Reference documents in other collections using populate
• Subdocuments: nest schemas in other schemas

Open source and free

100% JavaScript

Building on top of Sails means your app is written entirely in JavaScript, the language you and your team are already using in the browser.

Any database

Sails bundles a powerful ORM, Waterline, which provides a simple data access layer that just works, no matter what database you're using.

Auto-generated REST APIs

Sails comes with blueprints that help jumpstart your app's backend without writing any code.

Front-end agnostic

Sails is compatible with any front-end: Angular, React, iOS, Android, Windows Phone, custom hardware, or something else entirely.

Easy WebSocket integration

Since Sails translates incoming socket messages for you, they're automatically compatible with every route in your Sails app.

Professional support

Sails offers commercial support to accelerate development and ensure best practices in your code.

Open source and free

• Supports both DataMapper and ActiveRecord (your choice).
• Entities and columns.
• Database-specific column types.
• Entity manager.
• Repositories and custom repositories.
• Clean object relational model.
• Associations (relations).
• Eager and lazy relations.
• Uni-directional, bi-directional and self-referenced relations.
• Supports multiple inheritance patterns.
• Cascades.
• Indices.
• Transactions.
• Migrations and automatic migrations generation.
• Connection pooling.
• Replication.
• Using multiple database instances.
• Working with multiple databases types.
• Cross-database and cross-schema queries.
• Elegant-syntax, flexible and powerful QueryBuilder.
• Left and inner joins.
• Proper pagination for queries using joins.
• Query caching.
• Streaming raw results.
• Logging.
• Listeners and subscribers (hooks).
• Supports closure table pattern.
• Schema declaration in models or separate configuration files.
• Supports MySQL / MariaDB / Postgres / CockroachDB / SQLite / Microsoft SQL Server / Oracle / SAP Hana / sql.js.
• Supports MongoDB NoSQL database.
• Works in NodeJS / Browser / Ionic / Cordova / React Native / NativeScript / Expo / Electron platforms.
• TypeScript and JavaScript support.
• ESM and CommonJS support.
• Produced code is performant, flexible, clean and maintainable.
• Follows all possible best practices.
• CLI.

Open source and free

With a concise, literate codebase, Bookshelf is simple to read, understand, and extend. It doesn't force you to use any specific validation scheme, and provides flexible, efficient relation/nested-relation loading and first-class transaction support.

It's a lean object-relational mapper, allowing you to drop down to the raw Knex interface whenever you need a custom query that doesn't quite fit with the stock conventions.

Open source and free

• Full type safety
• Smart automated migrations generation
• No ORM learning curve
• SQL-like syntax for table definitions and queries
• Best in class fully typed joins
• Fully typed partial and non-partial selects of any complexity
• Auto-inferring of TS types for DB models for selections and insertions separately
• Zod schema generation
• Zero dependencies

Open source and free

Type-safe SQL queries

Kysely let's you write type-safe SQL queries. This eliminates entire classes of errors and let's you sleep peacefully at night.

No magic, just SQL

Kysely is a light abstraction layer over SQL. This makes it easy to reason about performance, and reduces the amount of concepts you need to learn to be proficient with the library.

Great autocompletion

By exposing your database schema to the TypeScript compiler, you get autocompletion on table names, column names, aliases, etc.

Multi-dialect support

PostgreSQL, MySQL, or SQLite? We've got you covered. There's also a growing ecosystem of 3rd party dialects, including PlanetScale, D3, SurrealDB, and more.

Runs on every environment

Kysely runs on node.js, the browser, serverless and edge environments, even on Deno!

Extensible core

Kysely comes with a plugin system that lets you extend the core with your own functionality.

Open source and free

It provides a uniform API for accessing stuff from different kinds of databases and protocols. That means you write the same code to get and store things like users, whether they live in MySQL, MongoDB, neDB, or Postgres.

Waterline strives to inherit the best parts of ORMs like ActiveRecord, Hibernate, and Mongoose, but with a fresh perspective and emphasis on modularity, testability, and consistency across adapters.

Open source and free

• An easy declarative way of defining models and relationships between them
• Simple and fun way to fetch, insert, update and delete objects using the full power of SQL
• Powerful mechanisms for eager loading, inserting and upserting object graphs
• Easy to use transactions
• Official TypeScript (opens new window) support
• Optional JSON schema validation
• A way to store complex documents as single rows

Open source and free

Implicit Transactions

MikroORM allows handling transactions automatically. When you call em.flush(), all computed changes are wrapped inside a database transaction.

DRY Entities

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 both SQL and NoSQL

Supports MongoDB, MySQL, MariaDB, PostgreSQL and SQLite databases, and more can be supported via custom drivers right now.

Migrations

Keep your schema in sync with SchemaGenerator and Migrator. Supports both up and down migrations.

Seeder

With the Seeder and seeding factories, we can generate fake data of any volume/shape and seed the database with ease.

Automatic Batching

Thanks to the UnitOfWork, all queries it fires are automatically batched. Inserts, updates, deletes - you name it!

Events

Powerful event system allows to hook into not only the entity lifecycle. Want to alter how the UnitOfWork works? Try onFlush event!

QueryBuilder

Includes metadata-aware QueryBuilder with auto-joining support. Need more flexibility? We got you covered!

Filters

Define and control your common filters globally. Want to show only results relevant for a given tenant? Or maybe you want to automatically hide all soft-deleted entities?

Open source and free

Easy to Use

Typegoose was designed to easily use mongoose schema's & model's in typescript

Focus on What Matters

Typegoose lets you focus on your data, and typegoose will create the correct mappings to schema's and model's

Works

Typegoose is compatible with almost every mongoose option

Open source and free

It features both traditional node style callbacks as well as a promise interface for cleaner async flow control, a stream interface, full-featured query and schema builders, transaction support (with savepoints), connection pooling and standardized responses between different query clients and dialects.

Open source and free