Advisory

PYSEC-2026-3049

Also known as: CVE-2026-49360, GHSA-rh62-j648-g5qc

Summary

Recce server has unauthenticated SQL execution that allows local file read/write through DuckDB

Details

Impact
Recce OSS server deployments that expose the server to an untrusted network without authentication are vulnerable to unauthenticated SQL execution through the query run API.

When Recce is configured with a DuckDB-backed project, an attacker can use DuckDB filesystem primitives to read and write files accessible to the Recce server process. The impact depends on how Recce is deployed, but may include disclosure of local files, tampering with Recce/dbt artifacts, modification of browser-served static files leading to stored XSS, and modification of application files if those paths are writable. If Recce is run as root, file access occurs with root privileges inside that host or container.

Patches
This issue has been patched in Recce v1.50.0. Users should upgrade to Recce v1.50.0 or later.

The patch restricts unsafe file read/write behavior for DuckDB-backed query execution and hardens the affected query path. Other warehouse adapters have also been reviewed for similar exposure.

Credits
Thanks to Sitampan (@hxcbtc) for responsibly reporting this issue.

Workarounds
Users who cannot upgrade immediately should avoid exposing recce server to the public internet or any untrusted network.

Recommended mitigations include enabling authentication or placing Recce behind an authenticated reverse proxy/VPN, running Recce as a non-root user, using a read-only application filesystem where possible, and ensuring that sensitive files or credentials are not available to the Recce process.

Severity

Not rated by the source.

Dates

Published
2026-07-13 15:46 UTC
Modified
2026-07-13 16:32 UTC

Affected packages and fixes

recce

PyPI · All systems

Affected

  • introduced 0, fixed 1.50.0 (ecosystem)

Fixed versions

1.50.0

Fix

  • Fixed version 1.50.0
    pip install --upgrade recce==1.50.0

Fix commands are the export's own generic commands. Ojuju never runs them. Check them against your setup first.

Check your own computer: guard packages check

View this record on OSV.dev

Source

Source: PyPA Advisory Database · CC BY 4.0

Sources & licences