---
id: sqlalchemy-exasol
version: "7.1.2"
license: BSD-2-Clause
license_treatment: permissive
maintenance: active
---

# sqlalchemy_exasol — EXASOL dialect for SQLAlchemy

License: permissive · Maintenance: active · Downloads: 295.9K/mo

## 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 above — 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

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

- License: BSD-2-Clause (permissive)
- Python support: supports_current
- Install friction: low
- Maintenance: active
- Downloads: 295.9K/month (top 15,000 on PyPI)
- Known vulnerabilities: none known

## Tags

sqlalchemy exasol dialect, exasol database python, exasol orm connector, websocket database adapter, exasol sqlalchemy integration, python exasol driver, exasol query builder, sqlalchemy-dialect, analytics-database, websocket-driver

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