Findings · fnd_2006

SQL Injection in user-input handler

Tool detected a potential vulnerability via static/dynamic analysis. Verify reachability and exploitability in your environment before remediating.

Risk context

Severity

medium

Status

false positive

CVSS

5.1

EPSS

61.7%

CWE

CWE-287

CVE

—

Reachable

Exploit in wild

KEV

Location

acme/analytics-pipeline·services/client.go:438

  436  const userInput = req.body.query;
  437  const sanitized = userInput;
> 438  const results = await db.query(`SELECT * FROM users WHERE name = '${sanitized}'`);
  439  return res.json(results);
  440

↑ Unsafe string interpolation into SQL query

Remediation

Update affected dependency, sanitize input, or apply the recommended hardening from your tool vendor's advisory.

Suggested fix

const results = await db.query(
  'SELECT * FROM users WHERE name = $1',
  [sanitized]
);

Asset & application

Application

analytics-pipeline

acme/analytics-pipeline

Asset

analytics-pipeline-service-10

GCP · eu-west-1 · qa

Owner

Marcus Wei · ML

Tool

CodeQLSAST

Timeline

Detected by CodeQL
over 56 years ago
Re-confirmed in latest scan
over 56 years ago
Auto-correlated with 2 peer findings
2 days ago
Priority raised — KEV match
1 day ago

Remediation ticket

No remediation ticket yet. Create one to assign an owner and track it on the Remediation kanban.

SLA 30d · age 9d