How does this skill handle database observability?

It implements a custom TypeOrmXRayLogger for distributed tracing, allowing developers to track query performance and table-level metrics within AWS X-Ray.

Why use TimestampedEntity instead of TypeORM's BaseEntity?

Using a custom abstract class avoids the Active Record pattern methods provided by TypeORM's BaseEntity, favoring the Data Mapper pattern for better testability and separation of concerns.

Does this skill support automatic database synchronization?

No, it explicitly enforces a migration-only workflow (synchronize: false) to ensure schema changes are safe, versioned, and reversible in production environments.

Does this support custom repositories in transactions?

Yes, it provides specific guidance on using the withRepository() method to ensure custom repositories use the correct transactional EntityManager.

NestJS TypeORM Patterns

Name: NestJS TypeORM Patterns
Author: CodySwannGT

byCodySwannGT

•

Gestión de Bases de Datos

Enforces standardized TypeORM implementation patterns for NestJS backends to ensure consistent database architecture and observability.

This skill provides a comprehensive framework for managing TypeORM within NestJS projects, focusing on production-grade standards for PostgreSQL and AWS Aurora. It automates the enforcement of critical patterns such as UUID primary keys, mandatory column comments, indexed foreign keys, and advanced configuration using asynchronous module loading. By integrating custom observability with AWS X-Ray and handling complex read-write replication, it ensures that database interactions remain efficient, traceable, and scalable across the entire development lifecycle.

Características Principales

011 GitHub stars

02Standardized Entity patterns using UUIDs and mandatory column comments

03Integrated observability via custom X-Ray logging for distributed tracing

04Enforced migration-only workflow to prevent accidental schema synchronization

05Production-ready read-write replication and AWS RDS IAM authentication support

06Advanced transaction management patterns for custom repositories

Casos de Uso

01Implementing high-availability PostgreSQL configurations with read replicas

02Standardizing database entity definitions across a large-scale NestJS backend

03Ensuring database schema changes are strictly managed through migration scripts

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add codyswanngt/lisa typeorm-patterns

For use in Claude.ai and ChatGPT