CVE-2026-52887

NocoBase: SQL injection in /api/myInAppChannels:list filter to PG-superuser RCE

Published Jul 15, 2026 CVSS 3.1 · 10 Critical EPSS < 1% KEV · Not listed
Description
NocoBase is an AI-powered no-code/low-code platform for building business applications and enterprise solutions. Prior to 2.0.61, NocoBase @nocobase/plugin-notification-in-app-message exposed GET /api/myInAppChannels:list, where the filter[latestMsgReceiveTimestamp][$lt] value was inserted into a Sequelize.literal() template string without escaping or parameter binding, allowing a signed-up authenticated user to run stacked PostgreSQL statements and potentially execute commands with COPY ... TO PROGRAM. This vulnerability is fixed in 2.0.61.

Analysis

AI-generated

Technical impact

An authenticated user can exploit a SQL injection flaw in the GET /api/myInAppChannels:list endpoint of NocoBase caused by inserting the filter[latestMsgReceiveTimestamp][$lt] value directly into a Sequelize.literal() template string without proper escaping or parameter binding. Prior to version 2.0.61, this allowed stacked PostgreSQL statements to be run, potentially enabling execution of privileged commands such as COPY … TO PROGRAM. The vulnerability is a classic SQL injection (CWE‑89) and carries a CVSS score of 10, indicating a severe risk of remote code execution on the host system.

Affected Systems

Any NocoBase installation using the @nocobase/plugin‑notification‑in‑app‑message before version 2.0.61 is affected. The fix was released in 2.0.61; earlier releases remain vulnerable.

Risk and Exploitability

The vulnerability presents a high‑severity attack surface, but the EPSS score of less than 1 % suggests that exploitation attempts have been rare to date. The flaw requires that an attacker be a signed‑up, authenticated user of the platform and that they can manipulate the filter query parameter; thus, the attack vector is an authenticated HTTP request. Although the flaw is not listed in CISA’s KEV catalog, its potential to execute commands on the host system makes it a critical threat for any deployment with permissive database access.

Remediation

No solution or workaround provided in the CVE record.

OpenCVE Recommended Actions

  • Upgrade NocoBase to version 2.0.61 or newer to apply the vendor patch.
  • If upgrading immediately is not possible, revoke or reduce the PostgreSQL privileges granted to the NocoBase database user—particularly the ability to perform statements such as COPY … TO PROGRAM—so that even injected commands cannot be executed.
  • Audit the code base for other uses of Sequelize.literal with user‑controlled data and enforce parameterized queries or strict input validation for all query parameters.

Generated by OpenCVE AI on July 31, 2026 at 02:48 UTC.

Tracking

Sign in to view the affected projects.

Advisories

Source ID Title
Github GHSA Github GHSA GHSA-p849-8hwh-84j9 NocoBase: SQL injection in /api/myInAppChannels:list filter to PG-superuser RCE
History
Type Values Removed Values Added
Metrics ssvc

{'options': {'Automatable': 'yes', 'Exploitation': 'poc', 'Technical Impact': 'total'}, 'version': '2.0.3'}

Type Values Removed Values Added
First Time appeared Nocobase
Nocobase nocobase
Vendors & Products Nocobase
Nocobase nocobase
Type Values Removed Values Added
Description NocoBase is an AI-powered no-code/low-code platform for building business applications and enterprise solutions. Prior to 2.0.61, NocoBase @nocobase/plugin-notification-in-app-message exposed GET /api/myInAppChannels:list, where the filter[latestMsgReceiveTimestamp][$lt] value was inserted into a Sequelize.literal() template string without escaping or parameter binding, allowing a signed-up authenticated user to run stacked PostgreSQL statements and potentially execute commands with COPY ... TO PROGRAM. This vulnerability is fixed in 2.0.61.
Title NocoBase: SQL injection in /api/myInAppChannels:list filter to PG-superuser RCE
Weaknesses CWE-89
References
Metrics cvssV3_1

{'score': 10, 'vector': 'CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:C/C:H/I:H/A:H'}

Weaknesses
  • CWE-89

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

Sources

Status
PUBLISHED
Assigner
GitHub_M
Published
Updated
Jul 20, 2026, 2:39 PM
Reserved
Jun 8, 2026, 9:44 PM
Status
Deferred
Published
Jul 15, 2026, 9:16 PM
Modified
Jul 20, 2026, 4:17 PM