sqlalchemy_exasol
EXASOL dialect for SQLAlchemy
Decision gist · record as of 2026-08-14
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.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires an Exasol database instance (version 7.1 or later) and Python 3.10 or later.
- Low friction installation with a pure-Python wheel.
- Actively maintained with a release 10 days old and recent commits.
License · maintenance · safety
BSD-2-Clause (permissive) — BSD-2-Clause is permissive; you may use, modify, and distribute this package freely in commercial and private projects with minimal restrictions.
last release 2026-08-04 (10 days) · last repo commit 2026-08-14 · 37 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 295,889 downloads/mo, #7,911 on PyPI
Alternatives
Verify before relying
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')- 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.
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 on it.
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
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.
Requires an Exasol database instance (version 7.1 or later) and Python 3.10 or later.
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')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 the current Python release <3.15,>=3.10 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 3 packagespackagingpyexasolsqlalchemy |
| Maintenance | Actively maintained 10 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 295,889 / month, #7,911 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/StableIntended Audience :: DevelopersIntended Audience :: EducationIntended Audience :: Information TechnologyOperating System :: POSIX :: LinuxProgramming Language :: Python :: 3Programming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.13Programming Language :: Python :: 3.14Programming Language :: SQLTopic :: DatabaseTopic :: Scientific/Engineering :: Information AnalysisTopic :: Software DevelopmentTopic :: Software Development :: LibrariesTopic :: Software Development :: Libraries :: Application FrameworksTopic :: Software Development :: Libraries :: Python Modules |
Evidence: sqlalchemy_exasol-7.1.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 › “sqlalchemy exasol dialect”
- sqlalchemy_exasolSQLAlchemy dialect that enables Python applications to connect to and…
- apache-airflow-providers-exasolIntegrates Exasol database with Apache Airflow, providing operators…
- sqlalchemy-pgspiderProvides a SQLAlchemy dialect that enables connections to PGSpider…
Give your agent the search over MCP, or paste the wish link into any chat.
More Software Development packages
Provides backported and experimental type hints for Python 3.9+, allowing use of newer typing features on older Python versions and enabling early experimentation with type system PEPs before they enter the standard library.
NumPy provides an N-dimensional array object and a comprehensive suite of mathematical, linear algebra, Fourier transform, and random number functions for scientific computing in Python.
FastAPI is a Python web framework for building REST APIs using type hints, with automatic request validation, serialization, and interactive API documentation.
Provides a way to document function parameters, class attributes, return types, and variables inline using Python's `Annotated` type hint syntax instead of traditional docstrings.
Typer builds command-line applications from Python functions using type hints, automatically generating help text, argument parsing, and shell completion.
Install it if you are building CLIs in Python.
Distlib provides low-level packaging utilities for building, distributing, and managing Python software—including metadata handling, version specifiers, wheel support, script installation, and dependency resolution.
See also exasol-integration-test-docker-environment · pyexasol · sqlalchemy-jdbcapi · sqlalchemy-vertica · sqlalchemy-solr · sqlalchemy-risingwave · teradatasqlalchemy · databricks-sqlalchemy · sqlalchemy-databricks · starrocks