Registry / database / n8n-nodes-oracle-database

n8n-nodes-oracle-database

library0.0.1jsnpmunverified

n8n community node for integrating Oracle Database into n8n workflows. Version 0.0.1 is the initial release, allowing querying and managing Oracle databases directly from n8n. This package is specific to the n8n ecosystem, extending n8n with a custom node. It is not a standalone database driver but an n8n node that uses the 'oracledb' package internally. Compared to other database nodes, it focuses on Oracle compatibility. Release cadence is irregular as it is community-maintained.

database workflow

npm install n8n-nodes-oracle-database

github ↗package ↗

INSTALL

IMPORT

SIG · N8N-NODES-ORACLE-D

n8n-nodes-oracle-database

databasejavascriptv0.0.1

Install

—

Import

—

Disk

—

Pass rate

0/ 6

Env Coverage0 / 6

glibc

18–22

musl

18–22

Install & Compatibility

Where this runs

tested against v? · npm install

Install × environment matrix

Each cell = how many times install + import succeeded across repeated harness runs. Partial = flaky.
glibc = Debian/Ubuntu slim · musl = Alpine Linux

musl

node 18–226 runs

build_error

glibc

node 18–226 runs

build_error

Code

Verified usage

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

OracleDatabase

✓ import { OracleDatabase } from 'n8n-nodes-oracle-database'

✗ const OracleDatabase = require('n8n-nodes-oracle-database')

ESM-only package; CommonJS require will fail.

OracleDatabaseV2

✓ import { OracleDatabaseV2 } from 'n8n-nodes-oracle-database'

Only available as named export; no default export.

IOracleCredentials

✓ import type { IOracleCredentials } from 'n8n-nodes-oracle-database'

✗ import { IOracleCredentials } from 'n8n-nodes-oracle-database'

TypeScript type; should be imported with 'import type' for tree-shaking.

Shows how to import the OracleDatabase node and execute a simple query using environment variables for credentials.

import { OracleDatabase } from 'n8n-nodes-oracle-database'; const node = new OracleDatabase(); const credentials = { host: process.env.ORACLE_HOST ?? 'localhost', port: parseInt(process.env.ORACLE_PORT ?? '1521'), user: process.env.ORACLE_USER ?? 'admin', password: process.env.ORACLE_PASSWORD ?? '', database: process.env.ORACLE_DATABASE ?? 'xe', }; // Example: execute a query const result = await node.execute({ credentials, query: 'SELECT * FROM dual', options: {} }); console.log(result);

Debug

Known issues

gotchaPackage is in early development (v0.0.1); API may change without notice.

fix

Pin to exact version and monitor releases.

affects: =0.0.1

gotchaRequires Oracle Instant Client or full Oracle Client installed on the system for the 'oracledb' driver to work.

fix

Install Oracle Instant Client and set environment variables (e.g., LD_LIBRARY_PATH or PATH).

affects: >=0.0.1

gotchaCredentials are passed as plain objects; if not stored in n8n's credential vault, they may be exposed in workflow exports.

fix

Always use n8n's credential system instead of hardcoding.

affects: >=0.0.1

gotchaThe node does not support connection pooling; each execution creates a new connection.

fix

Reduce parallel executions or implement connection pooling manually.

affects: =0.0.1

Errors

Common errors & fixes

ORA-24454: client host name is not set

The Oracle client environment variable ORACLE_HOST is not set or incorrect.

fix

Set the ORACLE_HOST environment variable to a valid hostname or IP address.

Error: DPI-1047: Cannot locate a 64-bit Oracle Client library

Oracle Instant Client is not installed or not in the library path.

fix

Download and install Oracle Instant Client, and add its location to LD_LIBRARY_PATH (Linux) or PATH (Windows).

TypeError: OracleDatabase is not a constructor

Using a CommonJS require() on an ESM-only package.

fix

Use ES module import syntax: import { OracleDatabase } from 'n8n-nodes-oracle-database'

Upgrade

Version history

0.0.1latest on npm

Audit

Dependencies

oracledbrequiredCore database driver for Oracle connections; required at runtime.

n8n-workflowrequiredRequired for n8n node base classes and decorators.

Agent activity

13 hits · last 30 days

node

OpenAI (training)

Resources

githubhttps://github.com/matheuspeluchi/n8n-nodes-oracle-database ↗

packagehttps://www.npmjs.com/package/n8n-nodes-oracle-database ↗