Psycopg Pool
Psycopg Pool: An open-source Python pool with synchronous and asynchronous PostgreSQL support. Ranked #7 of 29 in Database Connection Pooling Software by our editors (8.3/10); pricing: Free plan; best for postgreSQL apps needing sync and async pools.
At a glance
- Editor score8.3 / 10
- PricingFree plan
- Best forPostgreSQL apps needing sync and async pools
- Free planYes
- Paid fromFree
- Transaction poolingNo
- Facts checked14 Nov 2026
Where it wins
- Synchronous and asynchronous pools support varied Python concurrency models
- Configurable sizing, queue timeouts, health checks, and lifecycle controls
- SQLAlchemy integration plus a null pool for non-retained connections
Where it doesn't
- Supports PostgreSQL rather than multiple database systems
- Embedded, self-hosted library requires application-level integration
- Provides connection pooling, not session, transaction, or statement modes
Our verdict on Psycopg Pool
Psycopg Pool is an open-source Python library for managing PostgreSQL connections inside an application. It is aimed at developers building Python services that need either synchronous pools for threaded applications or asynchronous pools for async code. The package runs as an embedded, self-hosted component on Linux, macOS, and Windows, and supports PostgreSQL through PostgreSQL client connections. It fits solo developers through enterprise teams that want pooling in their own application rather than a hosted pooler.
The published distribution is open source with a free plan, rather than a set of commercial tiers. Developers can install the pool separately as the psycopg[pool] extra or as psycopg_pool. Configuration covers minimum and maximum pool size, queueing and timeouts while waiting for a connection, and connection lifecycle limits such as maximum lifetime and idle time. Health-check, connection-configuration, and reset callbacks provide control around connection handling. Context-manager use can commit or roll back transactions and return connections to the pool, while the null connection pool variant avoids retaining unused connections.
Psycopg Pool’s ecosystem fit is practical for Python applications that already use PostgreSQL, including projects integrating with SQLAlchemy. Its focus stays on connection pooling: the documented mode is connection pooling rather than session, transaction, or statement pooling. Teams seeking a PostgreSQL-focused library with both sync and async APIs, explicit sizing, and callback hooks should consider it. Organizations needing a hosted service, support beyond documentation, or pooling across different database systems should choose a broader alternative.
Your product? Our editors can test Psycopg Pool in depth and publish a review, labelled as paid · from $149/mo →
Psycopg Pool pricing
Psycopg Pool fact sheet
| Free plan | Yes |
|---|---|
| Paid from | Free |
| Transaction pooling | No |
| Pooling modes | connection pooling; no session, transaction, or statement modes documented |
| Deployment model | Embedded |
| Supported databases | PostgreSQL |
| Connection limit | Not verified |
| Protocol support | PostgreSQL wire protocol (via PostgreSQL client connections) |
| Deployment | Self-hosted |
| Platforms | Linux, macOS, Windows |
| Support | Docs |
| Built for | Solo, Small business, Mid-market, Enterprise (editorial estimate) |
| Integrations | 1 integrations: SQLAlchemy |
| Pricing | Free plan |
| Website | psycopg.org |
| Facts checked | 14 Nov 2026 |
Psycopg Pool integrations
Psycopg Pool lists 1 integrations on its own site.
- SQLAlchemy
Alternatives to Psycopg Pool
- MariaDB MaxScaleSQL-aware pooling and routing for MariaDB and MySQL-compatible production environments.9.3
- OdysseyA focused, open-source pooler for PostgreSQL session and transaction workloads.9.1
- PgBouncerA self-hosted PostgreSQL pooler with flexible modes and connection controls, but no built-in failover.8.9
See all Psycopg Pool alternatives →
Psycopg Pool vs the competition
- Psycopg Pool vs MariaDB MaxScale
- Psycopg Pool vs Odyssey
- Psycopg Pool vs PgBouncer
- Psycopg Pool vs Apache Commons DBCP
- Psycopg Pool vs Tomcat JDBC Connection Pool
- Psycopg Pool vs Vert.x Reactive SQL Clients
Compare Psycopg Pool with any tool side by side →
Used Psycopg Pool? Be the first to review it
The editor score above is our own research. What this page doesn't have yet is a reader's view — what you used Psycopg Pool for, what worked and what didn't. No stars are seeded and no review is paid for; an editor reads every one before it appears.
Write a reviewTwo minutes · verified accounts only · read by an editor before it appears
Featured on iTechGuides
Psycopg Pool is listed in our Database Connection Pooling Software directory. Add the badge to your site — it links back to this page.
<a href="https://www.itechguides.com/products/psycopg-pool/"><img src="https://www.itechguides.com/best/badge/psycopg-pool.svg" alt="Featured on iTechGuides" width="230" height="46"></a>
Reviewed by iTechGuides Editors · Editorial team · Updated Nov 2026
Advertiser disclosure: iTechGuides is reader-supported. Vendors can pay for top positions in our rankings and for a place on other products' pages, and we may earn a commission when you click some links. Bought places stand at the number bought; this page and our disclosure say so. Paying vendors may get a fuller, more detailed review from our editors, and that review can change their score. How we rank.
Last updated · How we research and update