Open-source PostgreSQL connection pooler, load balancer, and sharding proxy.
What it does
Multiplexes thousands of client connections over a tiny pool of Postgres server connections using real transaction mode.
Distributes read queries across replicas and handles automatic primary failover detection like an application load balancer.
Automatically routes queries and shards data across multiple databases without requiring database extensions or application rewrites.
Executes atomic cross-shard transactions utilizing native Postgres prepared transactions and two-phase commit protocols.
Why it works
Open-source licensing model ensures total transparency, community contribution, and free self-hosted deployment.
Eliminates leaky abstractions by supporting native session states, SET commands, and advisory locks without connection pinning.
Written in Rust to deliver multi-threaded, asynchronous performance capable of handling massive query throughput safely.
Requires zero application code modifications or proprietary database extensions to achieve horizontal sharding.
Open-source PostgreSQL connection pooler, load balancer, and sharding proxy.
Overview
PgDog is a high-performance, open-source clustering middleware and proxy designed specifically for PostgreSQL. Written in Rust, it acts as a connection pooler, read-replicas load balancer, and database sharder without requiring application code changes. It preserves full session state compatibility, supports cross-shard atomic transactions, and handles heavy workloads efficiently. By sitting transparently between apps and databases, it scales Postgres infrastructure seamlessly.
Founded year:2026
Founder:Lev Kokotov, Justin
Team size:2-10
Popularity:2M+ queries per second in production across deployments
Open-source licensing model ensures total transparency, community contribution, and free self-hosted deployment.
Eliminates leaky abstractions by supporting native session states, SET commands, and advisory locks without connection pinning.
Written in Rust to deliver multi-threaded, asynchronous performance capable of handling massive query throughput safely.
Requires zero application code modifications or proprietary database extensions to achieve horizontal sharding.
Founder story
PgDog was founded by Lev Kokotov, a technical founder with extensive background scaling large database systems at companies like Instacart. Recognizing the limitations of existing PostgreSQL routing and connection tools, the creator built a fast, extension-free Rust proxy to handle transparent sharding, load balancing, and connection pooling under heavy production traffic.
Alternatives
Comparison overview
Traditional tools like PgBouncer introduce leaky abstractions that break session state features or require application rewrites.
PgDog provides built-in query parsing, transparent sharding, and real transaction mode pooling while maintaining full Postgres compliance.