CVE-2024-7764

Summary

Vanna-ai v0.6.2 is vulnerable to SQL Injection due to insufficient protection against injecting additional SQL commands from user requests. The vulnerability occurs when the generate_sql function calls extract_sql with the LLM response. An attacker can include a semi-colon between a search data field and their own command, causing the extract_sql function to remove all LLM generated SQL and execute the attacker's command if it passes the is_sql_valid function. This allows the execution of user-defined SQL beyond the expected boundaries, notably the trained schema.

Affected Software

VendorProductVersion RangeStatus
vanna-aivanna-ai/vannaunspecified <= latestaffected

Weaknesses

  • CWE-89: CWE-89 Improper Neutralization of Special Elements used in an SQL Command

ADP Enrichment

CISA ADP Vulnrichment

  • SSVC:
  • Exploitation: poc
    • Automatable: no
    • Technical Impact: total

References