# SQLAlchemy is vulnerable to SQL Injection via group_by parameter

Advisory record · `GHSA-38fc-9xqv-7f7q`

- **Identifiers:** `GHSA-38fc-9xqv-7f7q` · `CVE-2019-7548` · `PYSEC-2019-124`
- **State:** Confirmed
- **Severity:** CVSS 7.8 High
- **Critical:** No
- **Weakness (CWE):** [CWE-89](https://cwe.mitre.org/data/definitions/89.html)
- **Tags:** [SQL injection](https://agentprime.io/advisories/tag/sql-injection.md)
- **Published:** 16 Apr 2019
- **Updated:** 28 Oct 2024
- **Reviewed by a person:** No

Published by the GitHub Advisory Database at 16 Apr 2019, 15:50 UTC. agentprime has not analysed this yet, so whether it affects any app is not known.

## Affected packages

- `sqlalchemy` (PyPI): affected `<1.2.19`; fixed in `1.2.19`

## Not analysed yet

We haven’t published our analysis of this Advisory yet. Once a person has reviewed it, this page will say what’s vulnerable, what has to be true for your app to be affected, and how to check.

## Severity and exploitation

- 7.8 High, CVSS 3.0: `CVSS:3.0/AV:L/AC:L/PR:N/UI:R/S:U/C:H/I:H/A:H`, from GitHub Advisory Database

- **CISA KEV:** Not listed.
- **EPSS:** 0.018, the 78th percentile, on 22 Nov 2026: FIRST’s estimate of the chance of exploitation in the next 30 days.

## Timeline

This record came from the full history of the GitHub Advisory Database, published 16 Apr 2019. New records show when each source confirmed them.

## Sources

- [GitHub Advisory Database: GHSA-38fc-9xqv-7f7q](https://github.com/advisories/GHSA-38fc-9xqv-7f7q)
- [OSV: GHSA-38fc-9xqv-7f7q](https://osv.dev/vulnerability/GHSA-38fc-9xqv-7f7q)
- <https://nvd.nist.gov/vuln/detail/CVE-2019-7548>
- <https://github.com/sqlalchemy/sqlalchemy/issues/4481#issuecomment-461204518>
- <https://github.com/sqlalchemy/sqlalchemy/issues/4510>
- <https://access.redhat.com/errata/RHSA-2019:0981>
- <https://access.redhat.com/errata/RHSA-2019:0984>
- <https://github.com/advisories/GHSA-38fc-9xqv-7f7q>
- <https://github.com/no-security/sqlalchemy_test>
- <https://github.com/pypa/advisory-database/tree/main/vulns/sqlalchemy/PYSEC-2019-124.yaml>
- <https://github.com/sqlalchemy/sqlalchemy>
- <https://lists.debian.org/debian-lts-announce/2019/03/msg00020.html>
- <https://lists.debian.org/debian-lts-announce/2021/11/msg00005.html>
- <https://www.oracle.com/security-alerts/cpujan2021.html>

Facts on this page come from the GitHub Advisory Database (CC-BY 4.0), OSV and the other sources listed, as published. We don’t reproduce full advisory descriptions, which can contain exploit code.

## Check whether this affects you

A Match means an installed version is in the affected range above. Most don’t affect the app; agentprime hasn’t analysed this one yet.

- With the agentprime MCP server (<https://api.agentprime.io/mcp>), ask your agent to check the project: `check_lockfile` sends a lockfile, `check_packages` a list of installed packages, and both return the Matches and the upgrades that clear them. `get_advisory` returns this record. Setup: <https://agentprime.io/mcp.md>
- In a browser: <https://agentprime.io/check/> reads your lockfile in the browser, never uploading it.
- Whether it touches your code, with file and line: the Claude Code plugin, <https://agentprime.io/plugin.md>
- As JSON: <https://api.agentprime.io/v1/advisories/GHSA-38fc-9xqv-7f7q>, or `POST https://api.agentprime.io/v1/match` with your packages (<https://agentprime.io/api.md>)

---

The web page: <https://agentprime.io/advisories/GHSA-38fc-9xqv-7f7q/>. Everything for agents: <https://agentprime.io/llms.txt>.
