{"id":41949,"library":"sequelize-oracle","title":"Sequelize Oracle","description":"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.","status":"deprecated","version":"3.3.2-0.0","language":"javascript","source_language":"en","source_url":"https://github.com/lebretr/sequelize-oracle","tags":["javascript","mysql","sqlite","postgresql","postgres","mssql","orm","nodejs","object relational mapper"],"install":[{"cmd":"npm install sequelize-oracle","lang":"bash","label":"npm"},{"cmd":"yarn add sequelize-oracle","lang":"bash","label":"yarn"},{"cmd":"pnpm add sequelize-oracle","lang":"bash","label":"pnpm"}],"dependencies":[{"reason":"Required for SQL Server support","package":"tedious","optional":true},{"reason":"Required for Oracle support","package":"oracledb","optional":true},{"reason":"Required for PostgreSQL","package":"pg","optional":true}],"imports":[{"note":"Use the original sequelize package for modern projects; sequelize-oracle is a legacy fork with outdated API.","wrong":"const Sequelize = require('sequelize-oracle').Sequelize","symbol":"Sequelize","correct":"import { Sequelize } from 'sequelize'"},{"note":"Only use sequelize-oracle if you specifically need the outdated Oracle fork.","wrong":"const Sequelize = require('sequelize-oracle');","symbol":"Sequelize","correct":"const Sequelize = require('sequelize')"},{"note":"DataTypes are available from the same package.","wrong":"var DataTypes = require('sequelize-oracle').DataTypes","symbol":"DataTypes","correct":"import { DataTypes } from 'sequelize'"}],"quickstart":{"code":"const Sequelize = require('sequelize-oracle');\nconst sequelize = new Sequelize('database', 'username', 'password', {\n  host: 'localhost',\n  dialect: 'mysql',\n  pool: {\n    max: 5,\n    min: 0,\n    idle: 10000\n  }\n});\nconst User = sequelize.define('user', {\n  firstName: { type: Sequelize.STRING },\n  lastName: { type: Sequelize.STRING }\n});\nUser.sync({ force: true }).then(() => {\n  return User.create({ firstName: 'John', lastName: 'Doe' });\n}).then(() => {\n  return User.findAll({ where: { firstName: 'John' } });\n}).then(users => {\n  console.log(JSON.stringify(users));\n}).catch(err => {\n  console.error('Error:', err);\n});","lang":"javascript","description":"Shows basic ORM usage: define model, sync table, create and query record."},"warnings":[{"fix":"Switch to the official sequelize package for modern, maintained ORM.","message":"sequelize-oracle is a fork of a very old sequelize version (1.7.0). It is not maintained and lacks modern features and security updates.","severity":"deprecated","affected_versions":">=0.0.0"},{"fix":"Ensure oracledb prerequisites (Oracle Instant Client, etc.) are installed.","message":"Oracle support requires the oracledb native driver which may be difficult to install on some systems.","severity":"gotcha","affected_versions":">=0.0.0"},{"fix":"Use the original sequelize package and its latest documentation.","message":"The API corresponds to Sequelize 1.7.0; many modern libraries and syntax (e.g., async/await, ES modules) are not supported.","severity":"gotcha","affected_versions":">=0.0.0"},{"fix":"Migrate to sequelize (latest) or another modern ORM.","message":"This package has not been updated since 2017. It may contain unpatched security vulnerabilities.","severity":"deprecated","affected_versions":">=0.0.0"},{"fix":"Avoid transactions if using Oracle dialect, or use a different ORM.","message":"Transactions are stated not to work with Oracle (test failure noted).","severity":"gotcha","affected_versions":">=0.0.0"}],"env_vars":null,"search_vec":"'-0.0':20 '0.6.21':23 '11g':32 '3.3.2':19 'activ':61 'add':13 'ancient':56 'base':53 'cadenc':35 'compar':42 'current':17 'differenti':49 'dml':15 'fork':8 'javascript':68 'key':48 'librari':47 'low':37 'main':45 'mainten':62 'mapper':78 'mariadb':27 'mssql':73 'mysql':26,69 'new':66 'node':22 'nodej':75 'object':76 'oracl':2,5,14,31,50 'orm':74 'outdat':41 'packag':39 'postgr':72 'postgresql':28,71 'project':67 'recommend':64 'relat':77 'releas':34 'sequel':1,4,10,46,57 'sequelize-oracl':3 'sqlite':29,70 'support':16,25,51 'target':21 'v1.7.0':11 'version':18,58 'xe':33","created_at":"2026-06-04T18:54:53.440167+00:00","updated_at":"2026-06-04T18:54:53.440167+00:00","problems":[{"fix":"npm install oracledb and ensure Oracle client libraries are available.","cause":"Oracle native driver not installed.","error":"Error: Cannot find module 'oracledb'"},{"fix":"Use 'oracle' with correct lowercase; check supported dialects list.","cause":"Using sequelize-oracle with a dialect string misspelled or unsupported.","error":"Dialect 'oracle' is not supported."},{"fix":"Manually create tables using raw SQL or consider using a different ORM.","cause":"The fork may have incomplete DDL support for Oracle.","error":"sequelize.sync() does not create tables for Oracle"}],"ecosystem":"npm","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":null,"cli_version":null,"type":"library","homepage":"https://github.com/lebretr/sequelize-oracle","github":"https://github.com/lebretr/sequelize-oracle","docs":null,"changelog":null,"pypi":null,"npm":"sequelize-oracle","openapi_spec":null,"status_page":null,"smithery":null,"categories":["database"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-06-04","next_check":"2026-09-02","install_tag":null}}