Description
Anyquery is an SQL query engine built on top of SQLite. Prior to 0.4.5, anyquery server exposes file-backed SQLite virtual table modules such as csv_reader and log_reader through its MySQL-compatible server port without authentication, authorization, or directory restrictions. A remote attacker can use SQLite CREATE VIRTUAL TABLE statements to provide a local path to these modules, which use hashicorp/go-getter under the Anyquery server process and return the selected file contents as queryable table rows. The disclosure is limited only by the filesystem permissions of the server process and can expose system configuration, credentials, and private keys. This issue is fixed in version 0.4.5.
Published: 2026-09-14
Score: 7.5 High
EPSS: < 1% Very Low
KEV: No
Impact: Local File Read leading to potential exposure of sensitive files
Action: Patch
AI Analysis

Impact

Anyquery is an SQL engine built on SQLite. In versions prior to 0.4.5 the server exposes file-backed SQLite virtual table modules, notably csv_reader and log_reader, through its MySQL-compatible port without authentication, authorization, or directory restrictions. A remote attacker can issue a CREATE VIRTUAL TABLE statement specifying a local path; the module uses hashicorp/go-getter to read the file and returns its contents as queryable table rows. This capability allows reading any file the Anyquery server process can access, potentially leaking system configuration, credentials, or private keys.

Affected Systems

The issue affects all earlier releases of anyquery from the vendor julien040 whose server exposes the csv_reader and log_reader virtual table modules through the MySQL-compatible port. Versions before 0.4.5 are vulnerable. The problem is limited to server mode running as that vendor’s binaries; client-only usage is unaffected.

Risk and Exploitability

The vulnerability scores 7.5 on CVSS, indicating a high to medium severity. Because the server module is exposed without authentication or authorization, an attacker who can reach the MySQL-compatible port could craft a CREATE VIRTUAL TABLE statement that points to any path accessible by the server process. The EPSS score of less than 1% indicates a very low exploitation probability, but if an attacker has network access to the port the risk remains because the vulnerability is not trivial to exploit and allows extraction of any file the server process can read, including configuration files, credentials, or private keys.

Generated by OpenCVE AI on September 20, 2026 at 22:58 UTC.

Remediation

No solution or workaround provided in the CVE record.

OpenCVE Recommended Actions

  • Upgrade anyquery to version 0.4.5 or newer to remove unrestricted virtual table modules and enable authentication.
  • If an upgrade cannot be performed immediately, disable the virtual table modules by removing them from the server configuration or stopping their use via environment settings.
  • Restrict network access to the MySQL-compatible port can reach the server.

Generated by OpenCVE AI on September 20, 2026 at 22:58 UTC.

Tracking

Sign in to view the affected projects.

Advisories
Source ID Title
Github GHSA Github GHSA GHSA-mf78-3rpf-r784 Anyquery: Local File Read (LFR) via Unrestricted SQLite Virtual Table Modules in Server Mode
History

Thu, 17 Sep 2026 20:30:00 +0000

Type Values Removed Values Added
First Time appeared Julien040
Julien040 anyquery
Vendors & Products Julien040
Julien040 anyquery

Tue, 15 Sep 2026 15:30:00 +0000

Type Values Removed Values Added
Metrics ssvc

{'options': {'Automatable': 'yes', 'Exploitation': 'none', 'Technical Impact': 'partial'}, 'version': '2.0.3'}


Mon, 14 Sep 2026 21:00:00 +0000

Type Values Removed Values Added
Description Anyquery is an SQL query engine built on top of SQLite. Prior to 0.4.5, anyquery server exposes file-backed SQLite virtual table modules such as csv_reader and log_reader through its MySQL-compatible server port without authentication, authorization, or directory restrictions. A remote attacker can use SQLite CREATE VIRTUAL TABLE statements to provide a local path to these modules, which use hashicorp/go-getter under the Anyquery server process and return the selected file contents as queryable table rows. The disclosure is limited only by the filesystem permissions of the server process and can expose system configuration, credentials, and private keys. This issue is fixed in version 0.4.5.
Title Anyquery: Local File Read (LFR) via Unrestricted SQLite Virtual Table Modules in Server Mode
Weaknesses CWE-22
CWE-284
CWE-552
CWE-73
CWE-862
References
Metrics cvssV3_1

{'score': 7.5, 'vector': 'CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:N/A:N'}


Subscriptions

Julien040 Anyquery
cve-icon MITRE

Status: PUBLISHED

Assigner: GitHub_M

Published:

Updated: 2026-09-15T13:55:50.071Z

Reserved: 2026-06-15T20:07:02.185Z

Link: CVE-2026-54629

cve-icon Vulnrichment

Updated: 2026-09-15T13:26:59.472Z

cve-icon NVD

Status : Deferred

Published: 2026-09-14T20:16:46.867

Modified: 2026-09-30T17:51:56.193

Link: CVE-2026-54629

cve-icon Redhat

No data.

cve-icon OpenCVE Enrichment

Updated: 2026-09-20T23:00:07Z

Weaknesses
  • CWE-22

    Improper Limitation of a Pathname to a Restricted Directory ('Path Traversal')

  • CWE-284

    Improper Access Control

  • CWE-552

    Files or Directories Accessible to External Parties

  • CWE-73

    External Control of File Name or Path

  • CWE-862

    Missing Authorization