Try for free

N+1 query detection for pull requests

Find the N+1 query in the pull request, not in production.

IonWarp flags N+1 and unbounded queries and blocking calls on request paths, on the line that adds them.

14 days free, no cardPro is $49/mo for 5 seatsRead-only code access

Example IonWarp review of PR #640
IonWarpbotexample review

IonWarp Review — PR #640

3 issues 2 P1 1 P2
Findings in this review
#  SevIssueFile
1   N+1 query in GET /ordersapp/api/orders/route.ts
2   Unbounded SELECT on eventslib/events/list.ts
3   Three awaits run one after anotherlib/dashboard/load.ts
app/api/orders/route.ts
33 for (const o of orders) {34+  o.items = await db.query.items.findMany({ where: eq(items.orderId, o.id) });35 }
One query per order on the list page · API Performance

A page of 50 orders runs 51 queries. Load the items in one query with inArray(items.orderId, ids) and group them in memory.

Suggested fixAI fix promptAdd to To-do
ZestNorthTonikFlypsDozerWildfiresMisaLabsePlan

How it works

1

Install the GitHub App

Pick the repositories. IonWarp reads the code and comments on pull requests. It never pushes a commit.

2

Open a pull request

API Performance reads the diff. Flags N+1 and unbounded queries and blocking calls on request paths.

3

Fix it with your agent

Every finding has a fix prompt for Claude Code, Cursor or Codex. Push the fix and IonWarp checks it again.

Specialist reviewers

Add SOC 2 Review
to your pull requests.

IonWarp is a next-gen AI code reviewer for GitHub pull requests, built on open models.

IonWarp SOC 2 Review on DeepSeek V4.1 Flash: about 4¢ a reviewthe benchmark →

Example IonWarp review of PR #219
IonWarpbotexample review

IonWarp Review — PR #219

3 issues 2 P1 1 P2
Findings in this review
#  SevIssueFile
1   Role change writes no audit logapp/api/admin/roles.ts
2   Required CI check disabled.github/workflows/ci.yml
3   Token printed in a debug loglib/auth/session.ts
.github/workflows/ci.yml
44   test:45+    if: false46     runs-on: ubuntu-latest
The required test job never runs · SOC 2 Review

if: false skips the job, but branch protection still shows it as passing. That breaks change-management control CC8.1.

Suggested fixAI fix promptAdd to To-do

What API Performance catches

Queries

N+1 and unbounded reads

Loops that query, list reads with no limit, filters no index can serve.

Latency

Work that waits in line

Serial awaits, blocking calls and sync I/O on a request path.

Payloads

Responses that keep growing

Endpoints returning whole tables or nested objects nobody reads.

How each reviewer scores.

On 18 real pull requests with 13 known issues, API Performance runs on DeepSeek V4.1 Flash: F1 53.3%, 6m 27s a review at the median, $0.043 in model cost. IonWarp · Muse Spark 1.3 leads on F1 at 56.0%, at $0.063 a review. This lane is provisional until its case set grows and its labels are reviewed.

API Performance: how each reviewer scoresProvisional
API Performance: how each reviewer scores
Model / AppReviewer ScoreF1Latency$/run
IonWarp · Muse Spark 1.377.856.0%42s$0.063
IonWarp · GLM 5.3 Flash63.448.3%49s$0.0049
Greptile v4.112 of 18 PRs—76.9%4m 59s~$1.75
IonWarp · GPT 5.6 Luna Pro61.350.0%28s$0.030
Qodo v212 of 18 PRs—66.7%5m 43s~$1.67
Cursor Bugbot12 of 18 PRs—71.4%7m 57s~$1.25
IonWarp · DeepSeek V4 Pro59.752.2%1m 21s$0.042
IonWarp · DeepSeek V4.1 FlashRuns on your PRs52.653.3%6m 27s$0.043
IonWarp · Gemini 3.8 Flash15.941.7%47s$0.071
CodeRabbit12 of 18 PRs—44.4%6m 00s~$1.50

Reviewer Score = (3 × F1 + time + $/run) ÷ 5, each part 0 to 100 within this table. IonWarp rows cost the model’s inference; ~$ is each app’s list price for 5 seats at 100 reviews a month. Rows measured on part of the PRs get no Score. Provisional scoped-label matching. Release 2026-10-12, CC BY 4.0.

API Performance

IonWarp inferenceApp price estimatesF1 on the same 18 open-source pull requests for every reviewer

40%50%60%$0.01$0.03$0.10Cost per review · USD · log scaleMuse Spark 1.3DeepSeek V4.1 FlashDeepSeek V4 ProGPT 5.6 Luna ProGLM 5.3 FlashGemini 3.8 Flash

Full API Performance resultsHow we measure

Pricing

Simple pricing for your whole team.

One workspace price with seats included. Every agent on every plan, and a monthly budget IonWarp stays inside. 14 days free, no card.

ProMost popular

$49 /mo per workspace

One team, every agent from day one.

  • 5 seats included
  • All eight agents, every repo you connect
  • $25 of review spend a month
  • A monthly budget you set
Start 14-day trial

Max

$149 /mo per workspace

Bigger teams and a bigger review budget.

  • 10 seats included
  • All eight agents, every repo you connect
  • $100 of review spend a month
  • A monthly budget you set
  • Priority models and support
Start 14-day trial

More than 10 people?

Tell us how many seats and how much review spend you need, and we will set up the workspace.

Contact us

FAQ

Frequently asked questions

What is the N+1 query problem?

Code loads a list with one query, then runs one more query for each item in it: 1 + N round trips where 1 or 2 would do. It hides in loops and in ORM relations that load lazily, and it gets slower as the list grows.

How do you fix an N+1 query?

Load the related rows in one query (a join, or WHERE id IN (…)) and group them in memory, or use your ORM’s eager loading. IonWarp suggests the version that fits the code in the PR.

Is this an APM?

No. It reviews the code before it ships. Keep your APM for production; IonWarp stops the regression from reaching it.

Does it need access to my database?

No. It reads the code in the pull request and the files that code calls.

How accurate is API Performance?

On 18 real pull requests with 13 known issues, API Performance runs on DeepSeek V4.1 Flash: F1 53.3%, 6m 27s a review at the median, $0.043 in model cost. IonWarp · Muse Spark 1.3 leads on F1 at 56.0%, at $0.063 a review. This lane is provisional: its case set is small and still under review, so read it as a direction, not a ranking. Every row, PR and judge verdict is public.

What does it cost?

Pro is $49 a month per workspace with 5 seats and $25 of review spend included. Max is $149 with 10 seats and $100. Every agent is in both. Start with a 14-day trial, no card.

Fast endpoints, PR after PR.

Try for free

14 days free, no card. Then Pro is $49 a month per workspace with 5 seats, or Max $149 with 10.