Report Query Guard
Component Detail
Infrastructure
medium complexity
backend
0
Dependencies
0
Dependents
0
Entities
0
Integrations
Description
Middleware that enforces query complexity limits before execution, including maximum number of joins, maximum result row count, query timeout, and rate limiting per user to protect PostgreSQL performance under heavy reporting usage.
report-query-guard
Responsibilities
- Enforce maximum join count per query
- Enforce maximum result row limits
- Apply query execution timeout
- Rate-limit report executions per user and organization
Interfaces
validateComplexity(specification)
enforceRowLimit(specification)
getQueryTimeout()
checkRateLimit(userId, orgId)
recordExecution(userId, orgId)