Back to Labs
Security Advisory

CVE-2023-30605

About

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. User input coming from the `variable_name` and `variable_value` parameter value in the `sql/instance.py` `param_edit` endpoint is passed to a set of 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. The affected methods are: `set_variable` in `sql/engines/goinception.py` which concatenates input which is passed to execution on the database in the `sql/engines/goinception.py`, `get_variables` in `sql/engines/goinception.py` which concatenates input which is passed to execution on the database in the `sql/engines/goinception.py`, `set_variable` in `sql/engines/mysql.py` which concatenates input which is passed to execution on the database in the `sql/engines/mysql.py` `query`, and `get_variables` in `sql/engines/mysql.py`which concatenates input which is passed to execution on the database in the `sql/engines/mysql.py` `query`. Each of these issues may be mitigated by escaping user input or by using prepared statements when executing SQL queries. This advisory is also indexed as `GHSL-2022-104`.

Weakness (CWE):CWE-89

Rainforest analyst review

Archery, an open-source SQL audit platform, has multiple SQL injections where the variable_name and variable_value parameters in the param_edit endpoint (sql/instance.py) are concatenated unsafely into queries by set_variable and get_variables in the MySQL and goInception engine code. With the required low-privilege account, an attacker can use these to query the databases Archery is connected to. The impact is confidentiality-oriented, and the CWE-89 root cause is textbook unsanitized concatenation.

The sharp edge here is what Archery is: an audit platform sits astride the databases it manages, so an injection in it is a pivot into potentially many connected backends rather than a single app's data. That said, it requires an authenticated account and it is an internal tooling platform, not an internet-exposed mass target, so the realistic threat is a low-privileged insider or a stolen tool credential abusing that central position.

Our angle is who holds accounts and how tightly Archery's own database connections are scoped. We would enumerate Archery users, restrict access to the platform to trusted operators, and review the privileges of the service accounts Archery uses to reach each connected database, because narrowing those permissions limits what a successful injection can actually pull. Patching to a fixed version plus least-privilege on the downstream connections is the combination that shrinks this.

References

Related CVEs

Frequently asked questions

What is CVE-2023-30605?

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.

How severe is CVE-2023-30605?

CVE-2023-30605 carries a CVSS 3.1 base score of 6.5, rated medium. On the Rainforest Risk Index — which weighs the severity alongside how easy the flaw is to reach and how broad its impact is — it scores 65 out of 100, in the elevated band.

How is CVE-2023-30605 exploited?

According to the CVSS vector (CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:N/A:N): attack vector Network, attack complexity Low, privileges required Low, user interaction None. Impact on confidentiality High, integrity None and availability None.

Which products are affected by CVE-2023-30605?

Public advisories list the following as affected: archery. Check the references on this page for the exact versions each vendor confirms.

How do I fix CVE-2023-30605?

Apply the fix the vendor published — the references on this page link to the primary advisories and patches. When patching can't happen right away, reduce the exposure of the affected component and watch it for exploitation attempts. Rainforest customers see this vulnerability correlated to their own assets and prioritized by real exposure, not by score alone.

Empower Your Security Strategy with Rainforest

Discover vulnerabilities early, prioritize critical threats, and protect what truly matters. Rainforest streamlines your security operations, saving you time and reducing costs, so you can focus on what drives your business forward.

Share this:LinkedInX Email