CVE-2024-24811 — Vulnerability in products-sqlalchemyda — CVE Details
CRITICAL
SQLAlchemyDA unauthenticated arbitrary SQL query execution
Published June 29, 2026Updated July 1, 2026Source: osv
Summary
### Impact
The vulnerability allows unauthenticated execution of arbitrary SQL statements on the database the SQLAlchemyDA instance is connected to. All users are affected.
### Patches
The problem has been patched in version 2.2.
### Workarounds
There is no workaround. All users are urged to upgrade to version 2.2
Advisory Timeline
- First published June 29, 2026 (105 days ago).
- Last revised July 1, 2026 — 2 days after initial publication.
Remediation
Upgrade to the fixed version using your package manager.
pip
Update products-sqlalchemyda to 2.2 or laterpip install "products-sqlalchemyda>=2.2"
After upgrading, run your dependency scanner again to confirm the vulnerability is resolved.
Affected Packages (1)
Affects 1 ecosystem: pypi (1).
| Package | Ecosystem | Affected | Fixed In |
|---|---|---|---|
| products-sqlalchemyda | pypi | 0.4.0, 0.4.1, 0.5.0, 0.5.1 (+16 more) | 2.2 |
CVSS Score Breakdown
What the CVSS (Common Vulnerability Scoring System) 9.8 score means for each attack dimension.
Attack Vector
Network
Attack Complexity
Low
Privileges Required
None
User Interaction
None
Scope
Unchanged
Confidentiality
High
Integrity
High
Availability
High
CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H
References
- https://github.com/zopefoundation/Products.SQLAlchemyDA/security/advisories/GHSA-r3jc-3qmm-w3pwWEB
- https://nvd.nist.gov/vuln/detail/CVE-2024-24811ADVISORY
- https://github.com/zopefoundation/Products.SQLAlchemyDA/commit/e682b99f8406f20bc3f0f2c77153ed7345fd215aWEB
- https://github.com/zopefoundation/Products.SQLAlchemyDAPACKAGE
- https://pypi.org/project/products-sqlalchemydaPACKAGE
- https://github.com/advisories/GHSA-r3jc-3qmm-w3pwADVISORY
Frequently Asked Questions
- What is CVE-2024-24811?
- SQLAlchemyDA unauthenticated arbitrary SQL query execution This vulnerability has been assigned a severity rating of CRITICAL (CVSS score: 9.8/10).
- How do I check if my project is affected by CVE-2024-24811?
- CVE-2024-24811 affects products-sqlalchemyda. Use GeekWala's free vulnerability scanner to check your dependencies against CVE-2024-24811 and 200,000+ other known vulnerabilities.
Severity & Exploitability
CVSS Score
9.8
Exploitation is straightforward and causes maximum impact. Patch immediately.
Also Known As
PYSEC-2026-489
GHSA-r3jc-3qmm-w3pw
Related CVEs
- CVE-2026-61447CRITICAL
PraisonAI: CodeAgent Executes LLM-Generated Code Without Sandboxing and Leaks All Environment Secrets
- CVE-2026-61445CRITICAL
PraisonAI: AICoder Arbitrary File Write and Command Execution via LLM Tool Calls
Check if you're affected
Scan your dependencies to see if this vulnerability affects your projects.
Scan Your Dependencies