postgres
postgres is a high-value abstraction over psycopg2.
Decision gist · record as of 2026-08-14
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.AI-flagged interpretation of the facts on this page — verify before relying
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 · maintenance · safety
MIT (permissive) — Licensed under MIT (permissive), so you can use, modify, and distribute this package freely with minimal restrictions.
last release 2021-09-20 (1789 days) · last repo commit 2023-06-14 · 64 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 273,284 downloads/mo, #8,202 on PyPI
Alternatives
Verify before relying
pip install postgres
import postgres
db = postgres.connect('postgresql://user:password@localhost/dbname')
result = db.query('SELECT * FROM table')- 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.
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 on this page. Verify before relying on it.
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
postgres on PyPI
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 | Not specified |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 2 packagespsycopg2-binarypsycopg2-pool |
| Maintenance | Abandoned 1,789 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 273,284 / month, #8,202 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 :: MIT LicenseOperating System :: OS IndependentProgramming Language :: Python :: 3.6Programming Language :: Python :: 3.7Programming Language :: Python :: 3.8Programming Language :: Python :: 3.9Programming Language :: SQLTopic :: Database :: Front-EndsTopic :: Software Development :: Libraries :: Python Modules |
Evidence: postgres-4.0-py2.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 › “psycopg2 abstraction layer”
- postgresProvides a lightweight abstraction layer over psycopg2 for PostgreSQL…
- aws-psycopg2Provides psycopg2 with statically linked PostgreSQL libraries for use…
- opentelemetry-instrumentation-psycopg2Adds distributed tracing instrumentation to psycopg2 database…
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 pgdb · psycopg2-pool · psycopg · psycopg2 · queries · pgcopy · aws-psycopg2 · PyGreSQL · pykaos · psycopg-pool