chalk-sqlalchemy-redshift
Amazon Redshift Dialect for sqlalchemy (Chalk fork)
Decision gist · record as of 2026-08-14
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.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires either psycopg2, psycopg2-binary, psycopg2cffi, or redshift_connector to be installed separately; the dialect does not include a driver.
- 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 · maintenance · safety
MIT (permissive) — MIT license is permissive, allowing commercial and private use with minimal restrictions.
last release 2025-06-15 (425 days) · last repo commit 2025-06-15
0 known vulnerabilities (OSV.dev, 2026-08-14) · 228,293 downloads/mo, #9,155 on PyPI
Alternatives
Verify before relying
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'))- 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.
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 on this page. Verify before relying on it.
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
chalk-sqlalchemy-redshift on PyPI
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.
Requires either psycopg2, psycopg2-binary, psycopg2cffi, or redshift_connector to be installed separately; the dialect does not include a driver.
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'))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 the current Python release >=3.8 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 2 packagesSQLAlchemypackaging |
| Maintenance | Aging 425 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 228,293 / month, #9,155 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Development Status :: 4 - BetaEnvironment :: ConsoleIntended Audience :: DevelopersLicense :: OSI Approved :: MIT LicenseOperating System :: OS IndependentProgramming Language :: PythonProgramming Language :: Python :: 3Programming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.8Programming Language :: Python :: 3.9 |
Evidence: chalk_sqlalchemy_redshift-0.8.15.dev0-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 › “sqlalchemy redshift dialect”
- chalk-sqlalchemy-redshiftProvides a SQLAlchemy dialect for Amazon Redshift, enabling ORM and…
- sqlalchemy-redshiftProvides a SQLAlchemy dialect for Amazon Redshift, enabling ORM and…
- sqlalchemy-pgspiderProvides a SQLAlchemy dialect that enables connections to PGSpider…
Give your agent the search over MCP, or paste the wish link into any chat.
More Front-Ends packages
SQLAlchemy is a Python SQL toolkit and Object Relational Mapper (ORM) that provides both a high-level ORM layer for declarative object persistence and a Core SQL construction system for direct database abstraction and query building.
psycopg2-binary is a PostgreSQL database adapter for Python that implements the DB API 2.0 specification, enabling Python applications to connect to and query PostgreSQL databases with thread-safe concurrent operations.
Alembic generates and manages database schema migrations for SQLAlchemy applications, handling version control of database structure changes with support for upgrades, downgrades, and auto-generation from model changes.
Install it if you use SQLAlchemy and need to version-control schema changes; skip it only if you manage migrations manually or use a different ORM entirely.
A Python client library for connecting to and querying Weaviate, a vector database that enables semantic search and AI-powered data retrieval.
A Python client library that connects to Databricks clusters and SQL warehouses using a Thrift-based protocol, conforming to the Python DB API 2.0 specification and supporting Arrow-based data exchange.
Install it if you need to query Databricks clusters or SQL warehouses from Python.
Psycopg 3 is a PostgreSQL database adapter for Python that enables applications to connect to, query, and manage PostgreSQL databases using Python code.
Install it if you need to connect Python to PostgreSQL.
See also sqlalchemy-redshift · redshift-connector · sqlalchemy-cockroachdb · iomete-sqlalchemy · sqlalchemy-hana · sqlalchemy-risingwave · teradatasqlalchemy · sqlalchemy_exasol · sqlalchemy-pgspider · sqlalchemy-jdbcapi