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.
Affected products
| Vendor | Product | Affected | Fixed |
|---|---|---|---|
| agno-agi | agno | — | — |
Affected packages
| Ecosystem | Package | Affected | Fixed | Record |
|---|---|---|---|---|
| PyPI | agno | <= 2.6.5 | — | GHSA-82m5-3pcp-hccq |
References
- https://github.com/agno-agi/agno/issues/7866 issue-tracking
- https://github.com/agno-agi/agno/pull/7883 issue-tracking patch
- https://github.com/agno-agi/agno/pull/7883/changes/26a7439b803c0ccc9a58ee53572d8088a678923f issue-tracking patch
- https://github.com/agno-agi/agno/pull/7883/changes/a0ec99305e782e68ba26f5966c53ad50b5f40132 issue-tracking patch
- https://www.vulncheck.com/advisories/agno-sql-injection-via-clickhouse-delete-by-metadata third-party-advisory