Connection Pool Management
Pool sizing, connection lifetime, health checks, and resource exhaustion prevention.
Install
/plugin marketplace add sethdford/claude-skillsThe repo is a Claude Code plugin marketplace. Run /plugin afterwards to pick the plugin that includes this skill.
npx skills add sethdford/claude-skills --skill connection-pool-managementgit clone --depth 1 https://github.com/sethdford/claude-skills.git /tmp/claude-skills
mkdir -p ~/.claude/skills
cp -r /tmp/claude-skills/engineer/database-engineering/skills/connection-pool-management ~/.claude/skills/connection-pool-managementPersonal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.
From the SKILL.md
# Connection Pool Management Managing database connections efficiently to maximize throughput and prevent resource exhaustion. ## Context You are configuring connection pools. Size appropriately; monitor usage. ## Domain Context - **Pool Size**: How many concurrent connections? Too few = waits; too many = resource exhaustion - **Connection Lifetime**: How long should connection live? Connections age, become stale - **Health Checks**: Validate connections before reuse - **Idle Timeout**: Close unused connections; free resources - **Queuing**: What happens when all connections are busy? ## Instructions 1. **Min/Max Size**: Min = base connections; Max = peak + buffer 2. **Max = (Number of Cores \* 2) + Extra for I/O**: Rule of thumb 3. **Connection Lifetime**: 30 minutes common; depends on database 4. **Idle Timeout**: 5 minutes; reclaim unused connections 5. **Health Checks**: Ping connection before using; catch stale connections 6. **Queue Size**: What happens if all connections busy? Queue or error? 7. **Monitoring**: Track pool utilization, wait times ## Anti-Patterns - Pool too small; queries wait forever - Pool too large; resource exhaustion, slow start - No health checks; stale connections cause errors - No idle timeout; connections accumulate, eventually exhaust - Not monitoring; don't know if pool is too small ## Further Reading - HikariCP documentation (Java) - Connection pool best practices (AWS) - Database connection tuning guides
Details
- Skill name
connection-pool-management- Repository
- sethdford/claude-skills
- Path
engineer/database-engineering/skills/connection-pool-management/SKILL.md- License
- MIT
- Repo updated
- 11 March 2026
FAQ
What does the Connection Pool Management skill do?
Pool sizing, connection lifetime, health checks, and resource exhaustion prevention.
How do I install the Connection Pool Management skill?
Claude Code plugin: /plugin marketplace add sethdford/claude-skills. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.
Is Connection Pool Management popular?
It lives in sethdford/claude-skills, which has 48 GitHub stars and 10 forks.
Related skills
A B Test Design
48sethdford/claude-skills
Design rigorous A/B tests with hypotheses, variants, metrics, and sample size calculations.
A B Test Design Pm
48sethdford/claude-skills
Analytics and experimentation skill for product managers.
Abuse Case Design
48sethdford/claude-skills
Design abuse cases (negative use cases) showing how attackers misuse system features. Use when identifying attacks that exploit intended functionality or business logic flaws.
Context Diagram
48sethdford/claude-skills
Design high-level system boundary diagrams. Show external systems, users, data flows. Use when onboarding teams or clarifying system scope.
Competitive Landscape
48sethdford/claude-skills
Map existing solutions, alternatives, and competitive positioning to understand the problem space.
Dark Mode Design
48sethdford/claude-skills
Design effective dark mode interfaces with proper color adaptation, contrast, and elevation.
Browse the most popular Claude skills, all other skills, or write your own with the skills generator.