GHSA-5QPP-PQWW-H7FP
SQL Injection in the Microsoft SQL Node via Expression Interpolation into the Query Field
CVSS:4.0/AV:N/AC:L/AT:P/PR:N/UI:N/VC:L/VI:N/VA:N/SC:H/SI:H/SA:L
Fuente: GitHub
Ciclo de vida de la vulnerabilidad
| Fecha | Fase | Evento | Detalle |
|---|---|---|---|
| Divulgación | Publicada | GHSA-5QPP-PQWW-H7FP divulgada · CVSS 7 (GitHub) | |
| Remediación | Parche 2.42.1 | n8n · 0 d desde divulgación | |
| Monitoreo | Detectada | Ingresó al índice | |
| Monitoreo | Verificada | Última verificación contra las fuentes |
Impact
Version 1 of the Microsoft SQL node resolves an expression in the Query field by substituting the value into the SQL text and executing the result, with no parameterisation. Where a workflow binds untrusted input into that field, an external caller can execute arbitrary SQL against the connected database with the stored credential's privileges.
Patches
The issue has been fixed in n8n versions 2.42.1 and 2.41.4. Users should upgrade to one of these versions or later to remediate the vulnerability.
Workarounds
If upgrading is not immediately possible, administrators should consider the following temporary mitigations:
- Restrict n8n instance access to fully trusted users only.
- Audit all workflows using the Microsoft SQL node and ensure that the Query field is not bound to expressions referencing untrusted external input such as webhook or HTTP request fields.
- Deactivate webhook-triggered workflows that pass external input into a Microsoft SQL node's Query field until the instance is patched.
- Where the node must remain in use, upgrade the node to typeVersion 1.1 or later by removing and re-adding it, then move dynamic values into the Query Parameters option and reference them as positional parameters.
Desglose de métricas
Rangos afectados
Estado del parche por paquete
| Paquete / producto | Estado | Corregida en | Desde divulgación | Última versión |
|---|---|---|---|---|
npmn8n |
Corregida | 2.42.1 | 0 d | 2.47.7 no afectada |
2.41.42.42.1Arsenal público
Sin exploits, módulos ni PoC públicos conocidos a la fecha de verificación.
https://github.com/n8n-io/n8n/security/advisories/GHSA-5qpp-pqww-h7fpLas referencias externas se muestran para copiar: cve.llama.ec no lo redirige a otros sitios.
