N+1 Detector

Scans pull requests for database or network calls executed inside loops or iterations, queries in `for` blocks, `await` inside `.map`, lookups per item, or resolvers that fetch per element. Reports each finding with the loop bound, an estimated call count at realistic data volumes, and a specific rewrite such as batch fetch, join, or `Promise.all` where concurrency is safe.

Identifier

n-plus-one-detector

Version

1.0.0

Steps

4

Triggers

1

• performance
• database
• n-plus-one
• review
• automated

When it runs

The pipeline

The graph below is the one the workflow opens with in the builder, same steps, same layout, drawn on the same canvas. The run playing through it is a simulation; the branches and conditions are real.

1. 01
   PR Openedtrigger

   The event that starts the run.

2. 02
   Clone Repositorygit.clone

   Shallow-clones the repository at the right ref.

3. 03
   Detect N+1 Patternsagent.run

   One agent works the task with its toolkit.

4. 04
   Publish N+1 Reportreport.publish

   Posts or updates a deduplicated report comment.

The agent

N+1 Detector

Base type

Code Reviewer

Temperature

0.2

Max iterations

30

Tools

5