Advisory

GHSA-45rp-9p97-h852

Also known as: CVE-2026-28399

Summary

NocoDB Vulnerable to SQL Injection via DATEADD Formula

Details

Summary
An authenticated user with Creator role can inject arbitrary SQL via the DATEADD formula's unit parameter.

Details
The third argument (unit) of DATEADD was interpolated directly into knex.raw() queries after only stripping quote characters. Validation in formulas.ts only checked Literal AST node types — non-Literal types bypassed validation entirely. Affected MySQL, PostgreSQL, and SQLite function mappings.

Impact
SQL injection allowing data exfiltration or modification, scoped to the connected database.

Credit
This issue was reported by @q1uf3ng.

Severity

Medium Basis: The source's own band: MODERATE

Dates

Published
2026-03-03 20:58 UTC
Modified
2026-11-05 22:45 UTC

Affected packages and fixes

nocodb

npm · All systems

Affected

  • introduced 0, fixed 0.301.3 (semver)

Fixed versions

0.301.3

Fix

Fix commands are the export's own generic commands. Ojuju never runs them. Check them against your setup first.

Check your own computer: guard packages check

View this record on OSV.dev

Source

Source: GitHub Advisory Database (reviewed advisories) · CC BY 4.0

Sources & licences