What are popular ORMs for Node.js?

• Prisma

  442 37,151 9.9 TypeScript

  Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB

  

I work at Prisma, and we built an ORM that works differently from the other traditional ORMs in the Node.js ecosystem. It's compatible with PostgreSQL, MySQL, SQL Server, Mongo DB, and Cockroach DB.

• @databases

  13 587 5.7 TypeScript

  TypeScript clients for databases that prevent SQL Injection

I was frustrated by the existing options so I built https://www.atdatabases.org as an open source ORM/database client. It uses tagged template literals to prevent SQL injection when you want to write raw SQL and has a simple type safe API for common operations.

• SurveyJS

  surveyjs.io sponsored

  Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App. With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.

  

• Sequelize

  89 29,045 9.8 TypeScript

  Feature-rich ORM for modern Node.js and TypeScript, it supports PostgreSQL (with JSON and JSONB support), MySQL, MariaDB, SQLite, MS SQL Server, Snowflake, Oracle DB (v6), DB2 and DB2 for IBM i.

  

Is Sequelize ORM the best? but it looks like Sequelize is not too popular... https://sequelize.org/

• redwood

  114 16,734 10.0 TypeScript

  The App Framework for Startups

  

We're also humbled that modern Node.js frameworks like RedwoodJS (created by GitHub founder Tom Preston-Werner), KeystoneJS, and other dev tools like Amplication and WASP are using Prisma as their ORM.

• KeystoneJS

  56 8,848 9.4 TypeScript

  The most powerful headless CMS for Node.js — built with GraphQL and React

  

We're also humbled that modern Node.js frameworks like RedwoodJS (created by GitHub founder Tom Preston-Werner), KeystoneJS, and other dev tools like Amplication and WASP are using Prisma as their ORM.

• amplication

  148 13,326 10.0 TypeScript

  🔥🔥🔥 Open-source backend development platform. Build production-ready services without wasting time on repetitive coding.

  

We're also humbled that modern Node.js frameworks like RedwoodJS (created by GitHub founder Tom Preston-Werner), KeystoneJS, and other dev tools like Amplication and WASP are using Prisma as their ORM.

• pgtyped

  34 2,800 8.7 TypeScript

  pgTyped - Typesafe SQL in TypeScript

Interesting! What's the name of the ORM? Is it [`pgTyped`](https://github.com/adelsz/pgtyped).

• InfluxDB

  www.influxdata.com sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• graphql-js

  26 19,916 7.4 TypeScript

  A reference implementation of GraphQL for JavaScript

  

GraphQL.js + Knex.js + knex-types (TypeScript generator for Knex)

• knex-types

  8 63 0.0 TypeScript

  Generate TypeScript definitions (types) from a PostgreSQL database schema.

  

GraphQL.js + Knex.js + knex-types (TypeScript generator for Knex)

• wasp

  192 11,627 9.7 TypeScript

  The fastest way to develop full-stack web apps with React & Node.js.

  

From what Wasp standpoint, we really liked that Prisma schema is a DSL (since Wasp is also a DSL!). And it is quite elegant one, writing a parser for it was much simpler than I initially expected I have to admit (https://github.com/wasp-lang/wasp/blob/main/waspc/src/Wasp/Psl/Parser/Model.hs).

Suggest a related project