词映 AI导航
工具库Skills 技能
我的收藏
词映 AI导航

Database Connection Pooler Skill for PostgreSQL Budgets

Check total PostgreSQL capacity against application pool limits, service replicas, and observed waits.

中文

Install in Claude Code

Use your own local PostgreSQL database and an application connection pool. PgBouncer can be added locally.

  1. Get the complete `plugins/database/database-connection-pooler/skills/optimizing-database-connection-pooling` directory from the pinned GitHub commit.
  2. Copy it into the target project's `.claude/skills/`. Check `.claude/skills/optimizing-database-connection-pooling/SKILL.md`, start Claude Code at the project root, and call `/optimizing-database-connection-pooling`.

Example task

Assume 100 database connections and reserve 20 for other work. Use four replicas with pool maximum 15 and observe waiting under local test connections.

What to check

Application pools request at most 60, leaving 20 slots in their budget of 80. Record assumptions and measurements.

Original SKILL.md on GitHub · Updated

Frequently asked question

Is a single pool maximum of 60 always below the database limit?

Multiply by replica count and include other consumers. Recheck after autoscaling changes.