T09 · Insecure Skill Coding Practices
- Location
scripts/task-system.sh:13- Finding
SQL Injection Through Unvalidated Task Identifiers
- Content
View full analysis
- Remediation
View remediation
&2 exit 2 fi ``` 2. Apply equivalent validation in `task-system.sh`, `heartbeat.sh`, and `complete-task.sh`. 3. Do not silently default mutation operations to task ID `1`; require an explicit identifier to reduce accidental changes. 4. Prefer a SQLite API that supports bound parameters rather than constructing SQL with shell interpolation. 5. Check the SQLite process exit status and verify that exactly one expected row was affected before printing a success message. 6. Add regression tests using malformed values such as spaces, negative values, quotes, semicolons, SQL comments, and multiple statements. ]]>
