psycopg-pool
Connection Pool for Psycopg
Decision gist · record as of 2026-08-14
Yes, if you use Psycopg 3 and make frequent database queries. The package is production-stable, actively maintained, has no known vulnerabilities, and adds minimal install friction. The copyleft license (LGPL-3.0-only) requires disclosure of modifications but is compatible with most open-source and many commercial projects; review your licensing obligations if proprietary.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires Python 3.10 or later; psycopg-pool is an optional component of Psycopg 3 and depends on that library.
- Low install friction with a single lightweight runtime dependency (typing-extensions).
- Active maintenance with recent commits and stable production status; last release 105 days ago.
License · maintenance · safety
LGPL-3.0-only (copyleft) — Licensed under LGPL-3.0-only (copyleft). You must disclose source code modifications and make the license available to users; proprietary applications should review copyleft obligations before use.
last release 2026-05-01 (105 days) · last repo commit 2026-08-01 · 2,475 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 32,651,920 downloads/mo, #773 on PyPI
Alternatives
Verify before relying
pip install psycopg-pool
from psycopg_pool import ConnectionPool
pool = ConnectionPool("postgresql://localhost/mydb")
with pool.connection() as conn:
with conn.cursor() as cur:
cur.execute("SELECT 1")- Whether the pool supports async/await patterns or is synchronous-only
- Specific pool sizing limits and tuning parameters available
- Performance benchmarks or overhead reduction claims compared to direct connections
What it is and what it does
psycopg-pool is the optional connection pooling component of Psycopg 3, the modern PostgreSQL adapter for Python. It manages a reusable pool of database connections, eliminating the overhead of creating and destroying connections for each query. The pool is kept as a separate package to allow independent release cycles from the main library.
The package is designed for applications that need to handle multiple concurrent database operations efficiently. It integrates with Psycopg 3 and requires only typing-extensions as a runtime dependency, making it lightweight to install. It supports Python 3.10 through 3.14 and runs on CPython and PyPy across macOS, Windows, and POSIX systems.
Use it for
- Web applications handling many concurrent requests that each need database access
- Long-running services that repeatedly query PostgreSQL without recreating connections
- Multi-threaded or async applications where connection overhead is a bottleneck
- Containerized apps where connection limits are constrained
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes, if you use Psycopg 3 and make frequent database queries.
The package is production-stable, actively maintained, has no known vulnerabilities, and adds minimal install friction. The copyleft license (LGPL-3.0-only) requires disclosure of modifications but is compatible with most open-source and many commercial projects; review your licensing obligations if proprietary.
Install
psycopg-pool on PyPI
Before you install
Low install friction with a single lightweight runtime dependency (typing-extensions). Active maintenance with recent commits and stable production status; last release 105 days ago.
Requires Python 3.10 or later; psycopg-pool is an optional component of Psycopg 3 and depends on that library.
License in practice
Licensed under LGPL-3.0-only (copyleft). You must disclose source code modifications and make the license available to users; proprietary applications should review copyleft obligations before use.
Quickstart
pip install psycopg-pool
from psycopg_pool import ConnectionPool
pool = ConnectionPool("postgresql://localhost/mydb")
with pool.connection() as conn:
with conn.cursor() as cur:
cur.execute("SELECT 1")Verify before relying
- Whether the pool supports async/await patterns or is synchronous-only
- Specific pool sizing limits and tuning parameters available
- Performance benchmarks or overhead reduction claims compared to direct connections
Package facts
| License | LGPL-3.0-only copyleft |
| Python support | Supports the current Python release >=3.10 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 1 packagetyping-extensions |
| Maintenance | Actively maintained 105 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 32,651,920 / month, #773 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 :: DevelopersOperating System :: MacOS :: MacOS XOperating System :: Microsoft :: WindowsOperating System :: POSIXProgramming Language :: Python :: 3 :: OnlyProgramming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.13Programming Language :: Python :: 3.14Programming Language :: Python :: Implementation :: CPythonProgramming Language :: Python :: Implementation :: PyPyTopic :: DatabaseTopic :: Database :: Front-EndsTopic :: Software DevelopmentTopic :: Software Development :: Libraries :: Python Modules |
Evidence: psycopg_pool-3.3.1-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 › “postgresql connection pool”
- psycopg-poolProvides a connection pool for Psycopg 3, managing reusable…
- psycopg2-poolManages a pool of reusable PostgreSQL connections via psycopg2,…
- django-db-geventpoolProvides a gevent-based connection pool for Django's PostgreSQL…
Give your agent the search over MCP, or paste the wish link into any chat.
More Software Development packages
Provides backported and experimental type hints for Python 3.9+, allowing use of newer typing features on older Python versions and enabling early experimentation with type system PEPs before they enter the standard library.
NumPy provides an N-dimensional array object and a comprehensive suite of mathematical, linear algebra, Fourier transform, and random number functions for scientific computing in Python.
FastAPI is a Python web framework for building REST APIs using type hints, with automatic request validation, serialization, and interactive API documentation.
Provides a way to document function parameters, class attributes, return types, and variables inline using Python's `Annotated` type hint syntax instead of traditional docstrings.
Typer builds command-line applications from Python functions using type hints, automatically generating help text, argument parsing, and shell completion.
Install it if you are building CLIs in Python.
Distlib provides low-level packaging utilities for building, distributing, and managing Python software—including metadata handling, version specifiers, wheel support, script installation, and dependency resolution.
See also django-db-geventpool · psycopg · psycopg2-pool · django-db-connection-pool · psycopg-binary · psycopg-c · connection_pool · postgres · psycopg2-binary · psycopg2