pgdogdev/pgdog

Health v2 · maintenance only

Adoption not part of the score

5446 stars · 267 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded

PgDog is a PostgreSQL proxy written in Rust that combines connection pooling, query load balancing, and database sharding in a single binary. It sits transparently between applications and PostgreSQL, speaking the native wire protocol and SQL parser so no application changes are required.

Use cases

• pool postgres connections for thousands of app clients
• split read queries to replicas and writes to primary
• shard a postgresql database across multiple servers
• replace pgbouncer while keeping SET and LISTEN/NOTIFY working
• load balance reads across postgres replicas with health checks
• deploy a single database endpoint for kubernetes workloads
• detect primary failover and reroute write traffic

When to choose

• you need transaction-mode pooling that preserves session state like SET, advisory locks, and LISTEN/NOTIFY
• you want read/write splitting and replica load balancing behind one endpoint
• you need to scale Postgres horizontally with sharding without changing application code
• you want a fast, multithreaded pooler deployable via Docker, Helm, or Terraform

When to avoid

• you run a small database with few connections where a proxy adds unnecessary complexity
• you rely on sharding features still marked experimental in the docs
• you need a pooler for databases other than PostgreSQL
• your license requirements are incompatible with AGPL-3.0

Facets

service · maturity active

database proxy load-testing routing networking databases microservices backend self-hosted rust self-hosted cloud postgresql connection-pooler sharding load-balancer pgbouncer-alternative read-write-splitting database-proxy devops linux macos docker kubernetes

Member repositories

For agents

markdown · JSON · MCP: product_card(name="pgdogdev/pgdog")