Goal Reached Thanks to every supporter — we hit 100%!

Goal: 1000 CNY · Raised: 1359 CNY

100%
Buy Us a Coffee

CVE-2026-63224— OpenRemote has authenticated SQL injection in crosstab datapoint exports

Quick assessment

Affected
openremote openremote
Exploitation
No confirmed in-the-wild exploitation; assess based on exposure
Recommended action
Check the vendor advisory and references for a fixed version. If immediate upgrade is impossible, restrict exposure and increase monitoring.

OpenRemote 是一个开源的物联网平台。在 1.26.0 版本之前， （数据点导出）API 在构建用于 （交叉表）的 SQL 语句时，会将“资产名称”（asset name）和“属性名称”（attribute name）直接拼接，生成一个使用 并通过 流式输出的 查询。其中，“资产名称”既作为双引号包裹的列标识符，又作为由固定 定界符包围的分类查询的一部分。然而，仅对字符串上下文中的单引号进行转义，并不能转义标识符中嵌入的双引号，也无法保护该美元定界符（dollar-quote）的边界。因此，任何拥有创建或重

CVSS 7.2 · High
Get alerts for future matching vulnerabilities Log in to subscribe

I. Basic Information for CVE-2026-63224

Vulnerability Information
Have questions about the vulnerability? See if Shenlong's analysis helps!
View Shenlong Deep Dive ↗

Although we use advanced large model technology, its output may still contain inaccurate or outdated information.Shenlong tries to ensure data accuracy, but please verify and judge based on the actual situation.

Vulnerability Title
OpenRemote has authenticated SQL injection in crosstab datapoint exports
Source: CVE Program / CVE List V5
Vulnerability Description
OpenRemote is an open-source internet-of-things platform. Prior to 1.26.0, the `datapoint export` API constructs `CSV crosstab` SQL by concatenating an `asset name` and `attribute name` into a `COPY` query that uses `crosstab` and streams `TO STDOUT`. The `asset name` enters both a double-quoted column identifier and a category query enclosed by the fixed `$cat$` delimiter. Escaping single quotes in one string context does not escape embedded double quotes in identifiers or protect that dollar-quote boundary. An authenticated user permitted to create or rename an asset and read/export datapoints for one of its attributes can store SQL metacharacters in the name and request a `crosstab` export, causing injected SELECT output to be returned in the normal ZIP/CSV response. This enables database exfiltration without direct database or filesystem access or token forgery. In a multi-tenant deployment it can expose other tenants' data if the manager's database role can read shared tables; integrity and availability effects are not established by the demonstrated read primitive. This issue is fixed in version 1.26.0.
Source: CVE Program / CVE List V5
CVSS Information
CVSS:4.0/AV:N/AC:L/AT:N/PR:L/UI:N/VC:H/VI:L/VA:L/SC:N/SI:N/SA:N
Source: CVE Program / CVE List V5
Vulnerability Type
SQL命令中使用的特殊元素转义处理不恰当(SQL注入)
Source: CVE Program / CVE List V5

Affected Products

Vendor Product Affected Versions CPE Subscribe
openremote openremote < 1.26.0 -

II. Public POCs for CVE-2026-63224

# POC Description Source Link Shenlong Link
AI-Generated POC Premium

No public POC found.

Login to generate AI POC

III. Intelligence Information for CVE-2026-63224

请登录查看更多情报信息。

Other References for CVE-2026-63224 (3)

IV. Related Vulnerabilities

Same product: openremote
Same vendor: openremote
Same weakness: CWE-89