Detect ORM-layer correctness and performance anti-patterns in PR diffs.
npx skills add https://github.com/mattnowdev/super-review --skill orm-review-reference
Please help me install this Agent Skill. Skill: ORM review reference Source: https://github.com/mattnowdev/super-review/tree/main/skills/orm Command: npx skills add https://github.com/mattnowdev/super-review --skill orm-review-reference
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.
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.
High-intent search queries and answers about installing and using this skill.
To detect ORM N+1 queries during a PR review, analyze code diffs for conditional includes and relational loading anti-patterns. The review matches rule-specific detection signals to code evidence, enforcing safe replacements for performance regressions in Prisma, MikroORM, TypeORM, or Drizzle applications.
Preventing unsafe raw SQL injection involves flagging raw query execution patterns in PR diffs that bypass parameterization. This review process identifies unsafe raw SQL usage in Prisma and Drizzle, matching code evidence to enforce safe replacements and prevent insecure SQL vulnerabilities.
Checking ORM transaction boundaries requires flagging patterns that accidentally run outside a transaction, such as capturing the outer Prisma client or using Drizzle helpers closing over module-scoped db objects. The review identifies these code paths to enforce proper transactional correctness.
MikroORM memory leaks across requests often stem from identity-map lifecycle issues. Reviewing PR diffs for entity lifecycle and identity map anti-patterns catches these leaks early, ensuring request-scoped isolation and preventing silent memory accumulation in long-running applications.
This ORM review reference works with Prisma, TypeORM, MikroORM, and Drizzle. It detects framework-specific safety issues, including Prisma 6 breaking changes like Bytes to Uint8Array and TypeORM relational loading anti-patterns, by identifying ORM usage from package.json.
Stopping soft-delete filter bypasses requires flagging code paths where soft-delete filtering is accidentally skipped during relational loading. The review targets these ORM smells in PR diffs, providing concrete code evidence so reviewers can enforce safe query replacements.
KILWA73Analyze SQL and ORM queries for N+1 patterns and missing indexes.
mifunedevGenerate compact caveman-style PR review notes with severity tags and file:line citations.
Muath2000Audit database schemas, Drizzle ORM models, and persistence patterns.
dhruvinrsoniImplement data access layers with Repository pattern, transaction management, and N+1 prevention.
