PgCat

At a glance

• Editor score
  7.5 / 10
• Pricing
  Free plan
• Best for
  PostgreSQL pooling with routing and replicas
• Free plan
  Yes
• Paid from
  Free
• Transaction pooling
  Yes
• Facts checked
  14 Nov 2026

• Where it wins

  • Supports both transaction and session pooling modes.
  • Routes reads to replicas and writes to a primary, with replica balancing.
  • Includes health checks, failover routing, and a Prometheus metrics endpoint.

• Where it doesn't

  • Requires teams to manage configuration and deployment themselves.
  • Supports PostgreSQL through the PostgreSQL wire protocol only.
  • Sharding and query mirroring are experimental.

Our verdict on PgCat

PgCat is an open-source connection pooler and proxy for teams operating PostgreSQL deployments that need to reuse server connections or route queries across a primary and replicas. It sits between applications and PostgreSQL servers, accepting connections through the PostgreSQL wire protocol. The project supports transaction and session pooling, so it can suit workloads that need either mode. Its focus is PostgreSQL rather than a general-purpose pooler for multiple database systems.

Routing and operations are central to PgCat’s feature set. It can send read queries to replicas and writes to a primary, balance load across replicas, and use health checks and failover routing. A Prometheus metrics endpoint provides an operational monitoring path. PgCat also documents PgBouncer-compatible admin databases and SHOW commands, plus live configuration reloading. These capabilities make it a fit for teams that want pooling alongside routing controls; teams seeking only a basic connection pool may not need the additional proxy features.

PgCat is self-hosted and self-managed: the project documents running it as a process with configurable pools and server connections. Connection capacity depends on configured pool_size values, so operators need to size and manage those settings for their deployment. The project is open source with a free plan, and documentation is the listed support channel. Sharding and query mirroring are experimental, so they are not the strongest reason to choose it. PgCat is a sensible option for teams comfortable operating PostgreSQL infrastructure; teams wanting a managed service or mature sharding and mirroring should look elsewhere.

Your product? Our editors can test PgCat in depth and publish a review, labelled as paid · from $149/mo →

PgCat pricing

PgCat fact sheet

Alternatives to PgCat

• MMMariaDB MaxScaleSQL-aware pooling and routing for MariaDB and MySQL-compatible production environments.9.3
• OOdysseyA focused, open-source pooler for PostgreSQL session and transaction workloads.9.1
• PgBouncerA self-hosted PostgreSQL pooler with flexible modes and connection controls, but no built-in failover.8.9

See all PgCat alternatives →

Featured on iTechGuides

PgCat 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/pgcat-database-connection-pooler/"><img src="https://www.itechguides.com/best/badge/pgcat-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 14 Nov 2026 · How we research and update