---
id: apache-airflow-providers-oracle
version: "4.6.2"
license: Apache-2.0
license_treatment: permissive
maintenance: active
---

# apache-airflow-providers-oracle — Provider package apache-airflow-providers-oracle for Apache Airflow

License: permissive · Maintenance: active · Downloads: 1.9M/mo

## What it is and what it does

This is an Apache Airflow provider package that extends Airflow with Oracle database connectivity and task orchestration. It supplies operators, hooks, and sensors designed to let you define, schedule, and monitor Oracle database operations as part of Airflow DAGs. The package wraps the oracledb driver and integrates with Airflow's common SQL provider layer to offer a consistent interface for database work.

You install it on top of an existing Airflow deployment (>=2.11.0) to gain Oracle-specific task primitives. It supports Python 3.10 through 3.14 and is actively maintained by the Apache Airflow project. Optional dependencies include numpy (for certain Python versions) and OpenLineage integration for data lineage tracking.

Use it for:

- Schedule and execute SQL scripts or stored procedures against Oracle databases as part of Airflow workflows
- Monitor Oracle database health or query results using Airflow sensors that poll for completion or data conditions
- Build multi-step ETL pipelines that extract data from Oracle, transform it, and load it into other systems via Airflow orchestration
- Integrate Oracle database tasks with non-database tasks in a single Airflow DAG for end-to-end workflow automation

## Worth the install?

AI-flagged interpretation of the facts above — verify before relying.

Integrates Apache Airflow with Oracle databases, providing operators, hooks, and sensors to orchestrate Oracle database tasks within Airflow workflows.

Yes. This is a production-stable provider (Development Status 5) from the Apache Airflow project with no known vulnerabilities, low install friction, and permissive licensing. Install it if you need to orchestrate Oracle database work within Airflow; it is the standard integration for that use case.

## Install

pip install apache-airflow-providers-oracle
uv add apache-airflow-providers-oracle
poetry add apache-airflow-providers-oracle

## Installing apache-airflow-providers-oracle

Before you install: Low friction install as a pure Python wheel. Actively maintained with a recent release (35 days old) and backed by the Apache Airflow project's infrastructure. Requires Apache Airflow >=2.11.0 and oracledb >=2.3.0 as runtime dependencies.

License in practice: Licensed under Apache-2.0 (permissive), allowing free use, modification, and distribution with minimal restrictions. No licensing concerns for commercial or private projects.

Quickstart:

pip install apache-airflow-providers-oracle

from airflow.providers.oracle.operators.oracle import OracleOperator
from airflow import DAG

with DAG('oracle_example') as dag:
    task = OracleOperator(
        task_id='run_query',
        sql='SELECT * FROM my_table',
        oracle_conn_id='oracle_default'
    )

Requires an existing Apache Airflow >=2.11.0 installation and an Oracle database connection configured in Airflow (via Connection UI or environment variable). The oracledb driver may require Oracle client libraries depending on your environment.

Verify before relying:

- Specific operators, hooks, and sensor classes available in this version
- Whether oracledb >=2.3.0 requires Oracle client libraries on the system
- Performance characteristics or limitations for large-scale Oracle workloads

## Package facts

- License: Apache-2.0 (permissive)
- Python support: supports_current
- Install friction: low
- Maintenance: active
- Downloads: 1.9M/month (top 5,000 on PyPI)
- Known vulnerabilities: none known

## Tags

airflow oracle database integration, airflow oracle provider, oracle database operators airflow, airflow oracle hooks, oracle sql tasks airflow, airflow database orchestration oracle, airflow-provider, database-integration, workflow-orchestration

[View on SkillFed](https://skillfed.io/packages/apache-airflow-providers-oracle) · [View on PyPI](https://pypi.org/project/apache-airflow-providers-oracle/)