---
id: chalk-sqlalchemy-redshift
version: "0.8.15.dev0"
license: MIT
license_treatment: permissive
maintenance: aging
---

# chalk-sqlalchemy-redshift — Amazon Redshift Dialect for sqlalchemy (Chalk fork)

License: permissive · Maintenance: aging · Downloads: 228.3K/mo

## What it is and what it does

This package is a SQLAlchemy dialect that translates SQLAlchemy's ORM and expression language into Redshift-compatible SQL. It acts as a bridge between your Python application and Amazon Redshift clusters, allowing you to define tables, run queries, and manage schemas using SQLAlchemy's familiar API instead of raw SQL.

The dialect handles Redshift-specific features like materialized views, spectrum support, and Redshift data types (GEOMETRY, SUPER, HLLSKETCH, TIMETZ). It requires either psycopg2 or redshift_connector as a separate installation to actually connect to Redshift; the dialect itself provides only the SQL translation and connection configuration. Recent versions support SQLAlchemy 1.4.x and 2.0.x, and Python 3.8 through 3.12.

Use it for:

- Define and manage Redshift tables using SQLAlchemy ORM models instead of raw DDL statements.
- Run parameterized queries and aggregations against Redshift using SQLAlchemy's expression language.
- Reflect existing Redshift schemas into Python objects for introspection and dynamic query building.
- Integrate Redshift as a data warehouse backend in a larger Python application using SQLAlchemy's session and connection pooling.
- Support Alembic migrations for Redshift schema changes with column comment support.

## Worth the install?

AI-flagged interpretation of the facts above — verify before relying.

Provides a SQLAlchemy dialect for Amazon Redshift, enabling ORM and SQL expression language support against Redshift clusters via psycopg2 or redshift_connector.

Yes, with conditions. The package is permissively licensed and has low install friction. However, the current version (0.8.15.dev0) is a development release with no changelog entries, and the last stable release was 425 days ago. If you need Redshift support in SQLAlchemy, this is the standard dialect, but verify that the development release is stable for your use case or pin to a stable release. You must separately install psycopg2 or redshift_connector.

## Install

pip install chalk-sqlalchemy-redshift
uv add chalk-sqlalchemy-redshift
poetry add chalk-sqlalchemy-redshift

## Installing chalk-sqlalchemy-redshift

Before you install: Low install friction with only two runtime dependencies (SQLAlchemy and packaging). Maintenance status is aging—last release was 425 days ago and the current version is a development release (0.8.15.dev0), though the repository remains active with a recent commit on 2025-06-15.

License in practice: MIT license is permissive, allowing commercial and private use with minimal restrictions.

Quickstart:

pip install chalk-sqlalchemy-redshift

import sqlalchemy as sa
engine = sa.create_engine('redshift+psycopg2://username@host.amazonaws.com:5439/database')
with engine.connect() as conn:
    result = conn.execute(sa.text('SELECT 1'))

Requires either psycopg2, psycopg2-binary, psycopg2cffi, or redshift_connector to be installed separately; the dialect does not include a driver.

Verify before relying:

- Whether the 0.8.15.dev0 development release is stable enough for production use or if a stable 0.8.14 release should be preferred.
- Current compatibility status with recent SQLAlchemy versions beyond what the changelog explicitly documents.
- Whether redshift_connector is now the recommended driver over psycopg2 for new projects.

## Package facts

- License: MIT (permissive)
- Python support: supports_current
- Install friction: low
- Maintenance: aging
- Downloads: 228.3K/month (top 15,000 on PyPI)
- Known vulnerabilities: none known

## Tags

sqlalchemy redshift dialect, redshift database orm, amazon redshift sqlalchemy, redshift sql adapter, redshift connection pooling, redshift table reflection, redshift ddl compiler, redshift, sqlalchemy-dialect, aws

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