Skip to content

CVE-2023-36830 SQLFluff vulnerability for users with access to config file, using `library_path` to call arbitrary python code.

HighCVSS 7.8 EPSS 0.41%
Published
Updated
Exploit status
No public exploit known
CISA SSVC
No known exploitation · automatable: no · technical impact: partial
Technology
UbuntuDebian

Description

SQLFluff is a SQL linter. Prior to version 2.1.2, in environments where untrusted users have access to the config files, there is a potential security vulnerability where those users could use the library_path config value to allow arbitrary python code to be executed via macros. For many users who use SQLFluff in the context of an environment where all users already have fairly escalated privileges, this may not be an issue - however in larger user bases, or where SQLFluff is bundled into another tool where developers still wish to give users access to supply their on rule configuration, this may be an issue.

The 2.1.2 release offers the ability for the library_path argument to be overwritten on the command line by using the --library-path option. This overrides any values provided in the config files and effectively prevents this route of attack for users which have access to the config file, but not to the scripts which call the SQLFluff CLI directly. A similar option is provided for the Python API, where users also have a greater ability to further customise or override configuration as necessary. Unless library_path is explicitly required, SQLFluff maintainers recommend using the option --library-path none when invoking SQLFluff which will disable the library-path option entirely regardless of the options set in the configuration file or via inline config directives. As a workaround, limiting access to - or otherwise validating configuration files before they are ingested by SQLFluff will provides a similar effect and does not require upgrade.

Upgrade path

9 packages: 4 fixed, 5 with no fix yet.

PackageAffectedFixed inStatus
debian/sqlfluff(Debian 12) = 1.4.5-2; = 2.3.5-1; = 3.2.5-1; = 3.2.5-2 +9 more No fix listed No fix yet
ubuntu/sqlfluff(Ubuntu 24.04) = 1.4.5-2; = 2.3.5-1; All versions No fix listed No fix yet
ubuntu/sqlfluff(Ubuntu 25.10) = 3.3.1-1; All versions No fix listed No fix yet
ubuntu/sqlfluff(Ubuntu 26.04) = 3.3.1-1; = 3.4.2-2; = 3.5.0-1; = 3.5.0-1ubuntu1 +2 more No fix listed No fix yet
ubuntu/sqlfluff(Ubuntu 26.10) = 3.5.0-2; All versions No fix listed No fix yet
debian/sqlfluff(Debian 13) < 2.3.5-1 2.3.5-1 Fixed
debian/sqlfluff(Debian 14) < 2.3.5-1 2.3.5-1 Fixed
pypi sqlfluff(PyPI) < 2.1.2; = 0.0.1; = 0.0.2; = 0.0.3 +102 more 2.1.2 Fixed
sqlfluff < 2.1.2; = < 2.1.2 2.1.2 Fixed

Affected products

ProductAffected versionsFixed in
pypi sqlfluff(PyPI) < 2.1.2 2.1.2
pypi sqlfluff(PyPI) = 0.0.1 No fix listed
pypi sqlfluff(PyPI) = 0.0.2 No fix listed
pypi sqlfluff(PyPI) = 0.0.3 No fix listed
pypi sqlfluff(PyPI) = 0.0.4 No fix listed
pypi sqlfluff(PyPI) = 0.0.5 No fix listed
pypi sqlfluff(PyPI) = 0.0.6 No fix listed
pypi sqlfluff(PyPI) = 0.0.7 No fix listed
pypi sqlfluff(PyPI) = 0.0.9 No fix listed
pypi sqlfluff(PyPI) = 0.1.0 No fix listed
pypi sqlfluff(PyPI) = 0.1.1 No fix listed
pypi sqlfluff(PyPI) = 0.1.2 No fix listed
pypi sqlfluff(PyPI) = 0.1.3 No fix listed
pypi sqlfluff(PyPI) = 0.1.4 No fix listed
pypi sqlfluff(PyPI) = 0.1.5 No fix listed
pypi sqlfluff(PyPI) = 0.10.0 No fix listed
pypi sqlfluff(PyPI) = 0.10.1 No fix listed
pypi sqlfluff(PyPI) = 0.11.0 No fix listed
pypi sqlfluff(PyPI) = 0.11.1 No fix listed
pypi sqlfluff(PyPI) = 0.11.2 No fix listed
pypi sqlfluff(PyPI) = 0.12.0 No fix listed
pypi sqlfluff(PyPI) = 0.13.0 No fix listed
pypi sqlfluff(PyPI) = 0.13.1 No fix listed
pypi sqlfluff(PyPI) = 0.13.2 No fix listed
pypi sqlfluff(PyPI) = 0.2.0 No fix listed
Show 111 more
ProductAffected versionsFixed in
pypi sqlfluff(PyPI) = 0.2.1 No fix listed
pypi sqlfluff(PyPI) = 0.2.2 No fix listed
pypi sqlfluff(PyPI) = 0.2.3 No fix listed
pypi sqlfluff(PyPI) = 0.2.4 No fix listed
pypi sqlfluff(PyPI) = 0.3.0 No fix listed
pypi sqlfluff(PyPI) = 0.3.1 No fix listed
pypi sqlfluff(PyPI) = 0.3.2 No fix listed
pypi sqlfluff(PyPI) = 0.3.2.post1 No fix listed
pypi sqlfluff(PyPI) = 0.3.2.post2 No fix listed
pypi sqlfluff(PyPI) = 0.3.3 No fix listed
pypi sqlfluff(PyPI) = 0.3.4 No fix listed
pypi sqlfluff(PyPI) = 0.3.5 No fix listed
pypi sqlfluff(PyPI) = 0.3.6 No fix listed
pypi sqlfluff(PyPI) = 0.4.0 No fix listed
pypi sqlfluff(PyPI) = 0.4.0a1 No fix listed
pypi sqlfluff(PyPI) = 0.4.0a2 No fix listed
pypi sqlfluff(PyPI) = 0.4.0a3 No fix listed
pypi sqlfluff(PyPI) = 0.4.1 No fix listed
pypi sqlfluff(PyPI) = 0.5.0 No fix listed
pypi sqlfluff(PyPI) = 0.5.1 No fix listed
pypi sqlfluff(PyPI) = 0.5.2 No fix listed
pypi sqlfluff(PyPI) = 0.5.3 No fix listed
pypi sqlfluff(PyPI) = 0.5.4 No fix listed
pypi sqlfluff(PyPI) = 0.5.5 No fix listed
pypi sqlfluff(PyPI) = 0.5.6 No fix listed
pypi sqlfluff(PyPI) = 0.6.0 No fix listed
pypi sqlfluff(PyPI) = 0.6.0a1 No fix listed
pypi sqlfluff(PyPI) = 0.6.0a2 No fix listed
pypi sqlfluff(PyPI) = 0.6.1 No fix listed
pypi sqlfluff(PyPI) = 0.6.2 No fix listed
pypi sqlfluff(PyPI) = 0.6.3 No fix listed
pypi sqlfluff(PyPI) = 0.6.4 No fix listed
pypi sqlfluff(PyPI) = 0.6.5 No fix listed
pypi sqlfluff(PyPI) = 0.6.6 No fix listed
pypi sqlfluff(PyPI) = 0.6.7 No fix listed
pypi sqlfluff(PyPI) = 0.6.8 No fix listed
pypi sqlfluff(PyPI) = 0.6.9 No fix listed
pypi sqlfluff(PyPI) = 0.7.0 No fix listed
pypi sqlfluff(PyPI) = 0.7.0a1 No fix listed
pypi sqlfluff(PyPI) = 0.7.0a2 No fix listed
pypi sqlfluff(PyPI) = 0.7.0a3 No fix listed
pypi sqlfluff(PyPI) = 0.7.0a5 No fix listed
pypi sqlfluff(PyPI) = 0.7.0a8 No fix listed
pypi sqlfluff(PyPI) = 0.7.1 No fix listed
pypi sqlfluff(PyPI) = 0.8.0 No fix listed
pypi sqlfluff(PyPI) = 0.8.1 No fix listed
pypi sqlfluff(PyPI) = 0.8.2 No fix listed
pypi sqlfluff(PyPI) = 0.9.0 No fix listed
pypi sqlfluff(PyPI) = 0.9.1 No fix listed
pypi sqlfluff(PyPI) = 0.9.2 No fix listed
pypi sqlfluff(PyPI) = 0.9.3 No fix listed
pypi sqlfluff(PyPI) = 0.9.4 No fix listed
pypi sqlfluff(PyPI) = 1.0.0 No fix listed
pypi sqlfluff(PyPI) = 1.1.0 No fix listed
pypi sqlfluff(PyPI) = 1.2.0 No fix listed
pypi sqlfluff(PyPI) = 1.2.1 No fix listed
pypi sqlfluff(PyPI) = 1.3.0 No fix listed
pypi sqlfluff(PyPI) = 1.3.1 No fix listed
pypi sqlfluff(PyPI) = 1.3.2 No fix listed
pypi sqlfluff(PyPI) = 1.4.0 No fix listed
pypi sqlfluff(PyPI) = 1.4.1 No fix listed
pypi sqlfluff(PyPI) = 1.4.2 No fix listed
pypi sqlfluff(PyPI) = 1.4.3 No fix listed
pypi sqlfluff(PyPI) = 1.4.4 No fix listed
pypi sqlfluff(PyPI) = 1.4.5 No fix listed
pypi sqlfluff(PyPI) = 2.0.0 No fix listed
pypi sqlfluff(PyPI) = 2.0.0a1 No fix listed
pypi sqlfluff(PyPI) = 2.0.0a2 No fix listed
pypi sqlfluff(PyPI) = 2.0.0a3 No fix listed
pypi sqlfluff(PyPI) = 2.0.0a4 No fix listed
pypi sqlfluff(PyPI) = 2.0.0a5 No fix listed
pypi sqlfluff(PyPI) = 2.0.0a6 No fix listed
pypi sqlfluff(PyPI) = 2.0.1 No fix listed
pypi sqlfluff(PyPI) = 2.0.2 No fix listed
pypi sqlfluff(PyPI) = 2.0.3 No fix listed
pypi sqlfluff(PyPI) = 2.0.4 No fix listed
pypi sqlfluff(PyPI) = 2.0.5 No fix listed
pypi sqlfluff(PyPI) = 2.0.6 No fix listed
pypi sqlfluff(PyPI) = 2.0.7 No fix listed
pypi sqlfluff(PyPI) = 2.1.0 No fix listed
pypi sqlfluff(PyPI) = 2.1.1 No fix listed
debian/sqlfluff(Debian:12) All versions No fix listed
debian/sqlfluff(Debian:12) = 1.4.5-2 No fix listed
debian/sqlfluff(Debian:12) = 2.3.5-1 No fix listed
debian/sqlfluff(Debian:12) = 3.2.5-1 No fix listed
debian/sqlfluff(Debian:12) = 3.2.5-2 No fix listed
debian/sqlfluff(Debian:12) = 3.3.0-1 No fix listed
debian/sqlfluff(Debian:12) = 3.3.1-1 No fix listed
debian/sqlfluff(Debian:12) = 3.4.2-1 No fix listed
debian/sqlfluff(Debian:12) = 3.4.2-2 No fix listed
debian/sqlfluff(Debian:12) = 3.5.0-1 No fix listed
debian/sqlfluff(Debian:12) = 3.5.0-2 No fix listed
debian/sqlfluff(Debian:12) = 4.3.0-1 No fix listed
debian/sqlfluff(Debian:12) = 4.3.0-2 No fix listed
debian/sqlfluff(Debian:13) < 2.3.5-1 2.3.5-1
debian/sqlfluff(Debian:14) < 2.3.5-1 2.3.5-1
sqlfluff = < 2.1.2 No fix listed
sqlfluff < 2.1.2 2.1.2
ubuntu/sqlfluff(Ubuntu:24.04) All versions No fix listed
ubuntu/sqlfluff(Ubuntu:26.04) All versions No fix listed
ubuntu/sqlfluff(Ubuntu:26.10) All versions No fix listed
ubuntu/sqlfluff(Ubuntu:24.04) = 1.4.5-2 No fix listed
ubuntu/sqlfluff(Ubuntu:24.04) = 2.3.5-1 No fix listed
ubuntu/sqlfluff(Ubuntu:25.10) All versions No fix listed
ubuntu/sqlfluff(Ubuntu:25.10) = 3.3.1-1 No fix listed
ubuntu/sqlfluff(Ubuntu:26.10) = 3.5.0-2 No fix listed
ubuntu/sqlfluff(Ubuntu:26.04) = 3.3.1-1 No fix listed
ubuntu/sqlfluff(Ubuntu:26.04) = 3.4.2-2 No fix listed
ubuntu/sqlfluff(Ubuntu:26.04) = 3.5.0-1 No fix listed
ubuntu/sqlfluff(Ubuntu:26.04) = 3.5.0-1ubuntu1 No fix listed
ubuntu/sqlfluff(Ubuntu:26.04) = 3.5.0-2 No fix listed

References