Skip to content
JS
Package category

ORMs and query builders

Object-relational mappers, query builders and migration tools.

444 packages12 comparisons

Packages compared

444 packages
PackageWeekly downloads12-month change52 weeksGzipLast releaseModuleTypesCategories
@kickfinance/typeorm-transactional
A 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
7.2k---4 months ago
0.6.1
CommonJSBundledORMs and query builders, TypeScript tooling
document-cli
CLI and interactive Ink TUI for documents.js: every docx/pptx/odt/odp/ods/odg/odf/pdf/odm/odb/xlsx/csv/svg/markdown/rtf conversion, bridge, and editor as a scriptable command or a terminal app.
7.2k--today
5.12.50
ESM + CommonJSBundledPDF and documents, CLI tools and terminal utilities
@logtape/drizzle-orm
Drizzle ORM adapter for LogTape logging library
7.1k---3 days ago
2.3.7
ESM + CommonJSBundledLogging, ORMs and query builders
bookshelf-postgis
Bookshelf plugin for parsing & serializing PostGIS columns
7.1k+3191%-8 years ago
0.3.0
CommonJSNoneMaps and geolocation, ORMs and query builders
@remix-run/data-table-sqlite
SQLite database implementation for remix/data-table
7k---6 days ago
0.6.3
ESM onlyBundledORMs and query builders
@remix-run/data-table-postgres
PostgreSQL database implementation for remix/data-table
7k---6 days ago
0.5.3
ESM onlyBundledORMs and query builders
knex-schema-inspector
Utility for extracting information about existing DB schema
6.8k-24%-2 years ago
3.1.0
CommonJSBundledORMs and query builders
node-redshift
A simple collection of tools to help you get started with Amazon Redshift from node.js
6.8k+17%--
0.1.5
CommonJSNoneCloud SDKs, ORMs and query builders
@remix-run/data-table-mysql
MySQL database implementation for remix/data-table
6.8k---6 days ago
0.5.3
ESM onlyBundledORMs and query builders
@odata2ts/odata-query-builder
Allows for building type-safe OData queries with a fluent API
6.7k---3 days ago
0.19.4
CommonJSBundledORMs and query builders, TypeScript tooling
drizzle-arktype
Generate arktype schemas from Drizzle ORM schemas
6.7k+192%-1 year ago
0.1.3
ESM + CommonJSBundledORMs and query builders, TypeScript tooling
follicle
A class-based ES6 ODM for Mongo-like databases. Forked from camo.
6.6k+652%-4 years ago
3.1.0
ESM + CommonJSNoneORMs and query builders
@knorm/knorm
A JavaScript ORM written using ES6 classes
6.6k---2 years ago
3.0.1
CommonJSBundledORMs and query builders
doculi
CLI and interactive Ink TUI for documents.js: every docx/pptx/odt/odp/ods/odg/odf/pdf/odm/odb/xlsx/csv/svg/markdown/rtf conversion, bridge, and editor as a scriptable command or a terminal app.
6.5k--today
5.12.49
ESM + CommonJSBundledPDF and documents, CLI tools and terminal utilities
@factory-js/prisma-factory
🏭 The FactoryJS plugin for Prisma
6.5k---7 months ago
0.2.3
ESM + CommonJSBundledTesting, ORMs and query builders
bun-query-builder
A simple yet performant query builder for TypeScript. Built with Bun.
6.2k+1642%-7 days ago
0.2.70
ESM onlyBundledORMs and query builders, TypeScript tooling
drizzle-query-logger
A beautiful, enhanced logger for Drizzle ORM that transforms your SQL queries into visually appealing, color-coded output with syntax highlighting, icons, and detailed formatting.
6.2k+271%-8 months ago
1.1.2
ESM + CommonJSBundledLogging, ORMs and query builders
vitest-environment-prisma-postgres
Vitest environment for Prisma & PostgreSQL designed for fast integration tests: seed your database once with production-like data, then run each test in a transaction that is rolled back after execution. Tests remain isolated without expensive reseeding.
6.1k--3 months ago
2.0.0
ESM + CommonJSBundledTesting, ORMs and query builders
@inixiative/prisma-map
Extracts a complete model map (fields, relations, FK info) from a Prisma generated client — supports v6 (schema.prisma) and v7 (runtimeDataModel)
6k---24 days ago
0.2.0
ESM + CommonJSBundledORMs and query builders, TypeScript tooling
sqlocal
SQLocal makes it easy to run SQLite3 in the browser, backed by the origin private file system.
6k+40%-4 months ago
0.18.0
ESM onlyBundledBundler plugins and loaders, ORMs and query builders
@knaadh/nestjs-drizzle-postgres
A NestJS module for integrating Drizzle ORM with PostgresJS driver
5.9k---1 year ago
1.2.0
CommonJSBundledORMs and query builders
convex-ents
Relations, default values, unique fields, RLS for Convex
5.8k+835%-7 months ago
0.20.0
CommonJSBundledORMs and query builders
drizzle-prisma-generator
Generate Drizzle schema from Prisma schema
5.8k-4%-2 years ago
0.1.7
CommonJSBundledTypeScript tooling, ORMs and query builders
@onozaty/prisma-schema-fixer
Fix schema.prisma according to the rules
5.8k---5 months ago
1.2.2
ESM onlyBundledORMs and query builders
prisma-import
Compile all your schemas into one and replace all imports
5.7k+105%-2 years ago
1.0.5
-NoneORMs and query builders
redux-orm
Simple ORM to manage and query your state trees
5.7k+50%-6 years ago
0.16.2
ESM + CommonJSNoneORMs and query builders, State management
objection-visibility
Objectionjs plugin to whitelist/blacklist model properties
5.6k+246%-4 years ago
1.2.0
CommonJSBundledORMs and query builders, Parsers and serialisers
zenstack-trpc
Auto-generate type-safe tRPC routers from ZenStack V3 schemas
5.4k--4 months ago
0.2.5
ESM onlyBundledORMs and query builders, TypeScript tooling
squid
Provides SQL tagged template strings and a schema definition function.
5.4k+354%-5 years ago
0.5.2
CommonJSBundledSchema validation, ORMs and query builders
sails-postgresql
a PostgreSQL adapter for Waterline and Sails.js
5.4k+26%-4 years ago
5.0.1
CommonJSNoneORMs and query builders
prisma-types-export
Export prisma types to a local directory
5.4k+257%-2 years ago
1.0.0
CommonJSBundledORMs and query builders
typeorm-naming-strategy
Custom naming strategies for typeorm
5.4k+433%-2 months ago
3.0.0
CommonJSBundledORMs and query builders
mongoose-hidden
Hides certain model properties when invoking toJSON or toObject.
5.3k-54%-5 years ago
1.9.1
CommonJSNoneORMs and query builders
bookshelf-virtuals-plugin
A plugin for Bookshelf that allows getting or setting virtual properties on model instances.
5.2k-14%-6 years ago
1.0.0
CommonJSNoneORMs and query builders
sql-concat
It's just fancy string concatenation
5.2k+1044%-6 months ago
4.1.0
ESM onlyBundledORMs and query builders
@pinia-orm/normalizr
Normalizes JSON according to schema for Redux and Flux applications
5.1k---2 months ago
2.0.0
ESM + CommonJSBundledState management, ORMs and query builders
@stacksjs/query-builder
The Stacks Query Builder integration
5.1k---today
0.74.68
ESM onlyBundledORMs and query builders
sequelize-strict-attributes
Plugin that configures Sequelize to throw when accessing attributes omitted from a select.
5.1k+381%-3 years ago
1.0.2
ESM + CommonJSBundledORMs and query builders
mock-typeorm
Never hit the database again while testing
5.1k+438%-1 year ago
1.0.4
ESM + CommonJSBundledDev servers and API mocking, ORMs and query builders
pinia-orm
The Pinia plugin to enable Object-Relational Mapping access to the Pinia Store.
5k-21%-2 months ago
2.0.0
ESM + CommonJSBundledORMs and query builders, Vue
@stacksjs/database
The Stacks database integration.
5k---today
0.74.68
ESM onlyBundledORMs and query builders, TypeScript tooling
@stacksjs/orm
The Stacks ORM integration
5k---today
0.74.68
ESM onlyBundledORMs and query builders
ts-sql-query
Type-safe SQL query builder like QueryDSL or JOOQ in Java or Linq in .Net for TypeScript with MariaDB, MySql, Oracle, PostgreSql, Sqlite and SqlServer support.
4.9k-1%-3 months ago
1.68.0
-NoneORMs and query builders, TypeScript tooling
casbin-mongoose-adapter
Mongoose adapter for Casbin
4.8k+24%-8 months ago
5.6.1
ESM + CommonJSBundledORMs and query builders
@mikro-orm/migrations-mongodb
TypeScript 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.
4.8k---6 days ago
7.2.1
ESM onlyBundledORMs and query builders, TypeScript tooling
@pgpmjs/core
PGPM Package and Migration Tools
4.8k---today
7.32.2
ESM + CommonJSBundledORMs and query builders
prisma-class-generator
Prisma generator that emits TypeScript classes decorated for @nestjs/swagger, class-validator, and TypeGraphQL — DTO/entity classes generated straight from schema.prisma.
4.7k-2%-1 month ago
0.7.0
CommonJSBundledDocumentation tooling, TypeScript tooling
pqb
Postgres query builder
4.7k+98%-26 days ago
0.73.6
ESM + CommonJSBundledORMs and query builders
egg-sequelize
egg Sequelize plugin
4.6k-35%-6 years ago
6.0.0
-NoneORMs and query builders
@mikro-orm/pglite
TypeScript 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.
4.6k---6 days ago
7.2.1
ESM onlyBundledTypeScript tooling, 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.

  • @kickfinance/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
  • document-cliCLI and interactive Ink TUI for documents.js: every docx/pptx/odt/odp/ods/odg/odf/pdf/odm/odb/xlsx/csv/svg/markdown/rtf conversion, bridge, and editor as a scriptable command or a terminal app.
  • @logtape/drizzle-ormDrizzle ORM adapter for LogTape logging library
  • bookshelf-postgisBookshelf plugin for parsing & serializing PostGIS columns
  • @remix-run/data-table-sqliteSQLite database implementation for remix/data-table
  • @remix-run/data-table-postgresPostgreSQL database implementation for remix/data-table
  • knex-schema-inspectorUtility for extracting information about existing DB schema
  • node-redshiftA simple collection of tools to help you get started with Amazon Redshift from node.js
  • @remix-run/data-table-mysqlMySQL database implementation for remix/data-table
  • @odata2ts/odata-query-builderAllows for building type-safe OData queries with a fluent API
  • drizzle-arktypeGenerate arktype schemas from Drizzle ORM schemas
  • follicleA class-based ES6 ODM for Mongo-like databases. Forked from camo.
  • @knorm/knormA JavaScript ORM written using ES6 classes
  • doculiCLI and interactive Ink TUI for documents.js: every docx/pptx/odt/odp/ods/odg/odf/pdf/odm/odb/xlsx/csv/svg/markdown/rtf conversion, bridge, and editor as a scriptable command or a terminal app.
  • @factory-js/prisma-factory🏭 The FactoryJS plugin for Prisma
  • bun-query-builderA simple yet performant query builder for TypeScript. Built with Bun.
  • drizzle-query-loggerA beautiful, enhanced logger for Drizzle ORM that transforms your SQL queries into visually appealing, color-coded output with syntax highlighting, icons, and detailed formatting.
  • vitest-environment-prisma-postgresVitest environment for Prisma & PostgreSQL designed for fast integration tests: seed your database once with production-like data, then run each test in a transaction that is rolled back after execution. Tests remain isolated without expensive reseeding.
  • @inixiative/prisma-mapExtracts a complete model map (fields, relations, FK info) from a Prisma generated client — supports v6 (schema.prisma) and v7 (runtimeDataModel)
  • sqlocalSQLocal makes it easy to run SQLite3 in the browser, backed by the origin private file system.
  • @knaadh/nestjs-drizzle-postgresA NestJS module for integrating Drizzle ORM with PostgresJS driver
  • convex-entsRelations, default values, unique fields, RLS for Convex
  • drizzle-prisma-generatorGenerate Drizzle schema from Prisma schema
  • @onozaty/prisma-schema-fixerFix schema.prisma according to the rules
  • prisma-importCompile all your schemas into one and replace all imports
  • redux-ormSimple ORM to manage and query your state trees
  • objection-visibilityObjectionjs plugin to whitelist/blacklist model properties
  • zenstack-trpcAuto-generate type-safe tRPC routers from ZenStack V3 schemas
  • squidProvides SQL tagged template strings and a schema definition function.
  • sails-postgresqla PostgreSQL adapter for Waterline and Sails.js
  • prisma-types-exportExport prisma types to a local directory
  • typeorm-naming-strategyCustom naming strategies for typeorm
  • mongoose-hiddenHides certain model properties when invoking toJSON or toObject.
  • bookshelf-virtuals-pluginA plugin for Bookshelf that allows getting or setting virtual properties on model instances.
  • sql-concatIt's just fancy string concatenation
  • @pinia-orm/normalizrNormalizes JSON according to schema for Redux and Flux applications
  • @stacksjs/query-builderThe Stacks Query Builder integration
  • sequelize-strict-attributesPlugin that configures Sequelize to throw when accessing attributes omitted from a select.
  • mock-typeormNever hit the database again while testing
  • pinia-ormThe Pinia plugin to enable Object-Relational Mapping access to the Pinia Store.
  • @stacksjs/databaseThe Stacks database integration.
  • @stacksjs/ormThe Stacks ORM integration
  • ts-sql-queryType-safe SQL query builder like QueryDSL or JOOQ in Java or Linq in .Net for TypeScript with MariaDB, MySql, Oracle, PostgreSql, Sqlite and SqlServer support.
  • casbin-mongoose-adapterMongoose adapter for Casbin
  • @mikro-orm/migrations-mongodbTypeScript 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.
  • @pgpmjs/corePGPM Package and Migration Tools
  • prisma-class-generatorPrisma generator that emits TypeScript classes decorated for @nestjs/swagger, class-validator, and TypeGraphQL — DTO/entity classes generated straight from schema.prisma.
  • pqbPostgres query builder
  • egg-sequelizeegg Sequelize plugin
  • @mikro-orm/pgliteTypeScript 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.