Vanna v0.3.4 is vulnerable to SQL injection in its DuckDB integration exposed to its Flask Web APIs. Attackers can inject malicious SQL training data and generate corresponding queries to write arbitrary files on the victim's file system, such as backdoor.php with contents <?php system($_GET[0]); ?>. This can lead to command execution or the creation of backdoors.

References

• https://nvd.nist.gov/vuln/detail/CVE-2024-5827
• https://huntr.com/bounties/e4e64a51-618b-41d0-8f56-1d2146d8825e