redshift-connector

Redshift interface library

redshift-connector Permissive license Apache License 2.0 Active ★ 220 v2.1.16 released 2026-08-03

Install

redshift-connector on PyPI

pip

pip install redshift-connector

uv

uv add redshift-connector

poetry

poetry add redshift-connector

Package facts

License	Apache License 2.0 (permissive)
Python support	supports the current Python release (>=3.8)
Install friction	low — pure-Python wheel
Runtime dependencies	9 — scramp, pytz, beautifulsoup4, boto3, requests, lxml, botocore, packaging, setuptools
Maintenance	actively maintained — 10 days since the last release
Last repo commit	2026-08-04
First released	2020-11-04
Popularity	one of the top 1,000 most-downloaded packages on PyPI (30-day window, as of 2026-08-13)
Known vulnerabilities	none known (OSV.dev, checked 2026-08-13)

Evidence: redshift_connector-2.1.16-py3-none-any.whl

Keywords: redshift, dbapi

Development Status :: 5 - Production/StableIntended Audience :: DevelopersLicense :: OSI Approved :: BSD LicenseOperating System :: OS IndependentProgramming Language :: PythonProgramming Language :: Python :: 3Programming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.13Programming Language :: Python :: 3.14Programming Language :: Python :: 3.8Programming Language :: Python :: 3.9Programming Language :: Python :: ImplementationProgramming Language :: Python :: Implementation :: CPythonProgramming Language :: Python :: Implementation :: JythonProgramming Language :: Python :: Implementation :: PyPyTopic :: Database :: Front-EndsTopic :: Software Development :: Libraries :: Python Modules

About redshift-connector

from the package's own PyPI description — quoted content, verbatim

======================================================= redshift_connector =======================================================

|Python Version| |PyPi|

.. |PyPi| image:: https://img.shields.io/pypi/v/redshift_connector.svg?maxAge=432000&style=flat-square :target: https://pypi.org/project/redshift_connector/

.. |Python Version| image:: https://img.shields.io/badge/python->=3.8-brightgreen.svg :target: https://pypi.org/project/redshift_connector/

redshift_connector is the Amazon Redshift connector for Python. Easy integration with pandas <https://github.com/pandas-dev/pandas> and numpy <https://github.com/numpy/numpy>, as well as support for numerous Amazon Redshift specific features help you get the most out of your data

Supported Amazon Redshift features include:

IAM authentication
Identity provider (IdP) authentication
Redshift specific data types

This pure Python connector implements Python Database API Specification 2.0 <https://www.python.org/dev/peps/pep-0249/>_.

Getting Started

Install from...

Read as markdown · JSON record · Source repository · Homepage

AI interpretation — verify before relying

AI-generated interpretation of the package facts above; every digit, version, license, or vulnerability id it cites is grounded in the facts already shown on this page

redshift_connector is a Python database driver for Amazon Redshift that implements the DB-API 2.0 specification, enabling SQL queries and data operations with support for IAM authentication, identity providers, and Redshift-specific data types.

Low friction: pure Python wheel with nine well-established runtime dependencies (boto3, requests, beautifulsoup4, lxml, scramp, pytz, packaging, setuptools). Active maintenance with a release 10 days ago and recent commits.

Apache License 2.0 is permissive, allowing commercial and private use with minimal restrictions—suitable for most production environments.

Usage

pip install redshift_connector

import redshift_connector
conn = redshift_connector.connect(
    host='examplecluster.abc123xyz789.us-west-1.redshift.amazonaws.com',
    database='dev',
    user='awsuser',
    password='my_password'
)
cursor = conn.cursor()
cursor.execute("SELECT * FROM table")
result = cursor.fetchall()

Requires Python >=3.8 and valid AWS Redshift cluster credentials (host, database, user, password or IAM authentication).

Verdict: Production-ready connector with active maintenance, no known vulnerabilities, and low install friction. Backed by AWS, supports Python 3.8–3.14, and integrates well with pandas and numpy for data science workflows. Safe choice for Redshift database access.

Needs verification

Whether boto3 and botocore are truly required at runtime or only for IAM authentication flows
Performance characteristics and connection pooling capabilities compared to alternatives

redshift database connector pythonamazon redshift python driverredshift dbapipython redshift sql clientredshift iam authenticationredshift pandas integrationredshift cursor execute