ArchPilotExecutable architecture guardrails

Search docs

Docs search

Validation rule

Back to Rule Catalog
AP-DQR-005Data / Query Risk

N+1 query evidence in collection loop

Flags collection workflows that appear to query inside a loop.

warningviolationNo auto-fix

How to fix

  1. Batch-load related records.
  2. Use include/select or joins where appropriate.
  3. Add tests or traces for collection-size behavior.

What the rule validates

A request path likely performs one query for each item in a collection.

Why it matters

N+1 queries become slow and expensive as collection size grows.

Common causes

  • Related data is fetched per row.
  • A loop calls a repository method repeatedly.
  • Batch loading was not added for a new relationship.

Typical violation example

for each repository, query latest snapshot separately.

Typical compliant example

Fetch latest snapshots for all repository ids in one bounded query.

Related rules

AP-DQR-001 - Missing tenant filter evidence in multi-tenant SQLAP-DQR-002 - Broad SELECT * usage in query pathAP-DQR-003 - Unbounded query risk without limit/pagination evidenceAP-DQR-004 - Cross-module direct database access bypasses module boundary

Adjacent categories

Data / Query Risk

Related files/config

  • apps/api/src
  • packages/db/prisma/schema.prisma

Related CLI commands

  • archpilot validate
  • archpilot validate --ci

Related docs

Rule CatalogData / Query RiskValidation & Findings
AP-DQR-005 - N+1 query evidence in collection loop | ArchPilot Docs