PyGreSQL
Python PostgreSQL interfaces
Decision gist · record as of 2026-08-14
Yes, if you need a lightweight, direct PostgreSQL interface and can manage the libpq system dependency. The package is mature and stable with no known vulnerabilities, but maintenance is aging—releases come infrequently. Suitable for established projects or where libpq is already present; consider a more actively maintained driver like psycopg if you are starting a new project or need frequent updates.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- libpq shared library must be installed and accessible on the client machine; PostgreSQL server versions 12 to 18 are supported.
- Medium install friction due to compiled C extension and requirement for libpq system library on the client machine.
- Package is mature (since 2006) with aging maintenance status—last release 201 days ago, but repository remains active with recent commits.
License · maintenance · safety
PostgreSQL (unclear) — License treatment is marked unclear; the SPDX identifier is PostgreSQL, which is permissive, but raw license metadata is absent from the package metadata. Verify the actual license terms before adopting in proprietary or restricted contexts.
last release 2026-01-25 (201 days) · last repo commit 2026-01-26 · 48 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 363,428 downloads/mo, #7,221 on PyPI
Alternatives
Verify before relying
pip install PyGreSQL
import pygresql.pg as pg
conn = pg.connect('localhost', 'mydb', user='postgres')
result = conn.query('SELECT * FROM mytable')
conn.close()- Specific performance characteristics or throughput compared to other PostgreSQL adapters.
- Whether the PostgreSQL license treatment applies uniformly across all distributions or platforms.
- Current adoption rate and community activity beyond the core maintainers.
What it is and what it does
PyGreSQL is a mature Python module that provides direct access to PostgreSQL databases by wrapping the lower-level libpq C library. It has been in active development since 2006 and supports Python 3.8 through 3.14 on the server side with PostgreSQL versions 12 to 18. The package offers a straightforward way to connect to a database, execute queries, and retrieve results without requiring an ORM or higher-level abstraction layer.
The package is classified as mature but shows aging maintenance signals—the last release was 201 days ago, though the repository remains active. Installation requires both the PyGreSQL package itself and the libpq system library to be present on your client machine, which adds some setup friction compared to pure-Python database drivers. It has no runtime Python dependencies, making it lightweight once installed.
Use it for
- Direct PostgreSQL queries in scripts or applications where a lightweight, low-level interface is preferred over an ORM.
- Legacy Python codebases that already use PyGreSQL and need to remain on a maintained version.
- Systems where libpq is already available and you want to avoid additional abstraction layers.
- Database administration or reporting tools that need efficient, direct SQL execution.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes, if you need a lightweight, direct PostgreSQL interface and can manage the libpq system dependency.
The package is mature and stable with no known vulnerabilities, but maintenance is aging—releases come infrequently. Suitable for established projects or where libpq is already present; consider a more actively maintained driver like psycopg if you are starting a new project or need frequent updates.
Install
pygresql on PyPI
Before you install
Medium install friction due to compiled C extension and requirement for libpq system library on the client machine. Package is mature (since 2006) with aging maintenance status—last release 201 days ago, but repository remains active with recent commits.
libpq shared library must be installed and accessible on the client machine; PostgreSQL server versions 12 to 18 are supported.
License in practice
License treatment is marked unclear; the SPDX identifier is PostgreSQL, which is permissive, but raw license metadata is absent from the package metadata. Verify the actual license terms before adopting in proprietary or restricted contexts.
Quickstart
pip install PyGreSQL
import pygresql.pg as pg
conn = pg.connect('localhost', 'mydb', user='postgres')
result = conn.query('SELECT * FROM mytable')
conn.close()Verify before relying
- Specific performance characteristics or throughput compared to other PostgreSQL adapters.
- Whether the PostgreSQL license treatment applies uniformly across all distributions or platforms.
- Current adoption rate and community activity beyond the core maintainers.
Package facts
| License | PostgreSQL unclear |
| Python support | Supports the current Python release >=3.8 |
| Install friction | Medium. Platform-specific wheel |
| Runtime dependencies | None |
| Maintenance | Aging 201 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 363,428 / month, #7,221 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Development Status :: 6 - MatureIntended Audience :: DevelopersOperating System :: OS IndependentProgramming Language :: CProgramming Language :: PythonProgramming Language :: Python :: 3Programming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.13Programming Language :: Python :: 3.14Programming Language :: Python :: 3.8Programming Language :: Python :: 3.9Programming Language :: SQLTopic :: DatabaseTopic :: Database :: Front-EndsTopic :: Software Development :: Libraries :: Python Modules |
Evidence: pygresql-6.2.3-cp310-cp310-win_amd64.whl; pygresql-6.2.3-cp311-cp311-win_amd64.whl; pygresql-6.2.3-cp312-cp312-win_amd64.whl; pygresql-6.2.3-cp313-cp313-win_amd64.whl; pygresql-6.2.3-cp314-cp314-win_amd64.whl; pygresql-6.2.3-cp39-cp39-win_amd64.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 › “libpq python wrapper”
- PyGreSQLPyGreSQL is a Python interface to PostgreSQL databases that wraps the…
- adbc-driver-postgresqlProvides a DBAPI 2.0-compatible Python interface to PostgreSQL via…
- aws-psycopg2Provides psycopg2 with statically linked PostgreSQL libraries for use…
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 psycopg2 · psycopg · psycopg2-binary · adbc-driver-postgresql · postgres · pg8000 · pgdb · aws-psycopg2 · DBUtils · psycopg-binary