database-connection-pooling
Installation
SKILL.md
Database Connections & Pooling
Use this skill when
- Configuring pool sizes
- Diagnosing connection exhaustion
- Handling timeouts and checkouts
Do not use this skill when
- Query/schema tuning
- Network-level tuning
Instructions
- Size pool to DB connection limits, not arbitrarily large.
- Balance waiting versus concurrent queries: small pools can beat big ones.
- Set idle timeout, max lifetime, and checkout timeout.
- Avoid holding connections during slow external calls.
- Watch for connection leaks (checkout without return).
- Use health checks to evict broken connections.
- Monitor active vs idle vs waiting.