---
id: pyexasol
version: "2.3.1"
license: MIT
license_treatment: permissive
maintenance: active
---

# pyexasol — Exasol python driver with extra features

License: permissive · Maintenance: active · Downloads: 5.4M/mo

## What it is and what it does

PyExasol is the officially maintained Python driver for Exasol databases, built on the WebSocket protocol to minimize overhead and maximize throughput. It handles large data volumes efficiently and integrates with data processing tools via HTTP transport. The package's core strength is its support for parallel data streams across separate processes, allowing you to move beyond single-core limitations and achieve linear scalability by fully utilizing available hardware.

The connector compresses data to reduce network bottleneck and provides an API for reading and writing multiple streams in parallel. It requires Python >= 3.10 and Exasol >= 7.1, and depends on cryptography, packaging, and websocket-client for its core functionality. The project is actively maintained by Exasol and marked as Production/Stable.

Use it for:

- Bulk data import and transfer from Exasol into Python data processing workflows.
- High-throughput ETL pipelines that need to move large datasets between Exasol and Python tools.
- Multi-process data loading to fully utilize multi-core systems and achieve linear performance scaling.
- Integration of Exasol queries into data science workflows.
- Replacing ODBC-based connectors when single-process performance becomes a bottleneck.

## Worth the install?

AI-flagged interpretation of the facts above — verify before relying.

PyExasol is the official Python connector for Exasol databases, optimized for high-throughput data transfer using WebSocket protocol and supporting parallel data streams for multi-core scalability.

Yes. PyExasol is the official, actively maintained connector for Exasol with low install friction, no known vulnerabilities, and a permissive MIT license. It is production-stable and designed specifically for high-performance parallel data transfer. Install it if you work with Exasol and need Python connectivity; the parallel-stream architecture makes it the natural choice over generic ODBC drivers for this DBMS.

## Install

pip install pyexasol
uv add pyexasol
poetry add pyexasol

## Installing pyexasol

Before you install: Low install friction with a pure-wheel distribution. Actively maintained by Exasol with a recent release (9 days old) and consistent commit activity. Requires Python >= 3.10 and Exasol >= 7.1.

License in practice: MIT license permits unrestricted use, modification, and distribution with minimal obligations—suitable for commercial and open-source projects alike.

Quickstart:

pip install pyexasol

import pyexasol
conn = pyexasol.connect(dsn='host:port', user='user', password='pass')
result = conn.execute('SELECT * FROM table')
for row in result:
    print(row)

Requires Exasol >= 7.1 and Python >= 3.10; an Exasol database instance must be accessible at the specified host:port.

Verify before relying:

- Actual performance improvement magnitude over ODBC in typical workloads remains unquantified.
- Specific scalability characteristics and hardware utilization patterns with parallel streams are not detailed.
- Whether compression is automatic or requires explicit configuration.

## Package facts

- License: MIT (permissive)
- Python support: supports_current
- Install friction: low
- Maintenance: active
- Downloads: 5.4M/month (top 5,000 on PyPI)
- Known vulnerabilities: none known

## Tags

exasol database driver, python sql connector, websocket database client, parallel data streams, exasol python api, high performance database connector, bulk data transfer, database-connector, parallel-io, data-pipeline

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