n8n Vulnerable to SQL Injection in Data Table Node via orderByColumn Expression
n8n is an open source workflow automation platform. Prior to versions 2.14.1, 2.13.3, and 1.123.26, an authenticated user with permission to create or modify workflows could exploit a SQL injection vulnerability in the Data Table Get node. On default SQLite DB, single statements can be manipulated and the attack surface is practically limited. On PostgreSQL deployments, multi-statement execution is possible, enabling data modification and deletion. The issue has been fixed in n8n versions 1.123.26, 2.13.3, and 2.14.1. Users should upgrade to one of these versions or later to remediate the vulnerability. If upgrading is not immediately possible, administrators should consider the following temporary mitigations: Limit workflow creation and editing permissions to fully trusted users only, disable the Data Table node by adding `n8n-nodes-base.dataTable` to the `NODES_EXCLUDE` environment variable, and/or review existing workflows for Data Table Get nodes where `orderByColumn` is set to an expression that incorporates external or user-supplied input. These workarounds do not fully remediate the risk and should only be used as short-term mitigation measures.
References
-
https://github.com/n8n-io/n8n/security/advisories/GHSA-98c2-4cr3-4jc3 x_refsource_CONFIRM
Affected products
- === 2.14.0
- ==< 1.123.26
- ==>= 2.0.0-rc.0, < 2.13.3
Matching in nixpkgs
pkgs.n8n
Free and source-available fair-code licensed workflow automation tool
pkgs.n8n-nodes-carbonejs
n8n community node for rendering Word templates using Carbone.js
pkgs.n8n-nodes-evolution-api
Evolution API hub for WhatsApp integration with n8n
pkgs.n8n-task-runner-launcher
Launcher for n8n task runners
Package maintainers
-
@gepbird Gutyina Gergő <gutyina.gergo.2@gmail.com>
-
@sweenu sweenu <contact@sweenu.xyz>
-
@vitorpavani Vitor Pavan <vipavani@hotmail.com>