ORM review reference

What problem does it solve?

This Skill prevents common ORM mistakes that cause silent data corruption, insecure SQL, and performance regressions during PRs, especially across Prisma, MikroORM, TypeORM, and Drizzle.

Core Features & Use Cases

• Evidence-first anti-pattern detection: Targets specific ORM smells like N+1 from conditional includes, unsafe raw SQL, and soft-delete bypasses so reviewers can act on concrete issues.
• Transaction correctness guidance: Flags patterns that accidentally run outside a transaction, such as capturing the outer Prisma client or using Drizzle helpers that close over module-scoped db.
• Framework-specific ORM safety rules: Covers Prisma 6 breaking changes (Bytes → Uint8Array) and MikroORM identity-map lifecycle issues that can leak memory across requests.

Quick Start

Use the ORM review reference to check a PR that touches Prisma or MikroORM data access and request the reviewer to flag N+1, unsafe raw queries, and transaction boundary mistakes.