Registry / database / node-red-contrib-orm-db

node-red-contrib-orm-db

library1.0.13jsnpmunverified

A Node-RED node that enables database operations via Sequelize ORM without writing SQL. Supports Oracle, Postgres, MySQL, MariaDB, SQLite, SQL Server, Amazon Redshift, and Snowflake. Current stable version is 1.0.13 targeting Node.js >= 18.0.0. Released on npm and installable via Node-RED Palette Manager. Requires manual installation of database-specific drivers. Differentiator: provides a graphical interface for common operations (find, create, update, delete) plus raw SQL queries with variable replacement, leveraging Sequelize's full ORM capabilities.

database

npm install node-red-contrib-orm-db

github ↗package ↗homepage ↗

INSTALL

IMPORT

SIG · NODE-RED-CONTRIB-O

node-red-contrib-orm-db

databasejavascriptv1.0.13

harness data pending

Install & Compatibility

Where this runs

No compatibility data collected yet for this library.

Code

Verified usage

Verified import paths — ran on the pinned version, not inferred.

Sequelize

✓ const { Sequelize } = require('sequelize');

✗ import { Sequelize } from 'sequelize';

This is a Node-RED node, not a direct library import. The ORM uses Sequelize internally, but you don't import it directly.

node-red-contrib-orm-db

✓ // Install via Node-RED Palette Manager or npm install node-red-contrib-orm-db

No JavaScript import is needed; the node is registered as a Node-RED node.

Install the package via Node-RED Palette or npm, then configure connections and models.

// No direct code usage; install in Node-RED and use the graphical nodes.

Debug

Known issues

gotchaRequires manual installation of database drivers for databases other than SQLite.

fix

Install the required driver package (e.g., `npm install pg pg-hstore` for Postgres).

affects: >=1.0.0

breakingNode.js version must be >= 18.0.0.

fix

Upgrade Node.js to version 18 or later.

affects: >=1.0.0

gotchaRaw queries only support replacements, not bind parameters.

fix

Use `msg.rawQuery` with replacement syntax as defined in Sequelize documentation.

affects: >=1.0.0

Errors

Common errors & fixes

Cannot find module 'pg'

PostgreSQL driver not installed.

fix

Run `npm install pg pg-hstore` in your Node-RED user directory.

Error: Please install sqlite3 package manually

SQLite driver not detected.

fix

Run `npm install sqlite3` even though it's listed as default bundled.

Upgrade

Version history

1.0.13latest on npm

Audit

Dependencies

pgoptionalRequired for PostgreSQL support

mysql2optionalRequired for MySQL support

mariadboptionalRequired for MariaDB support

sqlite3optionalBundled default driver for SQLite

tediousoptionalRequired for Microsoft SQL Server support

oracledboptionalRequired for Oracle Database support

Agent activity

2 hits · last 30 days

node

Resources

githubhttps://github.com/asielh1n1/node-red-contrib-orm-db ↗

packagenode-red-contrib-orm-db ↗

homepagehttps://github.com/asielh1n1/node-red-contrib-orm-db#readme ↗