High severityRubyInjectionHIGH confidence
Activerecord Sqli Tainted Input
Untrusted input flows into a raw ActiveRecord SQL API (find_by_sql, exec_query, connection.execute, order/where with a raw string), enabling SQL injection (CWE-89).
Standards mapping
- OWASP Top 10
- A03:2021 - Injection
- OWASP ASVS
- V5.3.4 (L1)
Vulnerable vs. safe
Flagged by this check
ActiveRecord::Base.connection.execute(params[:sql])Passes - the safe pattern
ActiveRecord::Base.connection.execute("SELECT 1")Why it matters & how to fix it
Untrusted input flows into a raw ActiveRecord SQL API (find_by_sql, exec_query, connection.execute, order/where with a raw string), enabling SQL injection (CWE-89). Use parameterized queries: pass a hash or an array condition (Model.where("col = ?", value)) and never interpolate request data into SQL strings.
References
Rule ID integsec-ruby-activerecord-sqli-taint - engine: Opengrep - license: MIT - Copyright (c) IntegSec Inc.
TurboPentest runs this check automatically
Connect a GitHub repo and this check runs on every white-box pentest - AI-validated and reported with proof, from $99 per target.
Start a pentestRelated checks
- JavaScript / TypeScript - InjectionCode Injection Tainted Input
- JavaScript / TypeScript - InjectionEval Dynamic Argument
- JavaScript / TypeScript - InjectionNoSQL Query From Request
- JavaScript / TypeScript - InjectionNoSQL Where Operator
- JavaScript / TypeScript - InjectionOS Command Injection Tainted Input
- JavaScript / TypeScript - InjectionSQL Injection String Concatenation