A favicon of TypeORM

TypeORM

Build database-driven applications with TypeScript or JavaScript. Supports multiple SQL databases and runs across NodeJS, browser, mobile, and desktop platforms.

Visit TypeORM
A screenshot of TypeORMVisit

TypeORM is an Object Relational Mapper (ORM) that runs in NodeJS, Browser, Cordova, PhoneGap, Ionic, React Native, NativeScript, Expo, and Electron platforms. It can be used with TypeScript and JavaScript (ES5, ES6, ES7, ES8+). Its goal is to always support the latest JavaScript features and provide additional capabilities for database-driven applications, from small projects to large-scale enterprise systems.

It supports both Active Record and Data Mapper patterns, offering flexibility in architectural choices. Key features include:

  • Broad database compatibility: Works seamlessly with MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, sql.js, and WebSQL.
  • First-class TypeScript support: Leverages decorators and types for a strongly-typed development experience.
  • Cross-platform execution: Functions consistently across various JavaScript environments.
  • Connection pooling: Provides built-in support for managing database connections efficiently.
  • Migrations & Schema Sync: Includes tools for managing database schema evolution.

TypeORM offers a robust way to interact with databases using object-oriented principles in modern JavaScript and TypeScript.

  • 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 database 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.
Share:
Featured tools:

Similar to TypeORM:

Minimalist, flexible web framework for Node.js.
Full-stack Web FrameworksJavaScript & TypeScript
Build fast web applications and APIs with this minimal, flexible Node.js framework. Offers robust features and a large middleware ecosystem for extensibility.
Next-gen ORM for simplified, type-safe database access.
JavaScript & TypeScriptORMs
Interact with databases using a type-safe ORM for Node.js/TypeScript. Features automated migrations, intuitive schema, connection pooling, and caching.
Type-safe ORM for Node.js, TypeScript & Browser.
JavaScript & TypeScriptORMs
Query SQL databases in Node/TS with strong typing. Features Active Record style, no code gen, powerful filters, and secure browser access via Express plugin.
Modern ORM for TypeScript & Node.js SQL databases.
JavaScript & TypeScriptORMs
Manage database interactions in Node.js/TypeScript apps. Supports transactions, relations, eager/lazy loading, and multiple SQL databases like Postgres & MySQL.
Flexible JavaScript ORM for Node.js database interactions.
JavaScript & TypeScriptORMs
Build Node.js applications with a flexible JavaScript ORM. Features promise/callback interfaces, transactions, eager loading, and relations for PostgreSQL, MySQL, SQLite3.
TypeScript ORM for Node.js: Data Mapper, UoW, SQL & NoSQL.
JavaScript & TypeScriptORMs
Build Node.js apps with a TypeScript ORM using Data Mapper and Unit of Work patterns. Supports SQL/NoSQL, offers schema tools, and automatic query batching.
A tiny, intuitive fetch wrapper for cleaner requests.
HTTP for JSJavaScript & TypeScript
Make fetch requests easily with an intuitive, tiny, immutable, and type-safe wrapper. Simplifies error handling, headers, and serialization.
Lightweight fetch wrapper with plugins and Axios-like API.
HTTP for JSJavaScript & TypeScript
Make HTTP requests using a lightweight fetch wrapper. Offers an Axios-like API, plugin support for caching, retries, throttling, and more. Works universally.
Tiny & elegant Fetch API wrapper for JS
HTTP for JSJavaScript & TypeScript
Make HTTP requests easily with this tiny, elegant client built on the Fetch API. Offers a simpler API, retries, timeouts, hooks, and improved JSON handling.

Command Menu