Skip to content
OpenAdvisories
Critical · 9.3 CVE-2026-54760 EUVD-2026-42754GHSA-6xc5-4r68-67fcPYSEC-2026-2577

Langroid: SQLChatAgent dangerous-function blocklist can be bypassed with quoted or schema-qualified pg_read_file calls

Published Jul 9, 2026 · Updated Jul 10, 2026 · Assigned by GitHub_M

Description

Langroid is a framework for building large-language-model-powered applications. Prior to version 0.65.1, the `SQLChatAgent` SQL-injection mitigation, with default `allow_dangerous_operations=False`, combines a raw-text regex blocklist (`_DANGEROUS_SQL_PATTERNS`) with a `sqlglot` SELECT-only statement allowlist. The blocklist entries that target callable functions require the function name to be immediately followed by `\s*\(`. PostgreSQL accepts the same call with the name separated from `(` by a quoted identifier, an inline comment, or schema qualification. These forms evade the regex, still parse as `SELECT`, and execute the same PostgreSQL function. This restores the `pg_read_file` server-side file-read primitive that the prior CVE-2026-25879 / GHSA-pmch-g965-grmr fix was meant to block: the parent advisory fixed a missing `pg_read_file` blocklist entry, while this report shows that the added regex is bypassable. Version 0.65.1 fixes the issue.

Affected products

VendorProductAffectedFixed
langroid langroid < 0.65.1 —

Affected packages

EcosystemPackageAffectedFixedRecord
PyPI langroid < 0.65.1 0.65.1 GHSA-6xc5-4r68-67fc

References