Description
agno 2.6.5 contains a SQL injection vulnerability in the ClickHouse vector database backend that allows attackers to inject arbitrary SQL expressions by supplying malicious metadata keys and values to the delete_by_metadata() method. Attackers can exploit the unsafe f-string interpolation in clickhousedb.py to delete all rows, target specific rows, or extract information through error-based or blind SQL injection techniques.
Problem types
CWE-89 Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')
Product status
Any version
Any version
Any version
Credits
YU SUN
References
github.com/agno-agi/agno/issues/7866
github.com/agno-agi/agno/issues/7866
github.com/agno-agi/agno/pull/7883
github.com/...anges/26a7439b803c0ccc9a58ee53572d8088a678923f
github.com/...anges/a0ec99305e782e68ba26f5966c53ad50b5f40132
www.vulncheck.com/...ction-via-clickhouse-delete-by-metadata