Odyssey
Odyssey: A focused, open-source pooler for PostgreSQL session and transaction workloads. Ranked #2 of 29 in Database Connection Pooling Software by our editors (9.1/10); pricing: Free plan; best for postgreSQL transaction and session pooling.
At a glance
- Editor score9.1 / 10
- PricingFree plan
- Best forPostgreSQL transaction and session pooling
- Free planYes
- Paid fromFree
- Transaction poolingYes
- Facts checked14 Nov 2026
Where it wins
- Multiplexes client connections through session and transaction pooling
- Per-database and per-user pool rules with configurable limits
- TLS, PAM, LDAP, backend routing, and load balancing options
Where it doesn't
- Self-hosted Linux deployment puts operations on your team
- Database support centers on PostgreSQL and Apache Cloudberry
- No AI features are provided
Our verdict on Odyssey
Odyssey is a self-hosted connection pooler and request router for PostgreSQL workloads. It is aimed at teams that need session or transaction pooling, connection limits, backend routing, and load balancing while keeping deployment under their control. The project runs on Linux, supports the PostgreSQL wire protocol, and is also identified as supporting Apache Cloudberry. Its multi-threaded design shares server connection pools across processing threads.
Odyssey is distributed as open source under the BSD-3-Clause license, with a free plan. Deployment is standalone and self-hosted, so teams manage installation, configuration, and operations on Linux. Configuration can set pool size and connection-acquisition timeouts, while pool rules are defined separately for each database and user. A pool size of zero disables the limit, allowing operators to choose how capacity is governed. These controls fit environments that need explicit connection policies rather than a managed service.
The product’s strongest depth is in PostgreSQL pooling behavior. Session, transaction, and statement modes are documented; transaction pooling multiplexes client connections over fewer PostgreSQL backends and supports prepared statements. TLS and authentication options include PAM and LDAP, and backend routing adds load-balancing controls. Choose Odyssey when PostgreSQL connection management, routing, and self-hosted control are priorities. Teams seeking a managed deployment, broader database coverage, or AI capabilities should consider alternatives with those characteristics.
Your product? Our editors can test Odyssey in depth and publish a review, labelled as paid · from $149/mo →
Odyssey pricing
Odyssey fact sheet
| Free plan | Yes |
|---|---|
| Paid from | Free |
| Transaction pooling | Yes |
| Pooling modes | session, transaction, statement |
| Deployment model | Standalone |
| Supported databases | PostgreSQL, Apache Cloudberry |
| Connection limit | Not verified |
| Protocol support | PostgreSQL wire protocol |
| Deployment | Self-hosted |
| Platforms | Linux |
| Built for | Small business, Mid-market, Enterprise (editorial estimate) |
| Pricing | Free plan |
| Website | odyssey.postgresql.org |
| Facts checked | 14 Nov 2026 |
Alternatives to Odyssey
- MariaDB MaxScaleSQL-aware pooling and routing for MariaDB and MySQL-compatible production environments.9.3
- PgBouncerA self-hosted PostgreSQL pooler with flexible modes and connection controls, but no built-in failover.8.9
- Apache Commons DBCPAn embeddable, open-source JDBC pool with configurable capacity, validation and cleanup.8.7
See all Odyssey alternatives →
Odyssey vs the competition
- Odyssey vs MariaDB MaxScale
- Odyssey vs PgBouncer
- Odyssey vs Apache Commons DBCP
- Odyssey vs Tomcat JDBC Connection Pool
- Odyssey vs Vert.x Reactive SQL Clients
- Odyssey vs Psycopg Pool
Compare Odyssey with any tool side by side →
Used Odyssey? 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 Odyssey 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
Odyssey 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/odyssey-database-connection-pooler/"><img src="https://www.itechguides.com/best/badge/odyssey-database-connection-pooler.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
