Skip to content
AppClap
TypeORM is unclaimed —
T

TypeORM

Code with Confidence. Query with Power.·typeorm.io

Visit

TypeORM is an ORM (Object-Relational Mapper) that can run in Node.js, browsers, Cordova, Ionic, React Native, NativeScript, Expo, and Electron platforms, and can be used with TypeScript or JavaScript. It supports both DataMapper and ActiveRecord design patterns, provides a QueryBuilder for building complex queries, and offers first-class support for database migrations and schema generation. It works with multiple databases including MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, MongoDB, CockroachDB, Google Spanner, and SAP HANA.

What it's for

defining database entities with TypeScript decoratorsbuilding complex queries with joins, pagination, and cachingrunning database migrations with automatic generationusing Active Record or Data Mapper patterns for database interactionworking with multiple databases and data sources in one applicationstoring tree structures using Adjacency list and Closure table patternswriting parameterized SQL queries via a SQL tag helper

Features 15

  • Cross-platform support (Node.js, browsers, mobile, desktop)
  • Database migrations with automatic generation
  • DataMapper and ActiveRecord pattern support
  • Embedded entities to reduce duplication via composition
  • Entity decorators for defining database models
  • Entity inheritance (Concrete Table Inheritance)
  • Multi-database support (MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, MongoDB, CockroachDB, Google Spanner, SAP HANA)
  • Multiple data sources, databases, schemas, and replication setup
  • QueryBuilder for complex queries with joins, pagination, and caching
  • SQL tag for template-literal SQL queries with automatic parameter handling
  • Support for null/undefined handling in WHERE conditions
  • Tree entities using Adjacency list and Closure table patterns
  • TypeScript-first design with full type safety
  • View entities
  • Works with JavaScript in addition to TypeScript

At a glance

API
TypeLibrary / SDK
PlatformsWeb
Fordevelopers

Integrations

MySQLMariaDBAmazon Aurora MySQLPostgreSQLCockroachDBAmazon Aurora PostgresSQLiteMicrosoft SQL ServerOracleMongoDBSAP HANAGoogle Spanner

Resources

Last checked 5 days ago·