psycopg/psycopg
New generation PostgreSQL database adapter for the Python programming language observed · 2026-08-28
Health v2 · maintenance only
77/100
- Activity 99
- Release rhythm 35
- Longevity 100
Flags: no_releases
How is this computed?
round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10) — computed 2026-09-03. Adoption (stars, forks) is never an input.
- gap_med: n/a
- age_days: 2362
- days_rel: n/a
- days_push: 7
- n_releases_24m: 0
Adoption not part of the score
2479 stars · 268 forks observed · 2026-08-28
What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded
Psycopg 3 is the modern generation PostgreSQL database adapter for Python, offering both pure Python and C-accelerated implementations plus connection pooling. It is the successor to the widely used psycopg2 library.
Use cases
- connect to postgresql from python
- run sql queries against a postgres database
- use connection pooling for postgres in a web app
- async postgres access with asyncio
- migrate from psycopg2 to a modern driver
- insert and query b data from python
When to choose
- you need a maintained, modern PostgreSQL driver for Python
- you want async support or connection pooling built in
- you are starting a new Python project using PostgreSQL
When to avoid
- you must maintain legacy code tightly coupled to psycopg2 APIs
- you need a database other than PostgreSQL
Facets
library · maturity active
database-driver database databases backend developer-tools python cross-platform postgresql psycopg3 libpq connection-pooling async-support
3 sources
- readme: https://github.com/psycopg/psycopg · fetched 2026-08-28 · 4974cd21d3e1
- homepage: https://www.psycopg.org/psycopg3/ · fetched 2026-08-29 · 306ae57e01b6
- registry_pypi: https://pypi.org/pypi/psycopg/json · fetched 2026-08-29 · da1824261531
Member repositories
| Repository | Role | Health v2 |
|---|---|---|
| psycopg/psycopg | main | 77 |
For agents
Data as of 2026-08-30T08:39:29.467469+00:00 · Report a problem