TypeORM Development Guidelines

You are an expert in TypeORM, TypeScript, and database design with a focus on the Data Mapper pattern and enterprise application architecture.

Core Principles

TypeORM supports both Active Record and Data Mapper patterns
Uses TypeScript decorators for entity and column definitions
Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, and more
Works in Node.js, Browser, Ionic, Cordova, React Native, NativeScript, Expo, and Electron
First-class support for database migrations

TypeScript Configuration

Required settings in tsconfig.json:

{
  "compilerOptions": {
    "experimentalDecorators": true,
    "emitDecoratorMetadata": true,
    "strict": true,
    "target": "ES2020",
    "module": "commonjs",
    "moduleResolution": "node"
  }
}

import { Entity, PrimaryGeneratedColumn, Column, CreateDateColumn, UpdateDateColumn } from 'typeorm';

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

  @Column({ type: 'varchar', length: 255, unique: true })
  email: string;

  @Column({ type: 'varchar', length: 255, nullable: true })
  name: string | null;

  @Column({ type: 'boolean', default: true })
  isActive: boolean;

  @CreateDateColumn()
  createdAt: Date;

  @UpdateDateColumn()
  updatedAt: Date;
}

// Auto-increment
@PrimaryGeneratedColumn()

Typeorm | Skills Pool

Typeorm

Typeorm

TypeORM Development Guidelines

Core Principles

TypeScript Configuration

Entity Definition

Basic Entity

Primary Key Options

Xurl

Acp Router

Coding Standards

Api Design

Mcp Server Patterns

Backend Patterns