SQLBot: RCE via SQL Injection in Excel Upload Endpoint

SQLBot is an intelligent data query system based on a large language model and RAG. Versions prior to 1.7.0 contain a critical SQL Injection vulnerability in the /api/v1/datasource/uploadExcel endpoint that enables Remote Code Execution (RCE), allowing any authenticated user (even the lowest-privileged) to fully compromise the backend server. The root cause is twofold: Excel Sheet names are concatenated directly into PostgreSQL table names without sanitization (datasource.py#L351), and those table names are embedded into COPY SQL statements via f-strings instead of parameterized queries (datasource.py#L385-L388). An attacker can bypass the 31-character Sheet name limit using a two-stage technique—first uploading a normal file whose data rows contain shell commands, then uploading an XML-tampered file whose Sheet name injects a TO PROGRAM 'sh' clause into the SQL. Confirmed impacts include arbitrary command execution as the postgres user (uid=999), sensitive file exfiltration (e.g., /etc/passwd, /etc/shadow), and complete PostgreSQL database takeover. This issue has been fixed in version 1.7.0.

N/A

SQL命令中使用的特殊元素转义处理不恰当(SQL注入)

SQLBot SQL注入漏洞

SQLBot是DataEase开源的一个基于大模型和RAG的智能问数系统。 SQLBot 1.7.0之前版本存在SQL注入漏洞，该漏洞源于Excel工作表名称未经清理直接拼接到PostgreSQL表名中，且表名通过f-string嵌入SQL语句，可能导致SQL注入和远程代码执行。

N/A

N/A