Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

PgCat

github.com

  • Free plan
  • Linux
  • Self-hosted
6.9 Club score Visit github.com

What PgCat is

PgCat is a free, open-source PostgreSQL pooler and proxy for self-hosted Linux deployments. Its stable pooling options include transaction and session pooling. Read queries can be distributed across replicas and the primary, while health checks detect broken replicas and redirect queries to servers that remain available. PgCat uses Tokio’s asynchronous runtime and a multithreaded design for multicore machines. Operators can inspect pool statistics through the pgcat and pgbouncer admin databases or a Prometheus HTTP endpoint. Client and server connections can use SSL/TLS, and authentication supports MD5 and SCRAM-SHA-256. MD5 passthrough can use auth_query so cleartext passwords are not needed in the configuration file. Docker deployment is documented, and the project publishes a container image. Sharding syntax, automatic sharding, comment parsing, and mirroring are experimental. Transaction mode is enabled by default and does not support prepared statements, SET, or advisory locks. PgCat is licensed under MIT.

Who it suits

PgCat suits teams running PostgreSQL on self-hosted Linux that need connection pooling, query routing, or read balancing. Operators should consider its experimental sharding and mirroring features and transaction-mode limits.

Good to know, and what to watch

  • Stable transaction and session pooling.
  • Health checks reroute queries from broken replicas.
  • Statistics are available through admin databases and Prometheus.
  • SSL/TLS and MD5 or SCRAM-SHA-256 authentication are supported.
  • Free and open source under the MIT license.
  • Sharding and mirroring features are experimental.
  • Transaction mode does not support prepared statements.
  • Transaction mode does not support SET or advisory locks.

Open source

Free

Free plan

The verdict

PgCat offers PostgreSQL pooling, routing, monitoring, and failover in a free, self-hosted package. Its experimental features and transaction-mode restrictions matter when deciding how to deploy it.

What the maker publishes

Authentication
MD5 auth passthrough can use auth_query so cleartext passwords are not required in the configuration file. source
Deployment
The project documents Docker deployment and publishes ghcr.io/postgresml/pgcat:latest. source
Failover
Broken replicas are detected with health checks and queries are rerouted to remaining servers. source
License
PgCat is free and open source under the MIT license. source
Maker
PostgresML was founded in 2022 by engineers who built Instacart’s machine learning platform. source
Mirroring
Mirroring is an experimental feature that sends queries to multiple databases for testing or replica prewarning. source
Monitoring
Pooler statistics are available through the pgcat and pgbouncer admin databases and through a Prometheus HTTP endpoint. source
Pooling
Transaction pooling and session pooling are stable features. source
Production status
The project says PgCat is stable and used in production to serve hundreds of thousands of queries per second. source
Purpose
PgCat is a PostgreSQL pooler and proxy supporting sharding, load balancing, failover and mirroring. source
Read balancing
Read queries can be automatically load balanced between replicas and the primary. source
Runtime
PgCat uses Tokio’s asynchronous runtime and a multithreaded design for multicore machines. source
Security
Clients and PostgreSQL servers can use SSL/TLS, and authentication supports MD5 and SCRAM-SHA-256 connections. source
Sharding
Extended SQL syntax, comment parsing and automatic sharding are experimental features. source
Transaction-mode limit
Transaction mode is enabled by default and does not support prepared statements, SET or advisory locks. source

Checked against the maker's pages on 1 Oct 2026.