High severityRubyInjectionHIGH confidence
Activerecord Sqli Interpolation
A raw string is interpolated/concatenated into an ActiveRecord query clause, 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
User.where("name = '#{params[:name]}'")Passes - the safe pattern
User.where("name = ?", params[:name])Why it matters & how to fix it
A raw string is interpolated/concatenated into an ActiveRecord query clause, enabling SQL injection (CWE-89). Use bound parameters: where("col = ?", value) or where(col: value); never build SQL clauses from interpolated variables.
References
Rule ID integsec-ruby-activerecord-sqli-interpolation - 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