ORMs and query builders

12-month change compares the average of the last 4 weeks of downloads with the first 4 weeks of the 52-week series. Gzip size is for the whole package, as measured by Bundlephobia. "-" means the value has not been fetched.

• objectionAn SQL-friendly ORM for Node.js
• sqliteSQLite client for Node.js applications with SQL-based migrations API written in Typescript
• mock-knexa knex mock adapter for simulating a db during testing
• dbmateA lightweight, framework-agnostic database migration tool
• prisma-kyselyGenerate Kysely database types from a Prisma schema
• @mikro-orm/sqliteTypeScript ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns. Supports MongoDB, MySQL, PostgreSQL and SQLite databases as well as usage with vanilla JavaScript.
• @mikro-orm/mariadbTypeScript ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns. Supports MongoDB, MySQL, PostgreSQL and SQLite databases as well as usage with vanilla JavaScript.
• kysely-postgres-jsKysely dialect for PostgreSQL using the Postgres.js client
• @mikro-orm/mssqlTypeScript ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns. Supports MongoDB, MySQL, PostgreSQL and SQLite databases as well as usage with vanilla JavaScript.
• db-migrateDatabase migration framework for node.js
• typeorm-transactionalA Transactional Method Decorator for typeorm that uses cls-hooked to handle and propagate transactions between different repositories and service methods. Inpired by Spring Trasnactional Annotation and Sequelize CLS
• typeorm-extensionA library to create/drop database, simple seeding data sets, ...
• @shopify/shopify-app-session-storage-prismaShopify App Session Storage for Prisma
• @mikro-orm/sqlTypeScript ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns. Supports MongoDB, MySQL, PostgreSQL and SQLite databases as well as usage with vanilla JavaScript.
• @mikro-orm/seederSeeder package for MikroORM.
• clickhouse-migrationsClickHouse Migrations
• generate-schemaEffortlessly convert your JSON Object to JSON Schema, Mongoose Schema, or a Generic template for quick documentation / upstart.
• @mikro-orm/decoratorsTypeScript ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns. Supports MongoDB, MySQL, PostgreSQL and SQLite databases as well as usage with vanilla JavaScript.
• @react-awesome-query-builder/uiUser-friendly query builder for React. Core React UI
• dynamodb-toolboxLightweight and type-safe query builder for DynamoDB and TypeScript.
• @prisma/nextjs-monorepo-workaround-pluginEnsures that your Prisma files are copied
• prettier-plugin-prismaPrettier plugin for Prisma files
• @react-awesome-query-builder/coreUser-friendly query builder for React. Core
• prisma-dbml-generatorPrisma DBML Generator
• @casl/prismaAllows to query accessible records using Prisma client based on CASL rules
• prisma-zod-generatorPrisma 2+ generator to emit Zod schemas from your Prisma schema
• knex-dynamic-connectionAdds support for dynamically returning connection config for knex queries
• @opentelemetry/instrumentation-typeormOpenTelemetry instrumentation for `typeorm` database data-mapper ORM
• @nestjs-cls/transactional-adapter-prismaA Prisma adapter for @nestjs-cls/transactional
• kysely-typeormKysely dialect for TypeORM
• @svar-ui/react-filterSVAR React Filter is an advanced query builder for React, with AND/OR logic, nested filter groups, and JSON output.
• gql-query-builderSimple GraphQL Query Builder
• @datastax/astra-db-tsData API TypeScript client
• sql-template-tagES2015 tagged template string for preparing SQL statements, works with `pg`, `mysql`, `sqlite` and `oracledb`
• mongoose-aggregate-paginate-v2A page based custom aggregate pagination library for Mongoose with customizable labels.
• nestjs-paginatePagination and filtering helper method for TypeORM repositories or query builders using Nest.js framework.
• sequelize-autoAutomatically generate bare sequelize models from your database.
• @quramy/prisma-fabbrica Prisma generator for model factories
• drizzle-zeroGenerate Zero schemas from Drizzle ORM schemas
• @directus/schemaUtility for extracting information about existing DB schema
• bookshelfA lightweight ORM for PostgreSQL, MySQL, and SQLite3
• @mikro-orm/entity-generatorTypeScript ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns. Supports MongoDB, MySQL, PostgreSQL and SQLite databases as well as usage with vanilla JavaScript.
• connect-session-sequelizeSession store for connect-session using sequelize
• @indexeddb-orm/idb-ormTypeScript ORM wrapper for indexeddb with Zod runtime validation, build on top of dexie.js
• @react-querybuilder/dndDrag-and-drop-enabled version of react-querybuilder (DnD-library-agnostic)
• workers-qbZero dependencies Query Builder for Cloudflare Workers
• drizzle-typeboxGenerate Typebox schemas from Drizzle ORM schemas
• adminjsAdmin panel for apps written in node.js
• mongoose-unique-validatormongoose-unique-validator is a plugin which adds pre-save validation for unique fields within a Mongoose schema.
• @sequelize/coreSequelize is a promise-based Node.js ORM tool for Postgres, MySQL, MariaDB, SQLite, Microsoft SQL Server, Amazon Redshift, Snowflake’s Data Cloud, Db2, Oracle, and IBM i. It features solid transaction support, relations, eager and lazy loading, read repli

• kysely vs @prisma/client
• drizzle-orm vs sequelize-typescript
• @prisma/client vs sequelize-typescript
• drizzle-orm vs typeorm
• kysely vs typeorm
• @prisma/client vs typeorm
• @prisma/client vs sequelize
• kysely vs sequelize-typescript
• drizzle-orm vs sequelize
• drizzle-orm vs @typegoose/typegoose
• @prisma/client vs knex
• kysely vs knex