---
id: oracledb
version: "4.0.2"
license: UPL-1.0 OR Apache-2.0
license_treatment: unclear
maintenance: active
---

# oracledb — Python interface to Oracle Database

License: unclear · Maintenance: active · Popularity: top 1,000 on PyPI

## Install

pip install oracledb
uv add oracledb
poetry add oracledb

## Description

# python-oracledb

The python-oracledb driver is the widely used, open-source [Python][python]
extension module allowing Python programs to connect directly to [Oracle
Database][oracledb] with no extra libraries needed. The module is built with
Cython for safety and speed. It is lightweight and high-performance. It is
stable, well tested, and has comprehensive [documentation][documentation]. The
module is maintained by Oracle.

The module conforms to the [Python Database API 2.0 specification][pep249] with
a considerable number of additions and a couple of minor exclusions, see the
[feature list][features]. It is used by many Python frameworks, SQL generators,
ORMs, and libraries.

Python-oracledb has a rich feature set which is easy to use. It gives you
control over SQL and PL/SQL statement execution; for working with data frames;
for fast data ingestion; for calling NoSQL-style document APIs; for message
queueing; for receiving database notifications; and for starting and stopping
the database. It also has high availability and security features. Synchronous
and [concurrent][concurrent] coding styles are supported. Database operations
can optionally be...

## AI interpretation — verify before relying

A Python driver for connecting to Oracle Database directly, supporting both thin mode (no external libraries) and thick mode (with optional Oracle Client libraries) for SQL and PL/SQL execution.

Verdict: oracledb is a production-stable, actively maintained driver built with Cython for performance and safety. It has no known vulnerabilities, supports Python 3.9–3.14, and ranks in the top 1000 PyPI packages. The dual license (UPL-1.0 OR Apache-2.0) requires clarification for some use cases, and medium install friction reflects platform-specific wheels, but these are minor concerns for Oracle Database users.

[View on SkillFed](https://skillfed.io/packages/oracledb) · [View on PyPI](https://pypi.org/project/oracledb/)