Lotus through 0.10.2 SQL Injection via Custom SQL Billable Metrics

{
  "id": "9e96c424a65c27f7902830d9af6ca83302fd9c2ee4a53b1da0cf662dcf4ddf7f",
  "url": "https://osv.dev/vulnerability/CVE-2026-115330",
  "method": "structured",
  "payload": {
    "kind": "advisory",
    "title": "Lotus through 0.10.2 SQL Injection via Custom SQL Billable Metrics",
    "summary": "Lotus through 0.10.2 contains an sql injection vulnerability that allows authenticated organization users to execute arbitrary SQL by appending stacked statements to custom metric queries. Attackers can submit semicolon-separated SQL through POST /app/metrics/, bypassing first-statement-only validation, to read or modify data across all tenants.",
    "evidence": "osv:CVE-2026-115330",
    "products": [],
    "severity": "high",
    "structured": {
      "id": "CVE-2026-115330",
      "aliases": [
        "CVE-2026-115330"
      ],
      "metrics": [
        {
          "type": "CVSS_V4",
          "score": "CVSS:4.0/AV:N/AC:L/AT:N/PR:L/UI:N/VC:H/VI:H/VA:H/SC:N/SI:N/SA:N"
        }
      ],
      "affected": [
        {
          "ranges": [
            {
              "repo": "https://github.com/uselotus/lotus",
              "type": "GIT",
              "events": [
                {
                  "introduced": "0"
                },
                {
                  "last_affected": "f908380b324045f6b160cd3245c5b632e479a63b"
                }
              ],
              "database_specific": {
                "extracted_events": [
                  {
                    "range": [
                      {
                        "introduced": "0"
                      },
                      {
                        "last_affected": "0.10.2"
                      }
                    ],
                    "source": "AFFECTED_FIELD",
                    "strategy": "StandardRange"
                  },
                  {
                    "range": [
                      {
                        "introduced": "0"
                      },
                      {
                        "last_affected": "0.10.2"
                      }
                    ],
                    "source": "DESCRIPTION"
                  }
                ]
              }
            }
          ],
          "versions": [
            "0.10.2",
            "0.10.1",
            "0.10.0",
            "0.9.4",
            "0.9.3",
            "0.9.2",
            "0.9.1",
            "0.9.0"
          ],
          "database_specific": {
            "source": "https://storage.googleapis.com/cve-osv-conversion/osv-output/CVE-2026-115330.json"
          }
        }
      ],
      "modified": "2026-10-28T02:30:34.785151242Z",
      "provider": "osv",
      "references": [
        "https://github.com/CVEProject/cvelistV5/tree/main/cves/2026/115xxx/CVE-2026-115330.json",
        "https://nvd.nist.gov/vuln/detail/CVE-2026-115330",
        "https://www.vulncheck.com/advisories/lotus-through-0.10.2-sql-injection-via-custom-sql-billable-metrics",
        "https://github.com/uselotus/lotus",
        "https://github.com/uselotus/lotus/blob/0.10.2/backend/metering_billing/aggregation/billable_metrics.py#L643-L656",
        "https://hackmd.io/@leediay/BkUc3WL2Mx"
      ],
      "provider_metadata": {
        "cwe_ids": [
          "CWE-89"
        ],
        "cna_assigner": "VulnCheck",
        "osv_generated_from": "https://github.com/CVEProject/cvelistV5/tree/main/cves/2026/115xxx/CVE-2026-115330.json"
      }
    },
    "related_cves": [
      {
        "value": "CVE-2026-115330",
        "evidence": "/id"
      }
    ],
    "security_relevant": true,
    "severity_evidence": "/severity/0/score"
  },
  "source_id": "core-osv",
  "document_id": 502116,
  "published_at": "2026-10-22T10:57:47.428+00:00"
}