---
id: postgres
version: "4.0"
license: MIT
license_treatment: permissive
maintenance: abandoned
---

# postgres — postgres is a high-value abstraction over psycopg2.

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

## What it is and what it does

postgres is a thin wrapper around psycopg2 that aims to reduce boilerplate when working with PostgreSQL databases in Python. It sits between your application and psycopg2-binary and psycopg2-pool, providing convenience methods for common database operations. The package is marked as Production/Stable in its classifiers and supports Python 3.6 through 3.9, though it has not been actively maintained since 2021-09-20.

Because the package is abandoned with no commits since 2023-06-14, it may not work reliably with current versions of psycopg2-binary, psycopg2-pool, or modern PostgreSQL server versions. Using it in new projects carries the risk of encountering unfixed bugs or compatibility issues.

Use it for:

- Maintaining existing codebases already using postgres that need to remain on stable, tested versions.
- Educational projects exploring database abstraction patterns without committing to a full ORM.
- Legacy applications where replacing the database layer would be costly and the current version works.
- Quick prototyping when you want less boilerplate than raw psycopg2 and accept maintenance risk.

## Worth the install?

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

Provides a lightweight abstraction layer over psycopg2 for PostgreSQL database access, simplifying common query patterns and connection management.

No, not for new projects. The package is abandoned with no updates since 2021-09-20 and no commits since 2023-06-14. While it has low install friction and a permissive MIT license, the lack of maintenance means you will not receive security patches or bug fixes. For new PostgreSQL work, use psycopg2-binary directly or choose an actively maintained abstraction. Only consider it if maintaining existing code already using it.

## Install

pip install postgres
uv add postgres
poetry add postgres

## Installing postgres

Before you install: Installation is straightforward with low friction, but the package is abandoned with no commits since 2023-06-14. The last release was 2021-09-20, meaning security patches and compatibility updates are unlikely.

License in practice: Licensed under MIT (permissive), so you can use, modify, and distribute this package freely with minimal restrictions.

Quickstart:

pip install postgres
import postgres
db = postgres.connect('postgresql://user:password@localhost/dbname')
result = db.query('SELECT * FROM table')

Verify before relying:

- Whether the abstraction layer's API remains compatible with current psycopg2-binary and psycopg2-pool versions.
- What specific high-value abstractions this package provides beyond psycopg2's native interface.
- Compatibility with Python versions beyond 3.9 given the abandoned maintenance status.

## Package facts

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

## Tags

postgresql database wrapper, psycopg2 abstraction layer, postgres python client, sql query helper, database connection pool, postgres connection management, abandoned, psycopg2-wrapper

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