dbt-oracle
dbt (data build tool) adapter for Oracle Autonomous Database
Decision gist · record as of 2026-08-14
Yes. dbt-oracle is actively maintained by Oracle, carries no known vulnerabilities, has low install friction, and is licensed permissively. Install it if you use dbt and need to run transformations on Oracle Autonomous Database. The recent release cadence and active repository signal ongoing support.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires Python 3.10 or later.
- An Oracle Autonomous Database instance and valid credentials are needed to connect.
- Low friction install with a recent release (8 days old) and active maintenance.
License · maintenance · safety
Apache-2.0 (permissive) — Licensed under Apache-2.0 (permissive), allowing use in commercial and private projects with minimal restrictions. You must retain the license notice but face no copyleft obligations.
last release 2026-08-06 (8 days) · last repo commit 2026-08-07 · 66 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 91,276 downloads/mo, #13,530 on PyPI
Alternatives
Verify before relying
pip install dbt-oracle
In your dbt project's profiles.yml:
my-oracle-db:
target: dev
outputs:
dev:
type: oracle
host: [hostname]
user: [username]
pass: [password]
database: [database]
schema: [schema]
threads: 4- Specific dbt version compatibility range (fact sheet lists dbt-core as a runtime dependency but not its version constraint).
- Whether the adapter supports all dbt features or has known limitations for Oracle-specific SQL dialects.
- Performance characteristics and scalability limits for large transformation workloads.
What it is and what it does
dbt-oracle bridges dbt (a popular SQL transformation framework) and Oracle Autonomous Database, letting you write modular SQL transformations, manage dependencies, and orchestrate data pipelines in Oracle. It's maintained by Oracle itself as of version 1.0.0 and integrates with the dbt ecosystem via standard adapter interfaces.
You install it alongside dbt-core and configure a connection profile pointing to your Oracle instance. Once set up, you write dbt models as SQL files, define tests and documentation, and run dbt commands to build and validate your data transformations directly in Oracle. The adapter handles Oracle-specific SQL generation and connection management.
Use it for
- Build modular, version-controlled SQL transformation pipelines in Oracle Autonomous Database using dbt's standard workflow.
- Orchestrate complex multi-step data workflows with dependency management and incremental builds on Oracle.
- Integrate Oracle data transformations into a dbt-based analytics stack alongside other dbt adapters.
- Document and test data models in Oracle with dbt's built-in testing and documentation frameworks.
- Migrate existing dbt projects from other databases to Oracle Autonomous Database.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes.
dbt-oracle is actively maintained by Oracle, carries no known vulnerabilities, has low install friction, and is licensed permissively. Install it if you use dbt and need to run transformations on Oracle Autonomous Database. The recent release cadence and active repository signal ongoing support.
Install
dbt-oracle on PyPI
Before you install
Low friction install with a recent release (8 days old) and active maintenance. The package depends on dbt-core, dbt-adapters, dbt-common, and oracledb—all standard dbt ecosystem components. Repository is actively maintained by Oracle with regular commits.
Requires Python 3.10 or later. An Oracle Autonomous Database instance and valid credentials are needed to connect.
License in practice
Licensed under Apache-2.0 (permissive), allowing use in commercial and private projects with minimal restrictions. You must retain the license notice but face no copyleft obligations.
Quickstart
pip install dbt-oracle
In your dbt project's profiles.yml:
my-oracle-db:
target: dev
outputs:
dev:
type: oracle
host: [hostname]
user: [username]
pass: [password]
database: [database]
schema: [schema]
threads: 4Verify before relying
- Specific dbt version compatibility range (fact sheet lists dbt-core as a runtime dependency but not its version constraint).
- Whether the adapter supports all dbt features or has known limitations for Oracle-specific SQL dialects.
- Performance characteristics and scalability limits for large transformation workloads.
Package facts
| License | Apache-2.0 permissive |
| Python support | Supports the current Python release >=3.10 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 4 packagesdbt-commondbt-adaptersdbt-coreoracledb |
| Maintenance | Actively maintained 8 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 91,276 / month, #13,530 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Development Status :: 5 - Production/StableIntended Audience :: DevelopersProgramming Language :: Python :: 3Programming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.13Programming Language :: Python :: 3.14 |
Evidence: dbt_oracle-1.12.0-py3-none-any.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “dbt oracle adapter”
- dbt-oracledbt-oracle is a dbt adapter that enables data transformation and…
- dbt-adaptersProvides base adapter protocols and shared functionality that…
- dbt-commonProvides shared utilities and common code used by dbt-core and dbt…
Give your agent the search over MCP, or paste the wish link into any chat.
More Build Tools packages
Provides reusable utilities for Python packaging interoperability, including version handling, specifiers, markers, requirements, tags, and metadata parsing according to standards like PEP 440 and PEP 425.
Wraps any iterable to display a real-time progress bar in the terminal or Jupyter notebook, showing iteration count, elapsed time, and estimated time remaining.
pip is the standard installer for Python packages, enabling you to download and install packages from the Python Package Index and other indexes into your Python environment.
Hatchling is a standards-compliant Python build backend that handles packaging, metadata, and distribution of Python projects when configured in a project's pyproject.toml file.
Generates Python gRPC service stubs and message classes from Protocol Buffer definitions, enabling developers to build gRPC clients and servers.
pre-commit is a framework for installing and running git hooks written in any language before commits are made, automating code quality and validation checks across multi-language projects.
Install it if your team needs consistent, automated validation at commit time.
See also dbt-core · dbt-postgres · dbt-spark · dbt-bigquery · dbt-dremio · dbt-snowflake · dbt-trino · dbt-databricks · cx-Oracle · dbt-state