جزئیات آسیب‌پذیری

SQLBot is an intelligent Text-to-SQL system based on large language models and RAG. Prior to 1.9.0, an authenticated user can supply a crafted sheet["tableName"] value in the Excel datasource configuration submitted through POST /api/v1/datasource/, and SQLBot stores that value without safe identifier handling. When the same datasource is later removed through DELETE /api/v1/datasource/{id}, the stored value is interpolated into datasource cleanup SQL and executed by PostgreSQL. This second-order SQL injection can invoke PostgreSQL COPY TO PROGRAM and execute arbitrary operating-system commands with the privileges of the postgres process inside the SQLBot container. This issue is fixed in version 1.9.0.

• https://github.com/dataease/SQLBot/commit/5d5a92a5266e62da7de4a84ffc8317498497b193 x_refsource_MISC
• https://github.com/dataease/SQLBot/releases/tag/v1.9.0 x_refsource_MISC
• https://github.com/dataease/SQLBot/security/advisories/GHSA-vxwj-843f-9c9g x_refsource_CONFIRM