PgBouncer

Lightweight PostgreSQL connection pooler.

Provider: default
Kind: Database proxy
Category: Data
Official docs: https://www.pgbouncer.org/config.html

Properties · 2 set by this component

property	type	values	required	kind default	this component
defaultPoolSize · component property	integer	—	no	20	inherited
hedging · advanced	boolean	—	no	false	inherited
loadShedding · advanced	boolean	—	no	false	inherited
managed	boolean	—	no	false	inherited
maxClientConn · component property	integer	—	no	100	inherited
poolMode · component property	enum	session \| transaction \| statement	no	session	inherited
poolSharded · advanced	boolean	—	no	false	inherited
pooling	boolean	—	no	true	▸ true
requestCoalescing · advanced	boolean	—	no	false	inherited
routing	enum	none \| shard-key \| lookup	no	none	▸ none
scatterGather · advanced	boolean	—	no	false	inherited

Rules that apply · 0

Every rule whose selector covers this component's kind or its category. Whether a rule fires depends on the design: its properties, its edges and its groups.

No rule reads this kind yet. That is a gap, not a guarantee.

Use it in a design

nodes:
  - { id: "pgbouncer", component: "pgbouncer" }

Other Database proxy products · 13

Amazon RDS Proxyrds-proxyawsdatabase-proxy Cloudflare Hyperdrivecloudflare-hyperdrivecloudflaredatabase-proxy Generic database proxydatabase-proxydatabase-proxy MariaDB MaxScalemaxscaledatabase-proxy mongosmongosdatabase-proxy Odysseyodysseydatabase-proxy PgCatpgcatdatabase-proxy Pgpool-IIpgpooldatabase-proxy ProxySQLproxysqldatabase-proxy Supavisorsupavisordatabase-proxy Vitessvitessdatabase-proxy Cloud SQL Auth Proxygoogle-cloud-sql-auth-proxygcpdatabase-proxy IBM Data Virtualizationibm-data-virtualizationibmdatabase-proxy

Source

1# yaml-language-server: $schema=../../schema/component.schema.json
2# PgBouncer: lightweight PostgreSQL connection pooler; session pooling by default, no routing.
3schemaVersion: "1"
4type: "component"
5id: "pgbouncer"
6kind: "database-proxy"
7provider: "default"
8docs: "https://www.pgbouncer.org/config.html"
9defaults:
10  pooling: true
11  routing: "none"
12properties:
13  poolMode:
14    type: "enum"
15    values: ["session", "transaction", "statement"]
16    default: "session"
17  maxClientConn:
18    type: "integer"
19    default: 100
20  defaultPoolSize:
21    type: "integer"
22    default: 20

The same page as markdown, for an agent: /catalogue/components/pgbouncer.md