TypeScript ORM

Open-source TypeScript projects categorized as ORM

Top 23 TypeScript ORM Projects

  • TypeORM

    ORM for TypeScript and JavaScript (ES7, ES6, ES5). Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.

    Project mention: PHP vs JS en backend, ¿Qué me recomiendas? | reddit.com/r/programacion | 2023-02-07
  • Prisma

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

    Project mention: Low-code solutions for Indie Hacking in 2023? | dev.to | 2023-02-07

    2. Prisma

  • Appwrite

    Appwrite - The Open Source Firebase alternative introduces iOS support . Appwrite is an open source backend server that helps you build native iOS applications much faster with realtime APIs for authentication, databases, files storage, cloud functions and much more!

  • MikroORM

    TypeScript ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns. Supports MongoDB, MySQL, MariaDB, PostgreSQL and SQLite databases.

    Project mention: Announcing a new TypeScript ORM | reddit.com/r/typescript | 2023-02-04

    I recommend looking at https://mikro-orm.io/

  • sequelize-auto

    Automatically generate bare sequelize models from your database.

  • sequelize-typescript

    Decorators and some other features for sequelize

  • marshal.ts

    A new full-featured and high-performance TypeScript framework for enterprise applications.

    Project mention: Hegel – An advanced static type checker for JavaScript | news.ycombinator.com | 2022-10-11

    https://deepkit.io/ may be of interest to you! It deeply patches the TS type compiler to make all types visible at runtime, enabling a lot of annotation-style workflows and dependency injection possible completely within the type annotation system: https://docs.deepkit.io/english/runtime-types.html

    Previous discussion: https://news.ycombinator.com/item?id=31663298 - it's downright mindblowing that all this seems to be the work of primarily a single developer.

    For a less intrusive solution, https://github.com/jquense/yup is a great library to reach for whenever you're defining the shape of a network-transmitted object and don't want to introduce compilation stages.

  • vuex-orm

    The Vuex plugin to enable Object-Relational Mapping access to the Vuex Store.

    Project mention: On-demand reactivity - Building live reports | reddit.com/r/vuejs | 2022-10-07

    You're absolutely right. I should have mentionned that the app uses Vuex-ORM to handle and query the data. The actual building of the reports contains various calculations and is done off the main thread. The reports are then saved as a model in vuex-orm, this basicaly acts as a cache. The thing is I don't know when to invalidate the cache or not so everything is invalidated when a new data event is added. There's nothing reactive about it.

  • Sonar

    Write Clean JavaScript Code. Always.. Sonar helps you commit clean code every time. With over 300 unique rules to find JavaScript bugs, code smells & vulnerabilities, Sonar finds the issues while you focus on the work.

  • denodb

    MySQL, SQLite, MariaDB, PostgreSQL and MongoDB ORM for Deno

    Project mention: MariaDB API Recomendations | reddit.com/r/Deno | 2022-09-29

    denoDB? https://github.com/eveningkid/denodb

  • foal

    Full-featured Node.js framework, with no complexity. 🚀 Simple and easy to use, TypeScript-based and well-documented.

    Project mention: FoalTS 3.0 released – TypeScript app framework | news.ycombinator.com | 2022-11-02
  • remult

    A CRUD framework for full stack TypeScript

    Project mention: Building a Full-stack Application with TypeScript and React Using Remult | dev.to | 2022-11-01

    Now that you’ve learned about Remult, how would you use it in your next project? To learn more about Remult, check out the official documentation.

  • layr

    Dramatically simplify full‑stack development

    Project mention: Layr v2 Is Out, but You May Never Use It | dev.to | 2023-01-12

    Finally, after two years of hard work, Layr v2 is out.

  • zapatos

    Zero-abstraction Postgres for TypeScript: a non-ORM database library

    Project mention: Announcing a new TypeScript ORM | reddit.com/r/typescript | 2023-02-04

    Requiring the user to define model classes for the "ORM" is a massive pain in large codebases and requiring the user to maintain these is just too much boilerplate. Seems extremely bloated compared to the simplicity of how the shortcuts are implemented in Zapatos or similar libraries where 90% of the code is compiled away for production.

  • lucid

    AdonisJS SQL ORM. Supports PostgreSQL, MySQL, MSSQL, Redshift, SQLite and many more (by adonisjs)

    Project mention: Moving MyUnisoft Node.js back to TypeORM | dev.to | 2022-08-02

    When I started this project I was inspired by Lucid which is the ORM of the Adonis.js framework.

  • Iridium

    A high performance MongoDB ORM for Node.js

  • data

    Data modeling and relation library for testing JavaScript applications. (by mswjs)

    Project mention: Mock Service Worker is awesome | dev.to | 2022-08-24

    It supports both REST and GraphQL APIs, it can delay the response of mocked API endpoints so the endpoint feels more real-life, it has it's own in-memory database with @msw/data package for more complex querying (e.g, searching, sorting), it can also run mocks in NodeJS environment instead of Service Worker (really useful for testing). Next, let's take a look at which problems msw can solve and how.

  • pure-orm

    A pure ORM for writing native SQL queries yielding pure business objects

    Project mention: An ORM which only does object relational mapping | reddit.com/r/Database | 2022-05-09
  • typedorm

    Strongly typed ORM for DynamoDB - Built with the single-table-design pattern in mind.

    Project mention: Learning About Dynamo | dev.to | 2022-03-12

    To that end, you'll say. "Well what do you do then?" And from my reading, it appears we end up back at Object Oriented Programming 🎉. [DynamoDb Toolbox] seems like a moderately popular library for accomplishing this in node. I've also talked with a friend who makes heavy use of it and he had no complaints. A newer player in the space is TypeDORM taking heavy inspiration from TypeORM and using DynamoDb Toolbox under the hood. Personally I've yet to use this tool but it's for sure on my short list to try out.

  • aurora

    CLI tool that orchestrates prisma files in a way that allows multiple .prisma files with cross-relations (by sabinadams)

    Project mention: What is Prisma bad at? | reddit.com/r/node | 2022-08-21
  • safe-typeorm

    TypeORM helper library enhancing safety in the compilation level

    Project mention: [Safe-TypeORM] AnyORM becomes the real TypeORM | dev.to | 2023-02-07
  • pinia-orm

    The Pinia plugin to enable Object-Relational Mapping access to the Pinia Store.

    Project mention: Any advise when starting jumping in Vuex | reddit.com/r/vuejs | 2022-12-07

    If you use a standard Pinia store, you can use plug-ins. For example, you can use pinia-plugin-persistedstate to let the user start each new session where they left off. Or you can use pinia-orm to simplify handling large amounts of tabular data.

  • drizzle-orm

    TypeScript ORM for SQL

    Project mention: Anyone using Drizzle ORM? | reddit.com/r/node | 2023-02-01

    I stumbled across it today, and it looks really promising to me. Anyone have any experience with it? Here is the GitHub page: https://github.com/drizzle-team/drizzle-orm

  • strapi-connector-firestore

    Strapi database connector for Firestore database on Google Cloud Platform.

  • joist-ts

    a TypeScript ORM for Postgres

    Project mention: Joist: An idiomatic ORM library for TypeScript | news.ycombinator.com | 2023-01-20
  • InfluxDB

    Build time-series-based applications quickly and at scale.. InfluxDB is the Time Series Platform where developers build real-time applications for analytics, IoT and cloud-native services. Easy to start, it is available in the cloud or on-premises.

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020). The latest post mention was on 2023-02-07.

TypeScript ORM related posts


What are some of the best open-source ORM projects in TypeScript? This list will help you:

Project Stars
1 TypeORM 30,280
2 Prisma 28,877
3 MikroORM 5,547
4 sequelize-auto 2,731
5 sequelize-typescript 2,518
6 marshal.ts 2,475
7 vuex-orm 2,374
8 denodb 1,860
9 foal 1,720
10 remult 1,707
11 layr 1,214
12 zapatos 921
13 lucid 863
14 Iridium 569
15 data 532
16 pure-orm 353
17 typedorm 289
18 aurora 199
19 safe-typeorm 191
20 pinia-orm 181
21 drizzle-orm 174
22 strapi-connector-firestore 153
23 joist-ts 130
Build time-series-based applications quickly and at scale.
InfluxDB is the Time Series Platform where developers build real-time applications for analytics, IoT and cloud-native services. Easy to start, it is available in the cloud or on-premises.