Oracle Database

Category: SQL Status: base

Connects to Oracle Database. Supports SQL querying, schema browsing, migrations, ORM code generation, and data transfer.

Connection Settings

Field	Default	Description
host	localhost	Server hostname or IP
port	1521	Oracle listener port
user	(empty)	Database username (default: SYS)
password	(empty)	Password (8–30 chars, mixed case + digits + symbols)
service	(empty)	Oracle service name (e.g. XE, freepdb1)
url	(empty)	Full connection URL (overrides above fields)

Authentication

Oracle database credentials. Use SYS with AS SYSDBA for admin access. The service field replaces the SID in modern Oracle setups.

Supported Actions

• execute — run SQL/PL-SQL queries
• download — export table data
• delete — drop tables
• liquibase — Liquibase migration support
• transfer_table — copy table to another connector
• create_user — add a database user
• python_description / django_description / sqlalchemy_description — generate ORM model code
• stream_table — stream table data
• search_by_value — search within fetched table data

Required Setup

Requires the oracledb Python package:

pip install oracledb

External Links

• https://docs.oracle.com/en/database/