TypeORM - Code with Confidence. Query with Power.

Flexible Patterns

Supports both DataMapper and ActiveRecord patterns, giving you the flexibility to choose what works best for your project.

TypeScript First

Built from the ground up with TypeScript support, providing complete type safety for your database models.

Multi-Database Support

Works with MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, MongoDB, and more.

Powerful QueryBuilder

Elegant syntax for building complex queries with joins, pagination, and caching.

Migrations & Schema

First-class support for database migrations with automatic generation.

Cross-Platform

Works in Node.js, browsers, mobile, and desktop applications.

Elegant, Type-Safe API

TypeORM provides a beautiful, simple API for interacting with your database that takes full advantage of TypeScript's type system. Choose between DataMapper and ActiveRecord patterns - both are fully supported.

Entity Definition

Data Mapper

Active Record

import { Entity, PrimaryGeneratedColumn, Column } from "typeorm"

@Entity()
export class User {
    @PrimaryGeneratedColumn()
    id: number

    @Column()
    firstName: string

    @Column()
    lastName: string

    @Column()
    age: number
}