Affected: langroid

Langroid is a framework for building large-language-model-powered applications. Prior to version 0.63.0, SQLChatAgent executes SQL produced by an LLM, which is influenceable by prompt injection. When configured with a database role that has privileges enabling code execution or filesystem access (e.g., PostgreSQL pg_execute_server_program, MySQL FILE, MSSQL xp_cmdshell), an attacker who can shape the agent's input — including indirectly via data returned to the LLM — can coerce execution of dialect-specific primitives such as `COPY ... FROM PROGRAM`, achieving RCE on the database host. Fixed in v0.63.0 by defaulting SQLChatAgent to a SELECT-only sqlglot-parsed statement allowlist with a dialect-aware dangerous-pattern blocklist; allow_dangerous_operations=True restores the previous unrestricted behavior for trusted deployments.

Affected: PyPI: langroid

# Security Vulnerability Report: Prompt to SQL Injection leading to RCE in latest Langroid

## Affected Scope langroid < 0.63.0

## Vulnerability Description

SQLChatAgent executes SQL produced by an LLM, which is influenceable by prompt injection. When configured with a database role that has privileges enabling code execution or filesystem access (e.g., PostgreSQL pg_execute_server_program, MySQL FILE, MSSQL xp_cmdshell), an attacker who can shape the agent's input — including indirectly via data returned to the LLM — can coerce execution of dialect-specific primitives such as `COPY ... FROM PROGRAM`, achieving RCE on the database host. Fixed in vX.Y by defaulting SQLChatAgent to a SELECT-only sqlglot-parsed statement allowlist with a dialect-aware dangerous-pattern blocklist; allow_dangerous_operations=True restores the previous unrestricted behavior for trusted deployments.

## Reproduction & PoC

This demo can be used to reproduce the vulnerability:

```python """Minimal PostgreSQL Chat Demo using Langroid"""

import base64 import os from langroid.agent.special.sql.sql_chat_agent import SQLChatAgent, SQLChatAgentConfig from langroid.agent.task import Task from langroid.language_models.openai_gpt import OpenAIGPTConfig

# Use personal PostgreSQL connection string DATABASE_URI = "postgresql://postgres:<pass>@localhost:5432/postgres"

# Create SQL Chat Agent config = SQLChatAgentConfig( database_uri=DATABASE_URI, llm=OpenAIGPTConfig( api_base=os.getenv("ba…