Read the docs
TI-2023-14391 Aliases CVE-2023-30556

SQL injection in sql_optimize.py optimize_sqltuningadvisor method in Archery - GHSL-2022-107

Priority MEDIUM 62CWE-89Published · Updated

Key facts

Attack vector
Network
Privileges required
Low
User interaction
None
Attack complexity
Low
Impact type
SQL injection
Confidentiality · integrity · availability
High · None · None
Fix status
No fix listed

Attack profile from CVSS 3.1 · CNA. Fix status from CNA. Impact type from CWE-89.

Summary

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 `optimize_sqltuningadvisor` method of `sql_optimize.py`. User input coming from the `db_name` parameter value in `sql_optimize.py` is passed to the `sqltuningadvisor` method in `oracle.py`for execution. To mitigate escape the variables accepted via user input when used in `sql_optimize.py`. Users may also use prepared statements when dealing with SQL as a mitigation for this issue. This issue is also indexed as `GHSL-2022-107`.

Why it matters now

Exploitation Proof of concept CISA SSVC · not in CISA KEV
EPSS 0.00842 58th percentileScored 2026-11-07
Public exploit Yes 1 exploit referenceTagged by NVD
Fix No fix listed No fixed version in the sources yet

SSVC decision points

CISA ADP · SSVC 2.0.3

Exploitation
Poc
Automatable
No
Technical impact
Partial

The decision (Track, Attend, Act) also depends on your mission and well-being impact; see CISA's SSVC guide.

Affected products

VendorProductAffected versionsFixed inStatusSource
hhyoArcheryup to 1.9.0—No fix listedCNA
  • Archery Vendorhhyo Affected up to 1.9.0 Fixed in — No fix listed CNA

CPE configurations NVD · 1

CPEVersionsRoleVendor
cpe:2.3:a:archerydms:archery:1.9.0:*:*:*:*:*:*:*1.9.0Vulnerablehhyo
  • cpe:2.3:a:archerydms:archery:1.9.0:*:*:*:*:*:*:* Versions 1.9.0 Vulnerable ·hhyo

Remediation

No fixed version listed by the sources yet.

Timeline

  1. 2026-10-02 Threatist record created from CVE-2023-30556

References

Exploit 1

  • TI-2023-14421 Multiple SQL injections in sql/instance.py param_edit method in Archery - GHSL-2022-104 CVSS 3.1MEDIUM 6.5
  • TI-2022-18131 Archery v1.8.3 to v1.8.5 was discovered to contain multiple SQL injection vulnerabilities… CVSS 3.1CRITICAL 9.8
  • TI-2022-18132 Archery v1.4.0 to v1.8.5 was discovered to contain a SQL injection vulnerability via the… CVSS 3.1CRITICAL 9.8
  • TI-2022-18130 Archery v1.4.0 to v1.8.5 was discovered to contain a SQL injection vulnerability via the… CVSS 3.1CRITICAL 9.8
  • TI-2022-18129 Archery v1.7.5 to v1.8.5 was discovered to contain a SQL injection vulnerability via the… CVSS 3.1CRITICAL 9.8
  • TI-2022-18128 Archery v1.7.0 to v1.8.5 was discovered to contain a SQL injection vulnerability via the… CVSS 3.1CRITICAL 9.8
See all 14 →

Sources

This product uses the NVD API but is not endorsed or certified by the NVD. Sources and licences