Optimizes and diagnoses database connection pool configurations to resolve latency spikes and exhaustion errors.
Connection Pool Tuner is a specialized Claude Code skill designed to resolve intermittent database connectivity issues and performance bottlenecks. It utilizes proven sizing formulas and diagnostic patterns to optimize pool settings for HikariCP, pgBouncer, and other connection managers. By analyzing server specifications, current workloads, and error symptoms, the skill provides actionable configuration snippets and monitoring strategies to ensure application stability and optimal resource utilization under high traffic conditions.
主要功能
01Provides monitoring and alerting strategies using Micrometer and database metrics
02Calculates optimal pool sizes using server-specific hardware sizing formulas
03Generates production-ready configuration snippets for HikariCP and pgBouncer
04Identifies common configuration pitfalls such as incorrect leak detection and lifetime settings
05Diagnoses root causes for connection timeouts and pool exhaustion errors
060 GitHub stars
使用场景
01Resolving production 'connection pool exhausted' errors during traffic spikes
02Optimizing database resources to prevent CPU spikes caused by excessive connections
03Tuning Spring Boot services to handle high concurrent user loads without failures
