Open-Source Security Intelligence

Know every vulnerability
before it knows you.

DevGuard continuously monitors your dependencies and alerts you when CVEs like this one affect your stack — with real-time threat intelligence built for developers.

Search

CVE-2023-30552

MediumCVSS 6.5 / 10
Published Apr 18, 2023·Last modified Apr 10, 2026
Affected Components(0)

No affected components available

Description

Archery is an open source SQL audit platform. The Archery project contains multiple SQL injection vulnerabilities, that may allow an attacker to query the connected databases. Affected versions are subject to SQL injection in the sql/instance.py endpoint's describe method. In several cases, user input coming from the tb_name parameter value, the db_name parameter value or the schema_name value in the sql/instance.py describe endpoint is passed to the describe_table methods in given SQL engine implementations, which concatenate user input unsafely into a SQL query and afterwards pass it to the query method of each database engine for execution. Please take into account that in some cases all three parameter values are concatenated, in other only one or two of them. The affected methods are: describe_table in sql/engines/clickhouse.pywhich concatenates input which is passed to execution on the database in the query method in sql/engines/clickhouse.py, describe_table in sql/engines/mssql.py which concatenates input which is passed to execution on the database in the query methods in sql/engines/mssql.py, describe_table in sql/engines/mysql.pywhich concatenates input which is passed to execution on the database in the query method in sql/engines/mysql.py, describe_table in sql/engines/oracle.py which concatenates input which is passed to execution on the database in the query methods in sql/engines/oracle.py, describe_table in sql/engines/pgsql.pywhich concatenates input which is passed to execution on the database in the query methods in sql/engines/pgsql.py, describe_table in sql/engines/phoenix.py which concatenates input which is passed to execution on the database in the query method in sql/engines/phoenix.py. Each of these issues may be mitigated by escaping user input or by using prepared statements when executing SQL queries. This issue is also indexed as GHSL-2022-101.

Risk Scores
Base Score
6.5

The vulnerability can be exploited over the network without needing physical access. It is easy for an attacker to exploit this vulnerability. An attacker needs basic access or low-level privileges. No user interaction is needed for the attacker to exploit this vulnerability. The impact is confined to the system where the vulnerability exists. There is a high impact on the confidentiality of the information.

Threat Intelligence
6.0

Exploitation attempts have been detected. Elevated vigilance and prompt remediation are advised.

EPSS
0.83%

The exploit probability is very low. The vulnerability is unlikely to be exploited in the next 30 days.

Exploit
Not available

We did not find any exploit available. Neither in GitHub repositories nor in the Exploit-Database.

Scan your project

Continuously monitor your dependencies and get alerted when vulnerabilities like this one affect your stack.

Checkout DevGuard