Registry / database / sequelize-oracle

sequelize-oracle

JSON →
library3.3.2-0.0jsnpmunverified

sequelize-oracle is a fork of Sequelize v1.7.0 that adds Oracle DML support. Current version 3.3.2-0.0 targets Node >=0.6.21 and supports MySQL, MariaDB, PostgreSQL, SQLite, and Oracle 11G XE. Release cadence is low; the package is outdated compared to the main Sequelize library. Key differentiator: Oracle support, but based on an ancient Sequelize version with no active maintenance. Not recommended for new projects.

database
npm install sequelize-oracle
github ↗package ↗homepage ↗
INSTALL
IMPORT
SIG · SEQUELIZE-ORACLE
S
sequelize-oracle
databasejavascriptv3.3.2-0.0
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
✓ import { Sequelize } from 'sequelize'
✗ const Sequelize = require('sequelize-oracle').Sequelize
Use the original sequelize package for modern projects; sequelize-oracle is a legacy fork with outdated API.
Sequelize
✓ const Sequelize = require('sequelize')
✗ const Sequelize = require('sequelize-oracle');
Only use sequelize-oracle if you specifically need the outdated Oracle fork.
DataTypes
✓ import { DataTypes } from 'sequelize'
✗ var DataTypes = require('sequelize-oracle').DataTypes
DataTypes are available from the same package.

Shows basic ORM usage: define model, sync table, create and query record.

const Sequelize = require('sequelize-oracle'); const sequelize = new Sequelize('database', 'username', 'password', { host: 'localhost', dialect: 'mysql', pool: { max: 5, min: 0, idle: 10000 } }); const User = sequelize.define('user', { firstName: { type: Sequelize.STRING }, lastName: { type: Sequelize.STRING } }); User.sync({ force: true }).then(() => { return User.create({ firstName: 'John', lastName: 'Doe' }); }).then(() => { return User.findAll({ where: { firstName: 'John' } }); }).then(users => { console.log(JSON.stringify(users)); }).catch(err => { console.error('Error:', err); });
Debug
Known issues
deprecatedsequelize-oracle is a fork of a very old sequelize version (1.7.0). It is not maintained and lacks modern features and security updates.
fix
Switch to the official sequelize package for modern, maintained ORM.
affects: >=0.0.0
gotchaOracle support requires the oracledb native driver which may be difficult to install on some systems.
fix
Ensure oracledb prerequisites (Oracle Instant Client, etc.) are installed.
affects: >=0.0.0
gotchaThe API corresponds to Sequelize 1.7.0; many modern libraries and syntax (e.g., async/await, ES modules) are not supported.
fix
Use the original sequelize package and its latest documentation.
affects: >=0.0.0
deprecatedThis package has not been updated since 2017. It may contain unpatched security vulnerabilities.
fix
Migrate to sequelize (latest) or another modern ORM.
affects: >=0.0.0
gotchaTransactions are stated not to work with Oracle (test failure noted).
fix
Avoid transactions if using Oracle dialect, or use a different ORM.
affects: >=0.0.0
Errors
Common errors & fixes
Error: Cannot find module 'oracledb'
Oracle native driver not installed.
fix
npm install oracledb and ensure Oracle client libraries are available.
Dialect 'oracle' is not supported.
Using sequelize-oracle with a dialect string misspelled or unsupported.
fix
Use 'oracle' with correct lowercase; check supported dialects list.
sequelize.sync() does not create tables for Oracle
The fork may have incomplete DDL support for Oracle.
fix
Manually create tables using raw SQL or consider using a different ORM.
Upgrade
Version history
3.3.2-0.0latest on npm
Audit
Dependencies
tediousoptionalRequired for SQL Server support
oracledboptionalRequired for Oracle support
pgoptionalRequired for PostgreSQL
Agent activity
9 hits · last 30 days
node
8
Resources
githubhttps://github.com/lebretr/sequelize-oracle ↗
packagesequelize-oracle ↗
homepagehttps://github.com/lebretr/sequelize-oracle ↗
sequelize-oracle — npm install sequelize-oracle · libregistry