pgbouncer-pool-modes

Official

Tune PgBouncer pool modes for resilient apps.

AuthorMercurium-Analytics
Version1.0.0
Installs0

System Documentation

What problem does it solve?

PgBouncer pool modes determine how database connections are reused and can cause migrations to fail, prepared statements to break, or under- or over-utilization of connections if misconfigured.

Core Features & Use Cases

  • Guides optimal pool_mode selection (transaction, session, and statement) for Postgres behind PgBouncer across common stacks like Django, FastAPI, and Celery.
  • Outlines safe migration connectivity strategies, recommended defaults for pool sizing, and best practices to avoid prepared-statement issues.
  • Provides concrete use cases showing when to prefer each pool mode and how to avoid common pitfalls under load.

Quick Start

Explain how to configure PgBouncer pool_mode and related settings for a Django/FastAPI/Celery deployment behind PgBouncer.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: pgbouncer-pool-modes
Download link: https://github.com/Mercurium-Analytics/pg-search-vector/archive/main.zip#pgbouncer-pool-modes

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.