PgDog
PgDog: A free PostgreSQL proxy with pooling, routing, replica balancing, and sharding. Ranked #8 of 31 in Database Proxy Software by our editors (8.4/10); pricing: Free plan; best for free PostgreSQL pooling and sharding.
At a glance
- Editor score8.4 / 10
- PricingFree plan
- Best forFree PostgreSQL pooling and sharding
- Free planYes
- Paid fromFree
- Deployment modelBoth
- Facts checked20 Sep 2026

Where it wins
- Free, open-source PostgreSQL connection pooling and multiplexing
- Combines routing, read/write splitting, lag monitoring, and sharding
- Runs on Windows, macOS, Linux, on-premises, or customer cloud accounts
Where it doesn't
- Supports PostgreSQL rather than multiple database engines
- Failover detection is disabled by default
- AGPLv3 licensing may not suit every deployment or distribution model
Our verdict on PgDog
PgDog is an open-source PostgreSQL proxy for teams that need to manage connection capacity, distribute reads across replicas, or route traffic across sharded databases. Its scope covers transaction-mode connection pooling, connection multiplexing, read/write query splitting, replica load balancing, query and shard routing, replication monitoring, and horizontal PostgreSQL sharding. It can run on Windows, macOS, and Linux, with deployment options spanning on-premises environments, a customer cloud account, and a managed Enterprise arrangement.
The free open-source edition provides a substantial set of database proxy capabilities without a separate software charge and is licensed under AGPLv3. The published product details also describe an Enterprise edition that requires a purchased license. PgDog is therefore a practical fit for teams that want to operate PostgreSQL infrastructure directly and need pooling, routing, health checks, hot configuration reloads, and TLS for client and server connections in one proxy. Its platform coverage is wider than many infrastructure tools, while its database support remains focused on PostgreSQL.
PgDog’s deeper operational features include configurable replica load-balancing strategies, replication lag monitoring with replica banning, automatic traffic switching after replica promotion, backend health checks, and horizontal sharding. These capabilities address deployments where connection management and traffic placement are closely related. There is an important operational condition: failover detection is disabled by default, and primary failure handling relies on external promotion tooling. Teams that need a PostgreSQL-focused proxy with free pooling and sharding should consider PgDog; organizations seeking multi-database support or failover behavior without external promotion tooling should look elsewhere.
Your product? Our editors can test PgDog in depth and publish a review, labelled as paid · from $149/mo →
PgDog pricing
PgDog fact sheet
| Free plan | Yes |
|---|---|
| Paid from | Free |
| Deployment model | Both |
| Connection pooling | Yes |
| Query routing | Yes |
| Load balancing | Yes |
| Automatic failover | Yes |
| Supported databases | PostgreSQL |
| Maximum connections | Not verified |
| Deployment | Cloud, Self-hosted |
| Platforms | Windows, macOS, Linux |
| Support | Email, Community, Docs |
| Built for | Small business, Mid-market, Enterprise (editorial estimate) |
| Pricing | Free plan |
| Website | pgdog.dev |
| Facts checked | 20 Sep 2026 |
Alternatives to PgDog
- Heimdall Database ProxyA broad database proxy with pooling, routing, analytics, security, and failover.9.4
- ProxySQLA free, open-source proxy for routing, pooling, balancing, and managing database traffic.9.2
- ShardingSphere-ProxyA self-hosted proxy for routing, scaling, and high availability across four database protocols.9.0
PgDog vs the competition
- PgDog vs Heimdall Database Proxy
- PgDog vs ProxySQL
- PgDog vs ShardingSphere-Proxy
- PgDog vs TurbineProxy
- PgDog vs HeliosProxy
- PgDog vs MariaDB MaxScale
Compare PgDog with any tool side by side →
Also Ranked In
PgDog is ranked in 2 of our directories.
Used PgDog? 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 PgDog 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
PgDog is listed in our Database Proxy Software directory. Add the badge to your site — it links back to this page.
<a href="https://www.itechguides.com/products/pgdog/"><img src="https://www.itechguides.com/best/badge/pgdog.svg" alt="Featured on iTechGuides" width="230" height="46"></a>
Reviewed by iTechGuides Editors · Editorial team · Updated Oct 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




