---
id: redshift-connector
version: "2.1.16"
license: Apache License 2.0
license_treatment: permissive
maintenance: active
---

# redshift-connector — Redshift interface library

License: permissive · Maintenance: active · Popularity: top 1,000 on PyPI

## Install

pip install redshift-connector
uv add redshift-connector
poetry add redshift-connector

## Description

=======================================================
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...

## AI interpretation — verify before relying

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.

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.

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