Lotus: SQL injection via subscription filter keys
Summary
Lotus, an open-source pricing and billing platform, contains an SQL injection flaw (CWE-89) in how subscription filter keys are validated. An authenticated user of an organization can register crafted filter keys that pass the keyword-only validation and are inserted unquoted into usage aggregation queries. An attacker can read or manipulate data in the database shared across tenants, which may affect other tenants. The CNA rates the issue CVSS 4.0 8.7 (High); NVD has not yet published its own score.
Affected
- Uselotus Lotus up to and including 0.10.2
Fixed in
Unknown. No fixed version is listed in the sources. Check the repository for newer releases.
Workaround
- No vendor workaround published.
- Restrict who can self-register or join organizations.
- Review subscription records for unusual filter keys.
- Limit the database privileges of the application account and keep the database off external networks.
Exploitation
- No exploitation in the wild reported; not listed in CISA KEV.
- The CISA SSVC assessment in the CNA record lists exploitation as 'poc' (proof of concept) and automatable as 'no'.
- No public exploit code was confirmed in the research sources.
Our recommendation
- Identify all Lotus instances, including self-hosted ones, and their exact versions.
- Treat version 0.10.2 and earlier as high priority, especially with open registration or internet exposure.
- Apply the vendor fix once published and monitor the repository for new releases.
- Apply the workarounds above now.
- Review the related CVEs for this product together.
Public exploits
PoC-in-GitHub, Metasploit and Exploit-DB list nothing for this CVE.
Research sources
- VulnCheck advisory: Lotus through 0.10.2 SQL injection via subscription filter keys www.vulncheck.com
- Lotus GitHub repository github.com
- Vulnerable code at tag 0.10.2 (model_serializers.py) github.com
- Researcher write-up (HackMD) hackmd.io
- VulDB entry 425285 vuldb.com
Researched and written up in English and German by an AI (Claude by Anthropic) based on NVD, CISA, EPSS and the sources listed. The vendor information is authoritative. Researched on 1 Nov 2026, 00:45.
Original description (NVD)
Lotus through 0.10.2 contains an sql injection vulnerability that allows authenticated organization users to inject SQL by registering crafted subscription_filter_keys that bypass keyword-only validation. Attackers can create subscriptions using the malicious key, which is rendered as an unquoted group-by identifier, to inject SQL into usage aggregation queries against the shared multi-tenant database.
NVD references (5)
- https://github.com/uselotus/lotus
- https://github.com/uselotus/lotus/blob/0.10.2/backend/metering_billing/serializers/model_serializers.py#L518-…
- https://hackmd.io/@leediay/BkUc3WL2Mx
- https://www.vulncheck.com/advisories/lotus-through-0.10.2-sql-injection-via-subscription-filter-keys
- https://hackmd.io/@leediay/BkUc3WL2Mx
Sources
The tracker combines official, freely usable data sources – updated continuously:
- NVD (NIST) – CVEs, rating (CVSS), affected products
- CISA KEV – vulnerabilities confirmed by CISA as actively exploited
- CISA Vulnrichment – CISA assessment (SSVC) in the official CVE record
- FIRST EPSS – probability of exploitation
- Microsoft MSRC – Patch Tuesday: vulnerabilities, severity, updates
- PoC-in-GitHub – public proof-of-concept repositories
- Metasploit (Rapid7) – modules of the Metasploit Framework
- Exploit-DB (OffSec) – archive of public exploits (links only)
- Patch days: official vendor pages (linked per vendor) (Vendor patch days)
This product uses data from the NVD API but is not endorsed or certified by the NVD. EPSS data © FIRST.org.
Affected? We can help.
We check whether your systems are affected, install updates and close the gap – continuously with the System Health Checker if you wish.