vertica-python
Official native Python client for the Vertica database.
Decision gist · record as of 2026-08-14
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.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires Vertica server to be running and accessible; optional Kerberos support requires the kerberos package and python-dev system library.
- 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 · maintenance · safety
Apache License 2.0 (permissive) — Licensed under Apache License 2.0 (permissive), allowing use in proprietary and open-source projects with minimal restrictions.
last release 2024-07-22 (753 days) · last repo commit 2026-01-21 · 386 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 5,905,527 downloads/mo, #2,015 on PyPI
Alternatives
Verify before relying
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()- 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.
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 on it.
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
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.
Requires Vertica server to be running and accessible; optional Kerberos support requires the kerberos package and python-dev system library.
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()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
| License | Apache License 2.0 permissive |
| Python support | Supports the current Python release >=3.7 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 2 packagespython-dateutilsix |
| Maintenance | Aging 753 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 5,905,527 / month, #2,015 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 :: DevelopersLicense :: OSI Approved :: Apache Software LicenseOperating System :: OS IndependentProgramming Language :: PythonProgramming Language :: Python :: 3Programming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.7Programming Language :: Python :: 3.8Programming Language :: Python :: 3.9Topic :: DatabaseTopic :: Database :: Database Engines/ServersTopic :: Database :: Front-EndsTopic :: Software Development :: Libraries :: Python Modules |
Evidence: vertica_python-1.4.0-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 › “vertica database client”
- vertica-pythonNative Python client library for connecting to and querying Vertica…
- sqlalchemy-verticaProvides a SQLAlchemy dialect for Vertica, enabling SQLAlchemy…
- sqlalchemy-vertica-pythonProvides a SQLAlchemy dialect for Vertica using the pure-Python…
Give your agent the search over MCP, or paste the wish link into any chat.
More Python Modules packages
Converts domain names between Unicode and ASCII-compatible encoding (Punycode) according to IDNA 2008 and Unicode Technical Standard 46, with security validation and broader script coverage than the standard library.
Install it if you work with internationalized domain names, need to validate domains, or use HTTP clients that depend on it transitively.
Setuptools is a Python build backend and package management tool that handles building, distributing, and installing Python packages, including support for C/C++ extension modules.
PyYAML parses and emits YAML 1.1 data format, enabling serialization and deserialization of configuration files and Python objects to and from human-readable YAML text.
Pydantic validates Python data structures against type hints, coercing and checking input at runtime to ensure it matches a declared schema.
Provides reusable metadata objects for use with PEP-593 `typing.Annotated` to express common constraints like bounds, collection sizes, and predicates on types.
Install it if you use or build libraries that need to express type constraints in a standardized, inspectable way—or if you want to annotate your own types with…
Provides runtime tools to inspect and introspect Python type annotations, enabling programmatic examination of type hints at execution time.
See also sqlalchemy-vertica · dbt-vertica · sqlalchemy-vertica-python · python-irodsclient · apache-airflow-providers-vertica · mysql-connector · pg8000 · trino · mysql-connector-python-rf · kylinpy