Security context
What an agent needs to avoid regressing past fixes and find the next vuln in this repo.
dataease/sqlbot
main @ 582893a
55
Fixes
8
CVEs
CRITICAL
Peak severity
28.1%
Coverage
Highlights
Auth Bypass: 26 prior fixes. Scrutinize any change in this area.
backend/apps/datasource/api/datasource.py: most-fixed (10 issues). Treat as high-risk during review.
44 high-severity fixes in this history; regressions here are high-impact.
Recurring patterns
The bug types that recur here, drawn from past fixes, not open vulnerabilities.
Auth Bypass: The application failed to verify cryptographic signatures during JWT decoding in TokenMiddleware, enabling remote attackers to entirely bypass authentication and access embedded views. This was accompanied by a lack of status checks on retrieved user entities.
SQL Injection: LLM-generated queries were executed against backend databases without robust security controls, allowing malicious commands. The application had to introduce rigorous SQL AST analysis via sqlglot to enforce a strict table allowlist and block destructive operations.
Arbitrary File Read: Insecure handling of JDBC connection parameters permitted rogue database server responses to read local files from the system via the LOAD DATA LOCAL INFILE mechanism. Hardening was required to aggressively blocklist and validate driver-specific extra parameter string inputs.