OpenC3 COSMOS: SQL Injection in QuestDB Time-Series Data Base

{
  "id": "388274fcad75fcbc85051f0ce2d5909ffd9a682086bc34ad4109d1797bbf88f3",
  "url": "https://osv.dev/vulnerability/CVE-2026-42087",
  "method": "structured",
  "payload": {
    "kind": "advisory",
    "title": "OpenC3 COSMOS: SQL Injection in QuestDB Time-Series Data Base",
    "summary": "OpenC3 COSMOS provides the functionality needed to send commands to and receive data from one or more embedded systems. From version 6.7.0 to before version 7.0.0-rc3, a SQL injection vulnerability exists in the Time-Series Database (TSDB) component of COSMOS. The tsdb_lookup function in the cvt_model.rb file directly places user-supplied input into a SQL query without sanitizing the input. As a result, a user can break out of the initial SQL statement and execute arbitrary SQL commands, including deleting data. This issue has been patched in version 7.0.0-rc3.",
    "evidence": "osv:CVE-2026-42087",
    "products": [],
    "severity": "critical",
    "structured": {
      "id": "CVE-2026-42087",
      "aliases": [
        "CVE-2026-42087",
        "GHSA-v529-vhwc-wfc5",
        "PYSEC-2026-2244"
      ],
      "metrics": [
        {
          "type": "CVSS_V3",
          "score": "CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:C/C:H/I:H/A:N"
        }
      ],
      "affected": [
        {
          "ranges": [
            {
              "repo": "https://github.com/openc3/cosmos",
              "type": "GIT",
              "events": [
                {
                  "introduced": "75e3448c0363b457642080e1f9543b6ecca11f03"
                },
                {
                  "fixed": "eb3e364e8f3d5a7ea68fd756625561192d0025f0"
                },
                {
                  "introduced": "132648bad3b202bc5acf4d099d0af2341ec97047"
                },
                {
                  "fixed": "9ba60c09c8836a37a2e4ea67ab35fe403e041415"
                },
                {
                  "fixed": "c3ea3499cc01801122361524f6ccce2fdfbc35f0"
                }
              ],
              "database_specific": {
                "extracted_events": [
                  {
                    "cpe": "cpe:2.3:a:openc3:cosmos:*:*:*:*:open_source:*:*:*",
                    "range": [
                      {
                        "introduced": "6.7.0"
                      },
                      {
                        "fixed": "7.0.0"
                      }
                    ],
                    "source": "CPE_RANGE"
                  },
                  {
                    "cpe": "cpe:2.3:a:openc3:cosmos:7.0.0:rc1:*:*:open_source:*:*:*",
                    "range": [
                      {
                        "introduced": "7.0.0-rc1"
                      },
                      {
                        "last_affected": "7.0.0-rc1"
                      }
                    ],
                    "source": "CPE_STRING"
                  },
                  {
                    "cpe": "cpe:2.3:a:openc3:cosmos:7.0.0:rc2:*:*:open_source:*:*:*",
                    "range": [
                      {
                        "introduced": "7.0.0-rc2"
                      },
                      {
                        "last_affected": "7.0.0-rc2"
                      }
                    ],
                    "source": "CPE_STRING"
                  },
                  {
                    "range": [
                      {
                        "fixed": "9ba60c09c8836a37a2e4ea67ab35fe403e041415"
                      }
                    ],
                    "source": "REFERENCES_COMMIT"
                  },
                  {
                    "range": [
                      {
                        "fixed": "c3ea3499cc01801122361524f6ccce2fdfbc35f0"
                      }
                    ],
                    "source": "REFERENCES_TAG",
                    "original_tag": "v7.0.0-rc3"
                  }
                ]
              }
            }
          ],
          "versions": [
            "7.0.0-rc1",
            "7.0.0-rc2",
            "v7.0.0-rc2",
            "v7.0.0-rc1"
          ],
          "database_specific": {
            "source": "https://storage.googleapis.com/cve-osv-conversion/osv-output/CVE-2026-42087.json"
          }
        }
      ],
      "modified": "2026-10-28T02:30:26.671077703Z",
      "provider": "osv",
      "references": [
        "https://github.com/OpenC3/cosmos/releases/tag/v7.0.0-rc3",
        "https://github.com/CVEProject/cvelistV5/tree/main/cves/2026/42xxx/CVE-2026-42087.json",
        "https://github.com/OpenC3/cosmos/security/advisories/GHSA-v529-vhwc-wfc5",
        "https://nvd.nist.gov/vuln/detail/CVE-2026-42087",
        "https://github.com/OpenC3/cosmos/commit/9ba60c09c8836a37a2e4ea67ab35fe403e041415"
      ],
      "provider_metadata": {
        "cwe_ids": [
          "CWE-89"
        ],
        "cna_assigner": "GitHub_M",
        "osv_generated_from": "https://github.com/CVEProject/cvelistV5/tree/main/cves/2026/42xxx/CVE-2026-42087.json"
      }
    },
    "related_cves": [
      {
        "value": "CVE-2026-42087",
        "evidence": "/id"
      }
    ],
    "security_relevant": true,
    "severity_evidence": "/severity/0/score"
  },
  "source_id": "core-osv",
  "document_id": 493241,
  "published_at": "2026-05-04T17:18:02.965+00:00"
}