sqlalchemy_exasol

What it is and what it does

SQLAlchemy-Exasol is a SQLAlchemy dialect that bridges Python applications to Exasol databases via WebSocket. It allows developers to use SQLAlchemy's familiar ORM and Core query interfaces instead of writing raw SQL, supporting SELECT, INSERT, UPDATE, and DELETE operations. The package wraps pyexasol as its underlying connection layer and is designed for applications that need database abstraction while working with Exasol's columnar analytics engine.

The dialect is actively maintained and supports modern Python versions (3.10 through 3.14). It targets data science and analytics workflows where Exasol is the chosen database backend. Installation is straightforward with no compiled dependencies, making it easy to add to existing Python projects that already use SQLAlchemy.

Use it for:

• Build data science pipelines in Python that query Exasol for analytics and reporting without raw SQL.
• Migrate applications from other SQL databases to Exasol while keeping SQLAlchemy code largely unchanged.
• Develop web applications that use Exasol as a backend database through SQLAlchemy's ORM layer.
• Integrate Exasol into ETL workflows where Python orchestration tools need database abstraction.
• Use SQLAlchemy's query builder to construct complex analytics queries against Exasol tables programmatically.

Worth the install?

AI-flagged interpretation of the facts on this page — verify before relying

SQLAlchemy dialect that enables Python applications to connect to and query Exasol databases using SQLAlchemy's ORM and Core APIs via WebSocket.

Yes. The package is actively maintained, has no known vulnerabilities, installs with low friction, and uses a permissive license. It is the standard way to use Exasol from Python applications that depend on SQLAlchemy. Install it if you are building or migrating an application to Exasol and want SQLAlchemy integration.

Install

sqlalchemy-exasol on PyPI

pip install sqlalchemy-exasol

uv add sqlalchemy-exasol

poetry add sqlalchemy-exasol

Installing sqlalchemy_exasol

Before you install

Low friction installation with a pure-Python wheel. Actively maintained with a release 10 days old and recent commits. Requires Python 3.10 or later and depends on three stable packages: sqlalchemy, pyexasol, and packaging.

License in practice

BSD-2-Clause is permissive; you may use, modify, and distribute this package freely in commercial and private projects with minimal restrictions.

Quickstart

pip install sqlalchemy-exasol

from sqlalchemy import create_engine
engine = create_engine('exa+pyexasol://user:password@host/database')
with engine.connect() as conn:
    result = conn.execute('SELECT * FROM table')

Requires an Exasol database instance (version 7.1 or later) and Python 3.10 or later.

Verify before relying

• Whether the dialect supports all SQLAlchemy features (e.g., reflection, migrations, relationship loading) or only basic CRUD.
• Performance characteristics and connection pooling behavior under load.
• Compatibility with specific Exasol SaaS configurations and network setups.

Package facts

Evidence: sqlalchemy_exasol-7.1.2-py3-none-any.whl

Keywords: exasol, sql, sqlalchemy, data science, database

Tags

More Software Development packages