{"id":"CVE-2023-22578","aliases":["EUVD-2023-0694","GHSA-f598-mfpv-gmfx"],"status":"published","title":"Sequalize - Default support for “raw attributes” when using parentheses","description":"Due to improper artibute filtering in the sequalize js library, can a attacker peform SQL injections.","severity":{"version":"3.1","score":10,"vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:C/C:H/I:H/A:H","level":"critical","assessor":"cna","from":"cve"},"epss":{"day":"2026-11-11","score":0.00831,"percentile":0.58014,"model":"v2026.06.15"},"facts":{"in_kev":false,"known_exploited":false,"public_exploit":false,"fix_available":true},"cwes":["CWE-790"],"published":"2023-02-16T14:11:36Z","modified":"2026-10-28T02:30:39Z","fixes":[{"ecosystem":"npm","package":"@sequelize/core","fixed_in":["7.0.0-alpha.20"],"sources":["ghsa","osv"]},{"ecosystem":"npm","package":"sequelize","fixed_in":["6.29.0"],"sources":["ghsa","osv"]}],"affected":[{"source":"ghsa","ecosystem":"npm","package":"@sequelize/core","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"7.0.0-alpha.20"}]}]},{"source":"ghsa","ecosystem":"npm","package":"sequelize","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"6.29.0"}]}]},{"source":"osv","ecosystem":"npm","package":"@sequelize/core","ranges":[{"type":"SEMVER","events":[{"introduced":"0"},{"fixed":"7.0.0-alpha.20"}]}]},{"source":"osv","ecosystem":"npm","package":"sequelize","ranges":[{"type":"SEMVER","events":[{"introduced":"0"},{"fixed":"6.29.0"}]}]}],"products":[{"vendor":"feathers-sequalize","product":"sequelize.js"},{"vendor":"sequelizejs","product":"sequelize"}],"references":[{"url":"https://csirt.divd.nl/CVE-2023-22578","tags":["third-party-advisory","x_transferred","Third Party Advisory","advisory","web"]},{"url":"https://csirt.divd.nl/DIVD-2022-00020/","tags":["related","x_transferred","Third Party Advisory","web"]},{"url":"https://github.com/sequelize/sequelize/security/advisories/GHSA-f598-mfpv-gmfx","tags":["web"]},{"url":"https://nvd.nist.gov/vuln/detail/CVE-2023-22578","tags":["advisory"]},{"url":"https://github.com/sequelize/sequelize/pull/15710","tags":["web"]},{"url":"https://github.com/sequelize/sequelize/discussions/15694","tags":["web"]},{"url":"https://github.com/sequelize/sequelize/releases/tag/v6.29.0","tags":["web"]},{"url":"https://github.com/sequelize/sequelize/releases/tag/v7.0.0-alpha.20","tags":["web"]},{"url":"https://github.com/advisories/GHSA-f598-mfpv-gmfx"},{"url":"https://github.com/CVEProject/cvelistV5/tree/main/cves/2023/22xxx/CVE-2023-22578.json","tags":["advisory"]},{"url":"https://csirt.divd.nl/DIVD-2022-00020","tags":["web"]},{"url":"https://github.com/sequelize/sequelize","tags":["package"]}],"sources":{"cve":[{"id":"CVE-2023-22578","title":"Sequalize - Default support for “raw attributes” when using parentheses","description":"Due to improper artibute filtering in the sequalize js library, can a attacker peform SQL injections.","status":"published","published":"2023-02-16T14:11:36.631Z","modified":"2025-04-01T04:48:17.055Z","cvss":[{"version":"3.1","score":10,"vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:C/C:H/I:H/A:H","level":"critical","assessor":"cna"}],"cwes":["CWE-790"],"updated_at":"2026-11-02T14:35:15.779187Z"}],"euvd":[{"id":"EUVD-2023-0694","description":"Due to improper artibute filtering in the sequalize js library, can a attacker peform SQL injections.","status":"published","published":"2023-02-16T14:11:36Z","modified":"2025-04-01T04:48:17Z","cvss":[{"version":"3.1","score":10,"vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:C/C:H/I:H/A:H","level":"critical"}],"updated_at":"2026-11-02T20:52:46.2495Z"}],"ghsa":[{"id":"GHSA-f598-mfpv-gmfx","title":"Sequelize - Default support for “raw attributes” when using parentheses","description":"### Impact\n\nSequelize 6.28.2 and prior has a dangerous feature where using parentheses in the attribute option would make Sequelize use the string as-is in the SQL\n\n```ts\nUser.findAll({\n  attributes: [\n    ['count(id)', 'count']\n  ]\n});\n```\n\nProduced\n\n```sql\nSELECT count(id) AS \"count\" FROM \"users\"\n```\n\n### Patches\n\nThis feature was deprecated in Sequelize 5, and using it prints a deprecation warning.\n\nThis issue has been patched in [`@sequelize/core@7.0.0.alpha-20`](https://github.com/sequelize/sequelize/pull/15374) and [`sequelize@6.29.0`](https://github.com/sequelize/sequelize/pull/15710). \n\nIn Sequelize 7, it now produces the following:\n\n```sql\nSELECT \"count(id)\" AS \"count\" FROM \"users\"\n```\n\nIn Sequelize 6, it throws an error explaining that we had to introduce a breaking change, and requires the user to explicitly opt-in to either the Sequelize 7 behavior (always escape) or the Sequelize 5 behavior (inline attributes that include `()` without escaping). See https://github.com/sequelize/sequelize/pull/15710 for more information.\n\n### Mitigations\n\nDo not use user-provided content to build your list or attributes. If you do, make sure that attribute in question actually exists on your model by checking that it exists in the `rawAttributes` property of your model first.\n\n---\n\nA discussion thread about this issue is open at https://github.com/sequelize/sequelize/discussions/15694\nCVE: CVE-2023-22578","status":"published","published":"2023-02-24T18:48:49Z","modified":"2023-02-24T18:48:51Z","cvss":[{"version":"3.1","score":10,"vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:C/C:H/I:H/A:H","level":"critical"}],"cwes":["CWE-790"],"updated_at":"2026-11-02T14:36:46.526285Z"}],"nvd":[{"id":"CVE-2023-22578","description":"Due to improper artibute filtering in the sequalize js library, can a attacker peform SQL injections.","status":"published","published":"2023-02-16T15:15:18.16Z","modified":"2026-06-17T05:35:40.01Z","cvss":[{"version":"3.1","score":10,"vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:C/C:H/I:H/A:H","level":"critical","assessor":"secondary"},{"version":"3.1","score":9.8,"vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H","level":"critical","assessor":"primary"}],"cwes":["CWE-790"],"updated_at":"2026-11-02T14:07:46.811196Z"}],"osv":[{"id":"CVE-2023-22578","title":"Sequalize - Default support for “raw attributes” when using parentheses","description":"Due to improper artibute filtering in the sequalize js library, can a attacker peform SQL injections.","status":"published","published":"2023-02-16T14:11:36.631Z","modified":"2026-10-28T02:30:39.554663202Z","cvss":[{"version":"3.1","score":10,"vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:C/C:H/I:H/A:H","level":"critical"}],"cwes":["CWE-790"],"updated_at":"2026-11-02T15:44:30.334753Z"},{"id":"GHSA-f598-mfpv-gmfx","title":"Sequelize - Default support for “raw attributes” when using parentheses","description":"### Impact\n\nSequelize 6.28.2 and prior has a dangerous feature where using parentheses in the attribute option would make Sequelize use the string as-is in the SQL\n\n```ts\nUser.findAll({\n  attributes: [\n    ['count(id)', 'count']\n  ]\n});\n```\n\nProduced\n\n```sql\nSELECT count(id) AS \"count\" FROM \"users\"\n```\n\n### Patches\n\nThis feature was deprecated in Sequelize 5, and using it prints a deprecation warning.\n\nThis issue has been patched in [`@sequelize/core@7.0.0.alpha-20`](https://github.com/sequelize/sequelize/pull/15374) and [`sequelize@6.29.0`](https://github.com/sequelize/sequelize/pull/15710). \n\nIn Sequelize 7, it now produces the following:\n\n```sql\nSELECT \"count(id)\" AS \"count\" FROM \"users\"\n```\n\nIn Sequelize 6, it throws an error explaining that we had to introduce a breaking change, and requires the user to explicitly opt-in to either the Sequelize 7 behavior (always escape) or the Sequelize 5 behavior (inline attributes that include `()` without escaping). See https://github.com/sequelize/sequelize/pull/15710 for more information.\n\n### Mitigations\n\nDo not use user-provided content to build your list or attributes. If you do, make sure that attribute in question actually exists on your model by checking that it exists in the `rawAttributes` property of your model first.\n\n---\n\nA discussion thread about this issue is open at https://github.com/sequelize/sequelize/discussions/15694\nCVE: CVE-2023-22578","status":"published","published":"2023-02-24T18:48:49Z","modified":"2023-11-08T04:11:36.970852Z","cvss":[{"version":"3.1","score":10,"vector":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:C/C:H/I:H/A:H","level":"critical"}],"cwes":["CWE-790"],"updated_at":"2026-11-02T15:46:46.006631Z"}]}}