redshift-connector
Redshift interface library
Decision gist · record as of 2026-08-14
Yes. This is the official AWS Redshift driver for Python, actively maintained with no known vulnerabilities, low install friction, and a permissive license. It's suitable for production use if you need to connect Python applications to Redshift clusters. Install it if you're building Redshift-integrated data pipelines, analytics tools, or applications requiring direct SQL access to Redshift.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires valid AWS Redshift cluster credentials and network access to the cluster endpoint.
- Low install friction with a pure-Python wheel distribution.
- The package is actively maintained with a recent release 11 days ago and has been in production use since 2020.
License · maintenance · safety
Apache License 2.0 (permissive) — Licensed under Apache License 2.0, a permissive license that allows commercial and private use with minimal restrictions, making it suitable for most production environments.
last release 2026-08-03 (11 days) · last repo commit 2026-08-04 · 220 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 55,579,978 downloads/mo, #535 on PyPI
Alternatives
Verify before relying
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()- Performance characteristics and query execution speed relative to other Redshift drivers
- Specific version compatibility with particular Redshift cluster versions
- Memory overhead when handling large result sets
What it is and what it does
redshift_connector is the official Python database driver for Amazon Redshift. It implements the Python DB-API 2.0 specification, providing a standard interface for connecting to Redshift clusters, executing SQL queries, and retrieving results. The package supports both traditional username/password authentication and AWS IAM-based authentication, allowing flexible credential management.
The driver integrates with popular data science libraries like pandas and numpy, and supports Redshift-specific features including custom data types and identity provider authentication. It's a pure Python implementation with no compiled dependencies, distributed as a wheel, and actively maintained by AWS. The package is widely used in production environments and integrates with tools like Apache Airflow, SQLAlchemy, and Querybook.
Use it for
- Execute SQL queries and retrieve data from Redshift clusters in Python applications
- Load data into pandas DataFrames directly from Redshift for data analysis workflows
- Automate ETL pipelines using Redshift as a data source or destination
- Authenticate to Redshift using AWS IAM credentials instead of managing static passwords
- Build data applications that need standard DB-API 2.0 compliance for Redshift access
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes.
This is the official AWS Redshift driver for Python, actively maintained with no known vulnerabilities, low install friction, and a permissive license. It's suitable for production use if you need to connect Python applications to Redshift clusters. Install it if you're building Redshift-integrated data pipelines, analytics tools, or applications requiring direct SQL access to Redshift.
Install
redshift-connector on PyPI
Before you install
Low install friction with a pure-Python wheel distribution. The package is actively maintained with a recent release 11 days ago and has been in production use since 2020. Nine runtime dependencies are all well-established libraries (boto3, requests, beautifulsoup4, lxml, pytz, scramp, packaging, setuptools).
Requires valid AWS Redshift cluster credentials and network access to the cluster endpoint.
License in practice
Licensed under Apache License 2.0, a permissive license that allows commercial and private use with minimal restrictions, making it suitable for most production environments.
Quickstart
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()Verify before relying
- Performance characteristics and query execution speed relative to other Redshift drivers
- Specific version compatibility with particular Redshift cluster versions
- Memory overhead when handling large result sets
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 packagesscramppytzbeautifulsoup4boto3requestslxmlbotocorepackagingsetuptools |
| Maintenance | Actively maintained 11 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 55,579,978 / month, #535 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 :: 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 |
Evidence: redshift_connector-2.1.16-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 › “redshift database driver”
- redshift-connectorredshift_connector is a Python database driver for Amazon Redshift…
- sqlalchemy-redshiftProvides a SQLAlchemy dialect for Amazon Redshift, enabling ORM and…
- aws-cdk.aws-redshift-alphaDefines AWS Redshift clusters and database resources (users, tables)…
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 awswrangler · sqlalchemy-redshift · chalk-sqlalchemy-redshift · pydynamodb · pyathenajdbc · aurora-data-api · awslabs.redshift-mcp-server · PyAthena · yandex-query-client · cloud-sql-python-connector