Review TypeORM code to eliminate raw SQL and enforce repository patterns.
npx skills add https://github.com/lety-ai/lety-skill-hub --skill typeorm-lety-ai
Please help me install this Agent Skill. Skill: typeorm Source: https://github.com/lety-ai/lety-skill-hub/tree/main/plugins/typeorm/skills/typeorm Command: npx skills add https://github.com/lety-ai/lety-skill-hub --skill typeorm-lety-ai
Prevents unsafe or non-idiomatic database access in NestJS applications using TypeORM 0.3.x DataSource by eliminating raw SQL, insecure string-based queries, incorrect relation loading, and improper migration or transaction usage. It reduces runtime bugs, security vulnerabilities (SQL injection), and schema drift caused by ad-hoc DDL changes.
Use the typeorm skill to review the repository for raw SQL and anti-patterns then produce corrected TypeORM 0.3.x code and migration instructions citing the official docs.
High-intent search queries and answers about installing and using this skill.
To eliminate raw SQL in NestJS TypeORM, replace repository.query calls with repository-based CRUD operations and parameterized QueryBuilder conditions, ensuring secure and idiomatic database access without string-based queries.
The best way to load relations with TypeORM QueryBuilder is using join-and-select patterns or TypeORM relation options, avoiding manual joins to ensure proper entity mapping and safe relation loading in NestJS.
Generate TypeORM migrations via the CLI in NestJS by using the migration generation and run workflows, preventing schema drift caused by ad-hoc DDL changes and ensuring consistent database version control.
TypeORM 0.3.x DataSource supports safe transaction patterns by using data-source transactions for multi-step updates, preventing partial writes and ensuring data integrity during complex repository operations.
You should use QueryBuilder instead of raw SQL in TypeORM to prevent SQL injection vulnerabilities, reduce runtime bugs from string-based queries, and enforce parameterized conditions for secure database access.
You can convert a legacy raw SQL service into a TypeORM repository implementation with parameterized QueryBuilder queries, proper relation loading, and CLI-generated migrations following TypeORM 0.3.x patterns.
0r0looGuide TypeORM implementation for database management in NestJS applications.
junaid-ali-rukDiagnose and optimize Prisma ORM schemas, migrations, and queries.
KubrickCodeGenerate NestJS module structures with services, controllers, and DTOs.
ntaksh42Generate SQL and TypeORM database migration scripts with rollback support.
