Security context

What an agent needs to avoid regressing past fixes and find the next vuln in this repo.

piotrostr/listen
main @ 76efbaf
3
Fixes
0
CVEs
HIGH
Peak severity
Highlights
Denial of Service: 2 prior fixes. Scrutinize any change in this area.
listen-adapter/src/routes.rs: most-fixed (1 issue). Treat as high-risk during review.
1 high-severity fix in this history; regressions here are high-impact.
Recurring patterns

The bug types that recur here, drawn from past fixes, not open vulnerabilities.

SQL Injection: Incomplete validation of database queries allowed attackers to execute unauthorized commands via the generic ClickHouse query endpoint. Developers must ensure that parameterization or robust, boundary-aware regex validations are consistently applied to all dynamic SQL execution paths.
Denial of Service: Using the synchronous, blocking KEYS command on Redis can lock up the database engine under heavy load. Utilizing non-blocking pagination via SCAN is required to prevent resource starvation.
Denial of Service: Unbounded dialogue inputs in the reasoning loop can exhaust the LLM context window, causing high latency, elevated operational costs, and system crashes. Tight integration of token tracking and preemptive sequence trimming is critical.