Identify ORM inefficiencies and risks with structured findings.
npx skills add https://github.com/nesnilnehc/ai-cortex --skill review-orm-usage
Please help me install this Agent Skill. Skill: review-orm-usage Source: https://github.com/nesnilnehc/ai-cortex/tree/main/skills/review-orm-usage Command: npx skills add https://github.com/nesnilnehc/ai-cortex --skill review-orm-usage
This skill helps teams systematically review ORM usage patterns across a codebase to identify N+1 query risks, poor connection handling, unsafe migrations, and inefficient data access, and to produce a standardized findings list.
Feed your code scope (files or diffs containing ORM code) to this skill to generate a findings list.
High-intent search queries and answers about installing and using this skill.
To find N+1 queries and ORM inefficiencies, audit your code scope to identify poor connection handling, unsafe migrations, and inefficient data access patterns. This process generates a standardized findings list detailing specific file locations, severity, and actionable suggestions for resolution.
An ORM code review systematically examines database interactions across modules to check transaction safety and query design. It identifies risky patterns like unsafe migrations and poor connection management, producing structured reports with categories, descriptions, and corrective actions.
Yes, you can run an ORM migration audit on a specific pull request diff by feeding the code scope to the review process. It evaluates the provided files for transaction risks, N+1 queries, and model design flaws to output targeted findings.
Yes, this ORM review approach works across multiple database frameworks and libraries by analyzing the provided code scope. It applies to library-level reviews and PR checks, identifying inefficient data access patterns regardless of the specific ORM implementation.
The best way to audit database connection management and model design is to review the ORM usage patterns across your entire library scope. This generates a comprehensive findings list covering connection handling, query efficiency, and model architecture with actionable suggestions.
SpillwaveSolutionsCollect GitHub PR data and generate structured review files with two-stage approval.
mehdicGenerate comprehensive test coverage reports for Python, JavaScript, Go & Java projects.
aniruddh2003Run static analysis tools to detect security vulnerabilities, type errors, and linting issues.
herdiansahAnalyze PostgreSQL execution plans and optimize SQL query performance.
