Repeated query pattern in one request flow

How to fix

1. Fetch shared context once and pass it through.
2. Batch similar queries.
3. Add request-level caching only when it matches consistency needs.

What the rule validates

A workflow appears to execute duplicate query patterns during one request.

Why it matters

Repeated queries add latency and increase load without improving correctness.

Common causes

• Several helpers independently fetch the same record.
• No request-level memoization or shared query result exists.
• A service calls multiple workflows that each reload context.

Typical violation example

A request loads organization membership in auth, service, and repository helpers separately.

Typical compliant example

Resolve membership once, then pass the scoped context through the workflow.

Related rules

Adjacent categories

Related files/config

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

Related CLI commands

• archpilot validate
• archpilot validate --ci