Description
NocoBase is an AI-powered no-code/low-code platform for building business applications and enterprise solutions. In 2.0.59 and earlier, NocoBase @nocobase/plugin-collection-sql used the checkSQL() function in packages/plugins/@nocobase/plugin-collection-sql/src/server/utils.ts with an incomplete keyword blacklist that did not restrict PostgreSQL system catalog tables such as pg_shadow, pg_roles, and pg_stat_activity, allowing an admin-role user to read password hashes and database metadata through the SQL Collection feature. This vulnerability is fixed in 2.1.0-alpha.46.
Published: 2026-07-15
Score: 6.8 Medium
EPSS: < 1% Very Low
KEV: No
Impact: n/a
Action: n/a
AI Analysis

Impact

NocoBase is an AI‑powered no‑code/low‑code platform for building business applications. In versions 2.0.59 and earlier, the plugin‑collection‑sql module used a checkSQL() function with an incomplete keyword blacklist that failed to restrict PostgreSQL system catalog tables such as pg_shadow, pg_roles, and pg_stat_activity. This omission allowed administrators using the SQL Collection feature to read password hashes and database metadata, thereby exposing sensitive data. The flaw involves a keyword blacklist bypass (CWE‑184) and a failure to protect sensitive information (CWE‑200), and it was fixed in release 2.1.0‑alpha.46.

Affected Systems

The vulnerability affects NocoBase version 2.0.59 and all earlier releases. The affected component is the plugin-collection-sql module, which is used by administrators to execute arbitrary SQL queries through the platform’s UI. The issue is resolved starting with version 2.1.0‑alpha.46, which patches the blacklist to exclude sensitive system tables.

Risk and Exploitability

The CVSS score of 6.8 indicates a moderate impact, while the EPSS score of less than 1% suggests that exploitation opportunities are currently limited. Because the flaw requires an administrative role and specific plugin usage, the attack surface is constrained, and the vulnerability is not listed in the CISA KEV catalog. Nevertheless, any administrator who can access the SQL Collection feature could extract sensitive database information, making this a significant confidentiality risk in production environments.

Generated by OpenCVE AI on August 1, 2026 at 08:49 UTC.

Remediation

No vendor fix or workaround currently provided.

OpenCVE Recommended Actions

  • Upgrade to NocoBase 2.1.0‑alpha.46, which hardens the keyword blacklist and fixes the SQL Collection vulnerability, addressing both CWE-200 and CWE-184.
  • Restrict or remove administrative accounts’ ability to use the SQL Collection feature, limiting potential data exposure as per CWE-200.
  • Implement query validation that blocks references to PostgreSQL system catalog tables (pg_shadow, pg_roles, pg_stat_activity) before execution, mitigating the SQL blacklist bypass identified as CWE-184.

Generated by OpenCVE AI on August 1, 2026 at 08:49 UTC.

Tracking

Sign in to view the affected projects.

Advisories
Source ID Title
Github GHSA Github GHSA GHSA-v8vm-cqh8-q87q NocoBase: Sensitive Data Exposure via SQL Blacklist Bypass
History

Thu, 16 Jul 2026 16:30:00 +0000

Type Values Removed Values Added
Metrics ssvc

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


Thu, 16 Jul 2026 00:00:00 +0000

Type Values Removed Values Added
First Time appeared Nocobase
Nocobase nocobase
Vendors & Products Nocobase
Nocobase nocobase

Wed, 15 Jul 2026 20:45:00 +0000

Type Values Removed Values Added
Description NocoBase is an AI-powered no-code/low-code platform for building business applications and enterprise solutions. In 2.0.59 and earlier, NocoBase @nocobase/plugin-collection-sql used the checkSQL() function in packages/plugins/@nocobase/plugin-collection-sql/src/server/utils.ts with an incomplete keyword blacklist that did not restrict PostgreSQL system catalog tables such as pg_shadow, pg_roles, and pg_stat_activity, allowing an admin-role user to read password hashes and database metadata through the SQL Collection feature. This vulnerability is fixed in 2.1.0-alpha.46.
Title NocoBase: Sensitive Data Exposure via SQL Blacklist Bypass
Weaknesses CWE-184
CWE-200
References
Metrics cvssV3_1

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


Subscriptions

Nocobase Nocobase
cve-icon MITRE

Status: PUBLISHED

Assigner: GitHub_M

Published:

Updated: 2026-07-16T15:12:38.696Z

Reserved: 2026-06-08T21:44:27.365Z

Link: CVE-2026-52888

cve-icon Vulnrichment

Updated: 2026-07-16T14:50:22.366Z

cve-icon NVD

No data.

cve-icon Redhat

No data.

cve-icon OpenCVE Enrichment

Updated: 2026-08-01T09:00:04Z

Weaknesses
  • CWE-184

    Incomplete List of Disallowed Inputs

  • CWE-200

    Exposure of Sensitive Information to an Unauthorized Actor