---
id: sqlalchemy-vertica-python
version: "0.6.3"
license: MIT
license_treatment: permissive
maintenance: dormant
---

# sqlalchemy-vertica-python — Vertica dialect for sqlalchemy using vertica_python

License: permissive · Maintenance: dormant · Downloads: 196.1K/mo

## What it is and what it does

This package bridges SQLAlchemy and Vertica by implementing a SQLAlchemy dialect that uses vertica-python, a pure-Python DB-API driver. It allows you to use SQLAlchemy's ORM and expression language to query and manipulate Vertica databases without needing ODBC or other system-level drivers. The package was forked from an earlier ODBC-based dialect and is maintained by BlueLabs.

You create a Vertica engine by specifying a connection URL with the vertica+vertica_python scheme, then use standard SQLAlchemy patterns to define tables, run queries, and manage transactions. The documentation notes a quirk: Vertica sequences must be explicitly declared for primary keys rather than relying on auto-increment, since direct ID insertion will fail.

Use it for:

- Build Python applications that query Vertica using SQLAlchemy's ORM without installing ODBC drivers.
- Migrate from other databases to Vertica while keeping SQLAlchemy code largely unchanged.
- Run data pipelines that read from or write to Vertica using SQLAlchemy expressions and bulk operations.
- Integrate Vertica into web frameworks that use SQLAlchemy for database abstraction.

## Worth the install?

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

Provides a SQLAlchemy dialect for Vertica using the pure-Python vertica-python driver, enabling ORM and SQL expression language access to Vertica databases.

Yes, if you are already committed to Vertica and SQLAlchemy and can tolerate dormant maintenance. The package is stable and has no known vulnerabilities, but expect no active support or updates. Verify that vertica-python itself meets your needs and that the dialect works with your target SQLAlchemy and Vertica versions before adopting it for new projects.

## Install

pip install sqlalchemy-vertica-python
uv add sqlalchemy-vertica-python
poetry add sqlalchemy-vertica-python

## Installing sqlalchemy-vertica-python

Before you install: Low install friction with a single pure-Python runtime dependency. Maintenance is dormant—last commit was 2023-12-19 and no releases in over a year—so expect no active bug fixes or feature updates, though the repository remains unarchived.

License in practice: MIT license permits commercial and private use with minimal restrictions, making it safe for most projects that can tolerate dormant maintenance.

Quickstart:

pip install sqlalchemy-vertica-python

import sqlalchemy as sa
engine = sa.create_engine('vertica+vertica_python://user:pwd@host:port/database')

Requires vertica-python to be installed and a running Vertica database instance accessible at the specified host and port.

Verify before relying:

- Whether vertica-python itself is actively maintained and compatible with modern Vertica server versions.
- Whether the dialect works reliably with SQLAlchemy versions released after 2023-06-05.
- Current compatibility with Python versions beyond 3.8 (classifiers list only up to 3.8).

## Package facts

- License: MIT (permissive)
- Python support: unspecified
- Install friction: low
- Maintenance: dormant
- Downloads: 196.1K/month (top 15,000 on PyPI)
- Known vulnerabilities: none known

## Tags

sqlalchemy vertica dialect, vertica database orm, sqlalchemy vertica driver, vertica python connector, vertica sql toolkit, sqlalchemy-dialect, vertica

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