vertica-python

What it is and what it does

vertica-python is the official native Python client for Vertica databases, replacing the deprecated vertica_db_client. It implements the DB-API v2.0 standard, allowing developers to connect to Vertica servers, execute queries, and retrieve results using familiar Python database patterns. The library supports Python 3.7 through 3.13 and handles connection management, parameter passing, SSL/TLS encryption, and optional Kerberos authentication.

The package is lightweight, with only two core runtime dependencies (python-dateutil and six), making it straightforward to integrate into existing Python applications. It provides connection pooling options, load balancing, prepared statements, and configurable data transfer formats. The library is officially supported by Vertica and has been in production use since its first release in 2013.

Use it for:

• Connect Python applications to Vertica data warehouses for analytics and reporting queries.
• Build ETL pipelines that extract data from Vertica or load data into Vertica tables.
• Integrate Vertica queries into web applications or microservices using DB-API v2.0 patterns.
• Execute parameterized SQL queries with automatic type conversion and prepared statement support.
• Authenticate to Vertica using Kerberos in enterprise environments with centralized identity management.

Worth the install?

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

Native Python client library for connecting to and querying Vertica databases, implementing the DB-API v2.0 standard.

Yes, if you need to connect Python to Vertica. It is the official client, has no known vulnerabilities, low install friction, and permissive licensing. However, the aging maintenance status suggests it may not receive timely updates for new Vertica features or Python versions—verify compatibility with your specific Vertica and Python versions before committing to a new project.

Install

vertica-python on PyPI

pip install vertica-python

uv add vertica-python

poetry add vertica-python

Installing vertica-python

Before you install

Low install friction with only two runtime dependencies (python-dateutil, six). Maintenance status is aging—last release was over two years ago, though the repository remains active with a recent commit in January 2026 and no archived status.

License in practice

Licensed under Apache License 2.0 (permissive), allowing use in proprietary and open-source projects with minimal restrictions.

Quickstart

pip install vertica-python

import vertica_python

conn_info = {'host': '127.0.0.1', 'port': 5433, 'user': 'user', 'password': 'pass', 'database': 'db'}
with vertica_python.connect(**conn_info) as connection:
    cursor = connection.cursor()
    cursor.execute('SELECT * FROM table')
    results = cursor.fetchall()

Requires Vertica server to be running and accessible; optional Kerberos support requires the kerberos package and python-dev system library.

Verify before relying

• Whether aging maintenance status and gap since last release indicate active maintenance or dormancy despite recent commits.
• Current compatibility with Vertica versions beyond 24.4.0 mentioned in the description.

Package facts

Evidence: vertica_python-1.4.0-py3-none-any.whl

Keywords: database, vertica

Tags

More Python Modules packages