CVE Explore

SQL Injection in Prest

CVE-2026-104129

CVSS v3
8.1 High
Public exploits
None known
EPSS
0.004 · 38.1th percentile
Published
2026-11-19

What to do

Fixed in
2.4.0
Affected
1 affected product

pREST (PostgreSQL REST) is an API that delivers an application on top of a Postgres database. Prior to 2.4.0, the vulnerable parameter is _groupby, handled by GroupByClause in adapters/postgres/postgres.go. adapters/postgres/postgres.go uses the weaker isSafeSQLExpression check for this function-expression branch instead of the stricter single-field validator used for _select. That check validates only the outer function name against a 13-function allowlist and permits nested subqueries, trailing UNION syntax, and inner pg_ functions. controllers/crud.go concatenates the GROUP BY expression while parameterizing only WHERE values, allowing attacker-controlled SQL structure into the clause. Default configuration permits unauthenticated access; a restricted installation may require a low-privilege table reader. UNION-based extraction requires compatible column counts and types and was not verified end to end, but a delay-producing function can cause denial of service without that alignment. This issue is fixed in 2.4.0.

Vulnerability class: SQL Injection

Published · last modified .

CVSS v3 metric

CVSS v3 base score 8.1 (High). Vector: CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:N.

Attack Vector
Network AV:N
Attack Complexity
Low AC:L
Privileges Required
Low PR:L
User Interaction
None UI:N
Scope
Unchanged S:U
Confidentiality
High C:H
Integrity
High I:H
Availability
None A:N

EPSS exploit prediction

EPSS 0.004, 38.1th percentile (last changed ); unchanged over 30 days. About EPSS.

Affected products

  • Prest — versions < 2.4.0

Weakness classification (CWE)

References