---
id: sqlalchemy-pgspider
version: "0.1.0"
license: MIT
license_treatment: permissive
maintenance: abandoned
---

# sqlalchemy-pgspider — PGSpider Dialect for SQLAlchemy

License: permissive · Maintenance: abandoned · Downloads: 211.4K/mo

## What it is and what it does

sqlalchemy-pgspider is a SQLAlchemy dialect that bridges SQLAlchemy to PGSpider, a distributed PostgreSQL system. It inherits from SQLAlchemy's PostgreSQL dialect and overrides version-checking logic so that SQLAlchemy recognizes and connects to PGSpider instead of rejecting it as an unsupported database. The dialect retains full PostgreSQL functionality while working exclusively with the psycopg2 DBAPI driver.

You use it by specifying a pgspider:// or pgspider+psycopg2:// connection URL in SQLAlchemy's create_engine(), then interact with PGSpider through the standard SQLAlchemy Core and ORM interfaces. It is a thin adapter layer—all actual PostgreSQL features available in SQLAlchemy 1.4.28 remain available.

Use it for:

- Connect to a PGSpider distributed database cluster using SQLAlchemy ORM for application development
- Execute raw SQL queries against PGSpider through SQLAlchemy's text() interface
- Migrate an existing PostgreSQL + SQLAlchemy application to use PGSpider as the backend
- Build multi-node database applications that need transparent sharding via PGSpider

## Worth the install?

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

Provides a SQLAlchemy dialect that enables connections to PGSpider using SQLAlchemy's PostgreSQL interface and psycopg2 driver.

No. The package is abandoned (last release June 2023, no commits since) with zero community engagement. While the MIT license is permissive and install friction is low, the lack of maintenance means no fixes for compatibility issues with newer SQLAlchemy, psycopg2, or Python versions. Install only if you are locked into an old environment and PGSpider is a hard requirement; otherwise, seek an actively maintained alternative or contact the PGSpider project directly.

## Install

pip install sqlalchemy-pgspider
uv add sqlalchemy-pgspider
poetry add sqlalchemy-pgspider

## Installing sqlalchemy-pgspider

Before you install: Low install friction with a pure-Python wheel. However, the package is abandoned—last release was 2023-06-06 with no commits since, and it has zero repository stars. Maintenance has ceased.

License in practice: MIT license permits commercial and private use with minimal restrictions, requiring only license and copyright notice retention.

Quickstart:

pip install sqlalchemy-pgspider

from sqlalchemy import create_engine, text

engine = create_engine("pgspider+psycopg2://user:password@localhost:4813/dbname")
with engine.connect() as conn:
    result = conn.execute(text("SELECT * FROM table"))
    for row in result:
        print(row)

Requires SQLAlchemy 1.4.27 or higher, psycopg2 (or psycopg2-binary) 2.9 or higher, and Python 3.7 or higher. PGSpider instance must be running and accessible.

Verify before relying:

- Whether the package works with SQLAlchemy versions beyond 1.4.28 (documentation notes only 1.4.28 was tested)
- Current compatibility with modern psycopg2 versions and Python 3.10+ in practice
- Whether PGSpider itself is actively maintained and suitable for production use

## Package facts

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

## Tags

sqlalchemy pgspider dialect, pgspider database connection, sqlalchemy postgres fork, pgspider orm support, distributed postgres sqlalchemy, abandoned, pgspider, distributed-sql

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