# Matrix-appservice-irc vulnerable to sql injection via roomIds argument

Advisory record · `GHSA-ffwf-47x2-jpr8`

- **Identifiers:** `GHSA-ffwf-47x2-jpr8` · `CVE-2022-3971`
- **State:** Confirmed
- **Severity:** CVSS 4.6 Medium
- **Critical:** No
- **Weakness (CWE):** [CWE-89](https://cwe.mitre.org/data/definitions/89.html) · [CWE-707](https://cwe.mitre.org/data/definitions/707.html)
- **Tags:** [SQL injection](https://agentprime.io/advisories/tag/sql-injection.md) · [CWE-707](https://agentprime.io/advisories/tag/cwe-707.md)
- **Published:** 13 Nov 2022
- **Updated:** 8 Nov 2023
- **Reviewed by a person:** No

Published by the GitHub Advisory Database at 13 Nov 2022, 12:00 UTC. agentprime has not analysed this yet, so whether it affects any app is not known.

## Affected packages

- `matrix-appservice-irc` (npm): affected `<0.36.0`; fixed in `0.36.0`

## 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

- 4.6 Medium, CVSS 3.1: `CVSS:3.1/AV:A/AC:H/PR:L/UI:N/S:U/C:L/I:L/A:L`, from CNA (VulDB)

- **CISA KEV:** Not listed.
- **EPSS:** 0.0057, the 47th percentile, on 7 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 13 Nov 2022. New records show when each source confirmed them.

## Sources

- [GitHub Advisory Database: GHSA-ffwf-47x2-jpr8](https://github.com/advisories/GHSA-ffwf-47x2-jpr8)
- [OSV: GHSA-ffwf-47x2-jpr8](https://osv.dev/vulnerability/GHSA-ffwf-47x2-jpr8)
- <https://nvd.nist.gov/vuln/detail/CVE-2022-3971>
- <https://github.com/matrix-org/matrix-appservice-irc/pull/1619>
- <https://github.com/matrix-org/matrix-appservice-irc/commit/179313a37f06b298150edba3e2b0e5a73c1415e7>
- <https://github.com/matrix-org/matrix-appservice-irc>
- <https://github.com/matrix-org/matrix-appservice-irc/releases/tag/0.36.0>
- <https://vuldb.com/?id.213550>

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-ffwf-47x2-jpr8>, or `POST https://api.agentprime.io/v1/match` with your packages (<https://agentprime.io/api.md>)

---

The web page: <https://agentprime.io/advisories/GHSA-ffwf-47x2-jpr8/>. Everything for agents: <https://agentprime.io/llms.txt>.