Connection Pool Management

Pool sizing, connection lifetime, health checks, and resource exhaustion prevention.

48 stars 10 forksOther Plugin marketplace

Install

Claude Code plugin
/plugin marketplace add sethdford/claude-skills

The repo is a Claude Code plugin marketplace. Run /plugin afterwards to pick the plugin that includes this skill.

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add sethdford/claude-skills --skill connection-pool-management
Manual install
git 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-management

Personal 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
Read the full skill on GitHub

Details

Skill name
connection-pool-management
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

Browse the most popular Claude skills, all other skills, or write your own with the skills generator.