Response playbooks, investigation guides, and Atomic Red Team tests are Pro-only. Upgrade to unlock the full detection package for CVE-2026-52887.
Unlock with Pro - from £29/user/moDetect NocoBase myInAppChannels:list SQL Injection to PostgreSQL Superuser RCE (CVE-2026-52887) in Splunk
CVE-2026-52887 is a critical (CVSS 10.0) SQL injection vulnerability in the @nocobase/plugin-notification-in-app-message plugin's /api/myInAppChannels:list endpoint filter parameter, affecting NocoBase versions <= 2.0.60. An unauthenticated or low-privileged attacker can inject arbitrary SQL through the filter query parameter, which is passed insufficiently sanitized into the underlying Sequelize/PostgreSQL query builder. Because NocoBase's database connection frequently runs with elevated (superuser) PostgreSQL privileges to support its dynamic schema/collection features, successful injection can be escalated via COPY ... TO/FROM PROGRAM or dblink/plpythonu extensions to achieve full remote code execution on the database host. Patched in v2.0.61 (PR #9630, commit 68d64e3).
MITRE ATT&CK
- Tactic
- Initial Access Execution
SPL Detection Query
index=web_logs sourcetype=access_combined OR sourcetype=nocobase:app
| search uri_path="*myInAppChannels:list*" uri_query="*filter*"
| eval decoded_query=urldecode(uri_query)
| regex decoded_query="(?i)(COPY\s+.*PROGRAM|dblink|plpythonu|UNION\s+SELECT|pg_read_file|lo_import|lo_export|information_schema|--\s|/\*)"
| table _time, clientip, method, uri_path, decoded_query, status
| sort -_timeIdentifies HTTP requests to NocoBase's vulnerable /api/myInAppChannels:list endpoint where the filter parameter contains SQL injection indicators consistent with CVE-2026-52887 exploitation, including PostgreSQL privilege-escalation primitives like COPY PROGRAM and dblink.
Data Sources
Required Sourcetypes
False Positives & Tuning
- Legitimate authorized penetration testing traffic
- Security researchers validating the patch
- Log aggregation misclassifying encoded query strings
Other platforms for CVE-2026-52887
Testing Methodology
Validate this detection against 3 adversary techniques from Atomic Red Team. Each test below lists the behaviour to exercise and the telemetry you should expect to see. Executable commands and cleanup steps are available with Pro.
- Test 1Simulate SQL Injection Probe Against myInAppChannels:list
Expected signal: HTTP access log entry showing GET /api/myInAppChannels:list with URL-encoded filter parameter containing 'UNION SELECT'.
- Test 2Simulate PostgreSQL COPY PROGRAM Injection Payload
Expected signal: HTTP log entry with decoded filter containing 'COPY' and 'PROGRAM'; if unpatched and role is superuser, PostgreSQL log shows the executed COPY PROGRAM statement and spawned OS process.
- Test 3Validate Patched Version Rejects Injection Payload
Expected signal: HTTP access log entry showing the same injection attempt, but application logs indicate a validation error (400 Bad Request) rather than a raw query execution.
References (6)
- https://github.com/nocobase/nocobase/security/advisories/GHSA-p849-8hwh-84j9
- https://nvd.nist.gov/vuln/detail/CVE-2026-52887
- https://github.com/nocobase/nocobase/pull/9630
- https://github.com/nocobase/nocobase/commit/68d64e3fcfb8be2ae4f3bfc9e1ee3f85b87c89ce
- https://github.com/nocobase/nocobase/releases/tag/v2.0.61
- https://github.com/advisories/GHSA-p849-8hwh-84j9
Unlock playbooks & atomic tests with Pro
Get the full detection package for CVE-2026-52887 — response playbook and atomic red team tests, plus investigation guidance and hunting queries.
df00tech Pro — £29/user/month