Connection Pool Tuner

Tune database connection pool settings for optimal performance based on your workload characteristics.

Usage

Describe your application's database usage patterns and this skill will recommend optimal connection pool settings.

Examples

• "What pool size should I use for a Node.js app with 4 workers?"
• "Configure PgBouncer for 500 concurrent application connections"
• "My app is running out of database connections during peak load"

Guidelines

• Set pool size based on available database connections and app instances
• Use the formula: pool_size = (core_count * 2) + disk_spindles as a starting point
• Configure idle timeout to reclaim unused connections
• Enable connection validation to detect stale connections
• Monitor pool metrics to identify saturation or waste