Typeorm patterns

Skill DIYA73/nestjs-skills/typeorm-patterns

8 Claude Code skills for NestJS backend development — module scaffolding, TypeORM, BullMQ queues, WebSocket gateways, JWT auth, Redis caching, Docker, and testing patterns.

Install

npx -y skills add DIYA73/nestjs-skills --skill typeorm-patterns

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

2 things to look at

no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.
0 stars0 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

What its author says it does

Copied from the file, not written here

TypeORM entity design, relations, migrations, and query patterns for NestJS + PostgreSQL.

SKILL.md

2.7 KB, 675 tokens by cl100k_base, as published. Nobody here has run it

typeorm-patterns

TypeORM entity design, relations, migrations, and query patterns for NestJS + PostgreSQL.

Trigger

Use this skill when asked to:

Create a TypeORM entity
Define relations (OneToMany, ManyToOne, ManyToMany)
Write a TypeORM query (find, findOne, QueryBuilder)
Create or run a migration

Rules

Always use @PrimaryGeneratedColumn('uuid') — never auto-increment int
Always add @CreateDateColumn() and @UpdateDateColumn()
Use ! (definite assignment) on all columns
Nullable columns: @Column({ nullable: true, type: 'varchar' }) + field!: string | null
Never use any in entities

Base Entity

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

export abstract class BaseEntity {
  @PrimaryGeneratedColumn('uuid')
  id!: string;

  @CreateDateColumn()
  createdAt!: Date;

  @UpdateDateColumn()
  updatedAt!: Date;
}

Entity Template

import { Entity, Column, ManyToOne, JoinColumn } from 'typeorm';
import { BaseEntity } from '../common/base.entity';
import { User } from '../users/user.entity';

export const PostStatus = {
  DRAFT: 'draft',
  PUBLISHED: 'published',
} as const;
export type PostStatus = typeof PostStatus[keyof typeof PostStatus];

@Entity('posts')
export class Post extends BaseEntity {
  @Column()
  title!: string;

  @Column({ type: 'text' })
  body!: string;

  @Column({ type: 'varchar', default: PostStatus.DRAFT })
  status!: PostStatus;

  @Column({ nullable: true, type: 'varchar' })
  slug!: string | null;

  @ManyToOne(() => User, (user) => user.posts, { onDelete: 'CASCADE' })
  @JoinColumn({ name: 'userId' })
  user!: User;

  @Column()
  userId!: string;
}

Relations

// OneToMany
@OneToMany(() => Post, (post) => post.user)
posts!: Post[];

// ManyToOne
@ManyToOne(() => User, (user) => user.posts, { onDelete: 'CASCADE' })
@JoinColumn({ name: 'userId' })
user!: User;

// ManyToMany
@ManyToMany(() => Tag, (tag) => tag.posts)
@JoinTable({ name: 'post_tags' })
tags!: Tag[];

Query Patterns

// Find with relations
await this.repo.findOne({ where: { id }, relations: { user: true } });

// QueryBuilder
const results = await this.repo
  .createQueryBuilder('post')
  .leftJoinAndSelect('post.user', 'user')
  .where('post.status = :status', { status: PostStatus.PUBLISHED })
  .orderBy('post.createdAt', 'DESC')
  .take(20)
  .getMany();

Indexes

@Entity('posts')
@Index(['userId', 'status'])
@Index(['slug'], { unique: true })
export class Post extends BaseEntity { }

What ships with it

Read from the repository

Just SKILL.md. No reference files, no scripts.