Vulnerability in @nocobase/plugin-collection-sql (CVE-2026-52888)
Summary
Vulnerability in @nocobase/plugin-collection-sql (CVE-2026-52888). Confidential information can be exposed externally. Exploitable via POST /api/sqlCollection. Mitigation: upgrade to 2.1.0-beta.45 or later.
Original description
The description as published by the source.
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.
Source: NIST National Vulnerability Database NVD GitHub Advisory
Auto-generated summary
Assembled by SecPulse from the source data (CVSS, CWE, affected versions) using templates — no AI involved. Check the original description and references below for exact details.
A vulnerability tracked as CVE-2026-52888 has been found in @nocobase/plugin-collection-sql.
Attackers can target a specific entry point like POST /api/sqlCollection over the network to misuse the product.
Confidential information can be exposed externally. CVSS score: 6.8/10.
What to do: upgrade @nocobase/plugin-collection-sql to 2.1.0-beta.45 or later.
If unsure, ask your IT team or search "@nocobase/plugin-collection-sql CVE-2026-52888" on the vendor's site.
CVE-2026-52888 (@nocobase/plugin-collection-sql) — CWE-184 / CVSS v3 6.8
Attack vector: remote (network-reachable) / no user interaction
Attack surface: POST /api/sqlCollection / pg_shadow / pg_roles / pg_stat_activity
Patched: 2.1.0-beta.45 — apply immediately
Plan: 1) Audit SBOM/dependencies, 2) Stage→prod upgrade, 3) Add WAF/proxy monitoring on affected endpoints, 4) Hunt IOCs in logs.
Refs: see the GHSA / vendor advisory / patched release linked on this page.
A vulnerability (CWE-184) exists in @nocobase/plugin-collection-sql. Attackers reach the vulnerable code path via POST /api/sqlCollection.
Check the vendor advisory for the affected versions of @nocobase/plugin-collection-sql. Attack surface: POST /api/sqlCollection / pg_shadow / pg_roles / pg_stat_activity.
Severity: Medium (CVSS 6.8/10). Confidential information can be exposed externally.
Update to 2.1.0-beta.45.
Until the patch is applied: disable the affected feature, apply WAF rules, or restrict access via network ACLs.
Search webserver/proxy logs for unusual POST /api/sqlCollection requests with malformed payloads or SQL meta-characters. Run grep -r '@nocobase/plugin-collection-sql' . against your dependency files (package-lock.json, requirements.txt, go.sum) to find affected services.
Response actions
Concrete steps and command examples for SOC/SRE teams to execute in order
-
1Identify exposure identify
grep -r '@nocobase/plugin-collection-sql' . | grep -v node_modulesリポジトリと本番環境の依存ファイル (package-lock.json / requirements.txt / go.sum / Gemfile.lock 等) で
@nocobase/plugin-collection-sqlを grep し、稼働しているサービス・バージョンを把握する。 -
2Hunt for indicators of compromise detect
grep 'POST /api/sqlCollection' /var/log/nginx/access.log | grep -E '(unusual_payload|sqli_pattern)'アクセスログで
POST /api/sqlCollectionへの異常なリクエスト (不正な認証ヘッダ・SQLメタ文字)を過去 30〜90日分捜索。WAF/SIEM があれば該当パスのアラート発火履歴を確認。 -
3Apply patch patch
Upgrade @nocobase/plugin-collection-sql to 2.1.0-beta.45ステージング環境で 2.1.0-beta.45 に上げて回帰テスト → 本番反映。回帰テストはアプリの主要ハッピーパスと、Step 2 で見つけた異常検知の続報チェックを含めること。
-
4Post-deployment verification verify
Replay attack against POST /api/sqlCollection on staging to confirm patch closes the vectorパッチ適用後、ステージングで PoC または同等の悪用パターンを再現して脆弱性が閉じたことを確認。本番では Step 2 と同じログクエリでアラート再発が無いか継続監視。
Affected packages
References
- advisory github.com
- advisory nvd.nist.gov
- advisory github.com
- package github.com
- patch github.com
- web github.com
- web github.com
- web github.com
- web github.com
- web github.com