apache-airflow-providers-oracle
Provider package apache-airflow-providers-oracle for Apache Airflow
Decision gist · record as of 2026-08-14
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.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- 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.
- Low friction install as a pure Python wheel.
License · maintenance · safety
Apache-2.0 (permissive) — Licensed under Apache-2.0 (permissive), allowing free use, modification, and distribution with minimal restrictions. No licensing concerns for commercial or private projects.
last release 2026-07-10 (35 days) · last repo commit 2026-08-14 · 46,490 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 1,871,318 downloads/mo, #3,472 on PyPI
Alternatives
Verify before relying
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'
)- 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
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 on this page. Verify before relying on it.
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
apache-airflow-providers-oracle on PyPI
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.
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.
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'
)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 the current Python release >=3.10 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 4 packagesapache-airflowapache-airflow-providers-common-compatapache-airflow-providers-common-sqloracledb |
| Maintenance | Actively maintained 35 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 1,871,318 / month, #3,472 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/StableEnvironment :: ConsoleEnvironment :: Web EnvironmentFramework :: Apache AirflowFramework :: Apache Airflow :: ProviderIntended Audience :: DevelopersIntended Audience :: System AdministratorsProgramming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.13Programming Language :: Python :: 3.14Topic :: System :: Monitoring |
Evidence: apache_airflow_providers_oracle-4.6.2-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 › “airflow oracle database integration”
- apache-airflow-providers-oracleIntegrates Apache Airflow with Oracle databases, providing operators,…
- langchain-oracledbIntegrates Oracle Database with LangChain to enable vector search,…
- dbt-oracledbt-oracle is a dbt adapter that enables data transformation and…
Give your agent the search over MCP, or paste the wish link into any chat.
More Monitoring packages
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.
Provides generated Python code for OpenTelemetry semantic conventions, enabling standardized attribute naming and constant definitions for instrumentation and telemetry collection.
Install it if you are using OpenTelemetry and want to follow semantic conventions correctly.
Provides the reference implementation of the OpenTelemetry API for collecting and exporting traces, metrics, and logs from Python applications.
Provides the abstract API and interfaces for OpenTelemetry instrumentation in Python, defining how to emit traces, metrics, and logs without tying code to a specific SDK implementation.
Exports OpenTelemetry observability data to an OpenTelemetry Collector using Protobuf-encoded messages over HTTP.
Install it if you are using OpenTelemetry in Python and need to send data to a Collector over HTTP.
Provides automatic instrumentation commands and programmatic APIs to inject distributed tracing into Python applications without code changes, detecting and instrumenting packages used by your program.
Install it if you need distributed tracing without code changes and have compatible instrumented packages in your environment.
See also apache-airflow-providers-databricks · apache-airflow-providers-microsoft-azure · apache-airflow-providers-microsoft-mssql · apache-airflow-providers-postgres · apache-airflow-providers-standard · apache-airflow-providers-dbt-cloud · apache-airflow-providers-common-sql · apache-airflow-providers-snowflake · apache-airflow-providers-jdbc · apache-airflow-providers-exasol