What is GHSA-8prr-286p-4w7j?

GHSA-8prr-286p-4w7j is a security advisory published by GitHub Security Advisories with Medium severity. alerta-server has potential SQL Injection vulnerability in Query String Syntax (q=) API

Which CVE IDs does GHSA-8prr-286p-4w7j cover?

GHSA-8prr-286p-4w7j covers the following CVE IDs: CVE-2026-34400. Each CVE has its own detail page on EchelonGraph Pulse with the synthesized EG score.

Which products are affected by GHSA-8prr-286p-4w7j?

GHSA-8prr-286p-4w7j affects 1 product, including: pip/alerta-server:\u003c 9.1.0.

GHSA-8prr-286p-4w7jMedium

alerta-server has potential SQL Injection vulnerability in Query String Syntax (q=) API

Vendor

GitHub Security Advisories

Published

March 31, 2026

Last Modified

April 6, 2026

🔗 CVE IDs covered (1)

CVE-2026-34400 →

📋 Description

Impact

The Query string search API (q=) was vulnerable to SQL injection via the Postgres query parser, which built WHERE clauses by interpolating user-supplied search terms directly into SQL strings via f-strings.

Patches

Fixed in v9.1.0. The Postgres query parser now uses parameterized queries with %(name)s placeholders passed to psycopg2's cursor.execute(), preventing SQL injection through the ?q= parameter. The MongoDB backend was not affected.

Workarounds

Upgrade to v9.1.0 or later. If unable to upgrade, deploy a proxy in front of the Alerta API to sanitize the q= parameter.

Resources

https://github.com/alerta/alerta/pull/712/files https://owasp.org/www-community/attacks/SQL_Injection

🎯 Affected products1

pip/alerta-server:< 9.1.0