{"items":[{"id":"NVI-00016282","kind":"vulnerability","title":"NocoDB: Postgres SQL Injection in Formula `ARRAYSORT`","revision":2,"unknowns":["Customer inventory, deployment, reachability and exploitation have not been inspected.","NVD lastModified does not establish freshness of every associated CPE record."],"lifecycle":"active","identifiers":["GHSA-cxv7-gmmp-228p","CVE-2026-47375"],"plain_summary":"GitHub lists this reviewed advisory for nocodb. Published version ranges and source prerequisites are shown below; this is not an inspection of a visitor’s application.","review_status":"source_listed","control_topics":[],"public_actions":[{"summary":"Identify the exact component and deployed version, examine the linked publisher’s conditions, and retain evidence of any mitigation.","source_ids":["sr-6c38004cb0106d2a7c7003a3aa38f7d1"],"action_type":"investigate","limitations":"Confirm current vendor support, compatibility and deployment evidence. This report has not tested a fix in your system.","current_supported_target":null}],"schema_version":"1.1.0","source_metrics":[{"kind":"CVSS","as_of":"2026-07-20T21:17:15.000Z","value":"6 medium","meaning":"GitHub source severity; exploitability and local consequence require separate evidence.","source_id":"sr-5eb54023bd81164e0a2119e5fe12af7c"},{"kind":"CVSS","as_of":"2026-06-25T14:21:00.260Z","value":"6 MEDIUM (3.1)","meaning":"security-advisories@github.com severity; no combined Null risk score.","source_id":"sr-6c38004cb0106d2a7c7003a3aa38f7d1"}],"why_it_matters":"Published affected context helps an owner decide what evidence to gather. This report has not examined your application.","related_sources":[{"id":"sr-5eb54023bd81164e0a2119e5fe12af7c","url":"https://github.com/advisories/GHSA-cxv7-gmmp-228p","basis":"vendor_advisory","notes":"GitHub Advisory Database; CC-BY-4.0. Each advisory links its original attribution. Null normalizes fields.","title":"GHSA-cxv7-gmmp-228p","publisher":"GitHub Advisory Database","observed_at":"2026-11-04T02:47:44.783Z"},{"id":"sr-6c38004cb0106d2a7c7003a3aa38f7d1","url":"https://nvd.nist.gov/vuln/detail/CVE-2026-47375","basis":"official_catalog","notes":"This product uses data from the NVD API but is not endorsed or certified by the NVD.","title":"CVE-2026-47375","publisher":"NIST National Vulnerability Database","observed_at":"2026-11-08T01:47:43.921Z"}],"affected_context":[{"certainty":"source_listed","source_ids":["sr-5eb54023bd81164e0a2119e5fe12af7c"],"technology":"nocodb","known_exclusions":[],"conditions_summary":"### Summary\n\nAn authenticated user with `columnAdd` permission on a Postgres-backed base can inject arbitrary SQL into the formula engine via the optional `direction` argument of `ARRAYSORT(...)`. The value is unrestricted by formula validation and embedded into a `knex.raw` `ORDER BY` clause, executing during column creation and on every subsequent record read of the formula column.\n\n### Details\n\nThe vulnerability is specific to the Postgres mapping for `ARRAYSORT` in `packages/nocodb/src/db/functionMappings/pg.ts`. Two factors combine:\n\n1. `ARRAYSORT` declares only argument count, not `validation.args.type`, so `validate-extract-tree.ts` does not enforce an allowlist on the second argument.\n2. The Postgres mapping then passes the attacker-controlled value through `sanitize(knex.raw(...))` into a raw SQL fragment:\n\n```ts\nconst direction = pt.arguments[1]\n  ? sanitize(\n      knex.raw(pt.arguments[1]?.value ?? (await fn(pt.arguments[1])).builder),\n    )\n  : knex.raw('asc');\n\nreturn {\n  builder: knex.raw(`ARRAY(SELECT UNNEST(??) ORDER BY 1 ??)`, [source, direction]),\n};\n```\n\n`sanitize()` in `sqlSanitize.ts` only escapes `?` placeholder characters; it does not validate SQL syntax. A p","public_affected_ranges":["< 2026.04.1"]}],"null_published_at":"2026-11-08T19:53:48.744Z","source_updated_at":"2026-07-20T21:17:15.000Z","source_disclosed_at":"2026-06-05T15:59:28.000Z","is_synthetic_fixture":false,"null_last_reviewed_at":null,"public_change_summary":"Source facts changed; compare the preserved prior revision.","null_first_observed_at":"2026-11-04T02:47:44.783Z"},{"id":"NVI-00016282","kind":"vulnerability","title":"NocoDB: Postgres SQL Injection in Formula `ARRAYSORT`","revision":1,"unknowns":["Customer inventory, deployment, reachability and exploitation have not been inspected."],"lifecycle":"active","identifiers":["GHSA-cxv7-gmmp-228p","CVE-2026-47375"],"plain_summary":"GitHub lists this reviewed advisory for nocodb. Published version ranges and source prerequisites are shown below; this is not an inspection of a visitor’s application.","review_status":"source_listed","control_topics":[],"public_actions":[{"summary":"Identify the exact component and deployed version, examine the linked publisher’s conditions, and retain evidence of any mitigation.","source_ids":["sr-5eb54023bd81164e0a2119e5fe12af7c"],"action_type":"investigate","limitations":"Confirm current vendor support, compatibility and deployment evidence. This report has not tested a fix in your system.","current_supported_target":null}],"schema_version":"1.1.0","source_metrics":[{"kind":"CVSS","as_of":"2026-07-20T21:17:15.000Z","value":"6 medium","meaning":"GitHub source severity; exploitability and local consequence require separate evidence.","source_id":"sr-5eb54023bd81164e0a2119e5fe12af7c"}],"why_it_matters":"Published affected context helps an owner decide what evidence to gather. This report has not examined your application.","related_sources":[{"id":"sr-5eb54023bd81164e0a2119e5fe12af7c","url":"https://github.com/advisories/GHSA-cxv7-gmmp-228p","basis":"vendor_advisory","notes":"GitHub Advisory Database; CC-BY-4.0. Each advisory links its original attribution. Null normalizes fields.","title":"GHSA-cxv7-gmmp-228p","publisher":"GitHub Advisory Database","observed_at":"2026-11-04T02:47:44.783Z"}],"affected_context":[{"certainty":"source_listed","source_ids":["sr-5eb54023bd81164e0a2119e5fe12af7c"],"technology":"nocodb","known_exclusions":[],"conditions_summary":"### Summary\n\nAn authenticated user with `columnAdd` permission on a Postgres-backed base can inject arbitrary SQL into the formula engine via the optional `direction` argument of `ARRAYSORT(...)`. The value is unrestricted by formula validation and embedded into a `knex.raw` `ORDER BY` clause, executing during column creation and on every subsequent record read of the formula column.\n\n### Details\n\nThe vulnerability is specific to the Postgres mapping for `ARRAYSORT` in `packages/nocodb/src/db/functionMappings/pg.ts`. Two factors combine:\n\n1. `ARRAYSORT` declares only argument count, not `validation.args.type`, so `validate-extract-tree.ts` does not enforce an allowlist on the second argument.\n2. The Postgres mapping then passes the attacker-controlled value through `sanitize(knex.raw(...))` into a raw SQL fragment:\n\n```ts\nconst direction = pt.arguments[1]\n  ? sanitize(\n      knex.raw(pt.arguments[1]?.value ?? (await fn(pt.arguments[1])).builder),\n    )\n  : knex.raw('asc');\n\nreturn {\n  builder: knex.raw(`ARRAY(SELECT UNNEST(??) ORDER BY 1 ??)`, [source, direction]),\n};\n```\n\n`sanitize()` in `sqlSanitize.ts` only escapes `?` placeholder characters; it does not validate SQL syntax. A p","public_affected_ranges":["< 2026.04.1"]}],"null_published_at":"2026-11-04T10:04:27.927Z","source_updated_at":"2026-07-20T21:17:15.000Z","source_disclosed_at":"2026-06-05T15:59:28.000Z","is_synthetic_fixture":false,"null_last_reviewed_at":null,"public_change_summary":"First indexed by Null; source disclosure date is shown separately.","null_first_observed_at":"2026-11-04T02:47:44.783Z"}],"next_cursor":null,"snapshot_revision":"42594"}