CVE-2026-47384

NocoDB: SQL Injection via Column Title in Bulk GroupBy

Published Jun 23, 2026 CVSS 4.0 · 5.3 Medium EPSS < 1% KEV · Not listed
Description
NocoDB is software for building databases as spreadsheets. Prior to 2026.05.1, an authenticated user with column-create permission can inject SQL into the bulk groupBy endpoint by setting a column's title to a SQL fragment. The bulk groupBy path in group-by.ts builds three database-specific knex.raw() aggregations that interpolate the request's column_name directly into the SQL string. Column lookup in data-table.service.ts matches on both the sanitized column_name field and the free-text title, so a title containing a SQL fragment bypasses the public endpoint's existing column allowlist and reaches the query builder unescaped. This vulnerability is fixed in 2026.05.1.

Analysis

AI-generated

Technical impact

Prior to 2026.05.1, an authenticated user possessing column‑create rights in NocoDB can set a column title to a SQL fragment and target the bulk groupBy endpoint. The endpoint builds three database‑specific knex.raw() aggregations that interpolate the requested column_name directly into the SQL string. Because the data‑table lookup matches both the sanitized column_name and the free‑text title, a title containing a SQL fragment bypasses the public endpoint's allowlist and reaches the query builder unescaped. This allows arbitrary SQL injection that can read, modify, or delete data in the underlying database.

Affected Systems

The vulnerability affects NocoDB versions released prior to 2026.05.1, which includes all older 2026.04 releases and earlier. Any deployment of these versions is vulnerable if users are granted column‑create rights.

Risk and Exploitability

The CVSS score of 5.3 indicates moderate severity, and the EPSS score is not available, implying limited public exploitation evidence. The vulnerability is not listed in CISA KEV. Exploitation requires authenticated access to the bulk groupBy API, which is available to users with column‑create permission, meaning the risk depends on the presence of such privileged users and the exposure of the API endpoint.

Remediation

No solution or workaround provided in the CVE record.

OpenCVE Recommended Actions

  • Upgrade NocoDB to version 2026.05.1 where the injection path has been closed.
  • Restrict column‑create permissions to trusted or necessary users so that only a minimal set of accounts can create new columns.
  • Implement server‑side validation or sanitization of column titles to prevent unescaped SQL fragments, addressing the underlying CWE‑89 issue.

Generated by OpenCVE AI on June 24, 2026 at 10:01 UTC.

Tracking

Sign in to view the affected projects.

Advisories

Source ID Title
Github GHSA Github GHSA GHSA-p8wx-5f39-w3x4 NocoDB: SQL Injection via Column Title in Bulk GroupBy
History
Type Values Removed Values Added
Metrics ssvc

{'options': {'Automatable': 'no', 'Exploitation': 'none', 'Technical Impact': 'partial'}, 'version': '2.0.3'}

Type Values Removed Values Added
First Time appeared Nocodb
Nocodb nocodb
Vendors & Products Nocodb
Nocodb nocodb
Type Values Removed Values Added
Description NocoDB is software for building databases as spreadsheets. Prior to 2026.05.1, an authenticated user with column-create permission can inject SQL into the bulk groupBy endpoint by setting a column's title to a SQL fragment. The bulk groupBy path in group-by.ts builds three database-specific knex.raw() aggregations that interpolate the request's column_name directly into the SQL string. Column lookup in data-table.service.ts matches on both the sanitized column_name field and the free-text title, so a title containing a SQL fragment bypasses the public endpoint's existing column allowlist and reaches the query builder unescaped. This vulnerability is fixed in 2026.05.1.
Title NocoDB: SQL Injection via Column Title in Bulk GroupBy
Weaknesses CWE-89
References
Metrics cvssV4_0

{'score': 5.3, 'vector': 'CVSS:4.0/AV:N/AC:L/AT:N/PR:L/UI:N/VC:L/VI:L/VA:N/SC:N/SI:N/SA:N'}

Weaknesses
  • CWE-89

    Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')

Sources

Status
PUBLISHED
Assigner
GitHub_M
Published
Updated
Jun 24, 2026, 12:37 PM
Reserved
May 19, 2026, 7:22 PM
Status
Deferred
Published
Jun 23, 2026, 9:17 PM
Modified
Jun 25, 2026, 2:21 PM