Add Oracle Database Support via oracledb Driver

[J7503303]

Feature Request

LangFlow's Docker image currently lacks Oracle database connectivity support. This prevents using Oracle databases in:

1. SQL Query components
2. Custom components
3. Any database operations requiring Oracle connections

Please integrate the official oracledb Python driver into the Docker image with:

• Thin mode support (pure Python, no dependencies)
• Thick mode support (using Oracle Instant Client for full feature compatibility)

This will enable seamless Oracle database connections across all relevant LangFlow components without manual user modifications to the Docker environment.

Motivation

• Oracle is widely used in enterprise environments
• Current workarounds break container immutability
• Native support improves deployment reliability

Your Contribution

No response

[J7503303]

Hellp me!

[riazhaq]

@dosu help pls

[dosubot]

Hi @riazhaq! I'm Dosu and I’m helping the langflow team.

LangFlow doesn't currently include Oracle (oracledb) support out of the box—there are no existing tickets or PRs for this, and the Docker image and dependencies don't install the oracledb driver or Oracle Instant Client yet. However, the backend is modular and built on SQLAlchemy, so adding support is mostly about updating the Dockerfile and dependencies, not changing core code logic.

To add Oracle support: install the oracledb Python package for Thin mode, and add Oracle Instant Client libraries for Thick mode in your Dockerfile. Then, set your database URL to use the correct SQLAlchemy scheme (like oracle+oracledb://user:pass@host:port/?service_name=...). If you run into issues with async connections or driver selection, use the LANGFLOW_DATABASE_DRIVER_ASYNC environment variable, which was recently added to help with non-standard drivers source.

There are some known quirks with URL handling for non-standard databases, but recent changes have improved flexibility. The test suite already validates Oracle URLs, so the architecture is ready for this integration—it's just missing the packaging and Docker steps source.

If you want step-by-step Dockerfile or dependency instructions, let me know your preferred mode (Thin or Thick) and I can outline the changes!

To reply, just mention @dosu.

---

^{How did I do? Good | Irrelevant | Incorrect | Verbose | Hallucination | Report 🐛 | Other}