home / skills / jeremylongshore / claude-code-plugins-plus-skills / connection-pool-analyzer

This skill guides you through connection pool analyzer tasks, generates production-ready configs, and validates outcomes for performance testing.

npx playbooks add skill jeremylongshore/claude-code-plugins-plus-skills --skill connection-pool-analyzer

Review the files below or copy the command above to add this skill to your agents.

Files (1)
SKILL.md
2.2 KB
---
name: "connection-pool-analyzer"
description: |
  Analyze connection pool analyzer operations. Auto-activating skill for Performance Testing.
  Triggers on: connection pool analyzer, connection pool analyzer
  Part of the Performance Testing skill category. Use when analyzing or auditing connection pool analyzer. Trigger with phrases like "connection pool analyzer", "connection analyzer", "analyze connection pool r".
allowed-tools: "Read, Write, Edit, Bash(cmd:*)"
version: 1.0.0
license: MIT
author: "Jeremy Longshore <[email protected]>"
---

# Connection Pool Analyzer

## Overview

This skill provides automated assistance for connection pool analyzer tasks within the Performance Testing domain.

## When to Use

This skill activates automatically when you:
- Mention "connection pool analyzer" in your request
- Ask about connection pool analyzer patterns or best practices
- Need help with performance testing skills covering load testing, stress testing, benchmarking, and performance monitoring.

## Instructions

1. Provides step-by-step guidance for connection pool analyzer
2. Follows industry best practices and patterns
3. Generates production-ready code and configurations
4. Validates outputs against common standards

## Examples

**Example: Basic Usage**
Request: "Help me with connection pool analyzer"
Result: Provides step-by-step guidance and generates appropriate configurations


## Prerequisites

- Relevant development environment configured
- Access to necessary tools and services
- Basic understanding of performance testing concepts


## Output

- Generated configurations and code
- Best practice recommendations
- Validation results


## Error Handling

| Error | Cause | Solution |
|-------|-------|----------|
| Configuration invalid | Missing required fields | Check documentation for required parameters |
| Tool not found | Dependency not installed | Install required tools per prerequisites |
| Permission denied | Insufficient access | Verify credentials and permissions |


## Resources

- Official documentation for related tools
- Best practices guides
- Community examples and tutorials

## Related Skills

Part of the **Performance Testing** skill category.
Tags: performance, load-testing, k6, jmeter, benchmarking

Overview

This skill automates analysis and guidance for connection pool analyzers in performance testing. It helps diagnose pooling behavior, identify bottlenecks, and produce configuration and code suggestions to optimize resource usage and latency. Use it to accelerate audits, validate setups, and generate production-ready recommendations.

How this skill works

The skill inspects connection pool metrics, configuration settings, and runtime traces to surface contention, leaks, and misconfigurations. It applies industry best practices, runs validation checks against common standards, and can generate code snippets or config templates to remediate issues. Outputs include step-by-step guidance, validation results, and suggested monitoring patterns.

When to use it

  • Analyzing connection pool performance during load or stress tests
  • Auditing pool configuration for production readiness
  • Investigating connection leaks, timeouts, or saturation
  • Generating recommended pool sizes, timeouts, and retry settings
  • Validating changes after tuning or infrastructure updates

Best practices

  • Measure real workloads to derive pool size rather than guessing
  • Set sensible idle and max lifetime values to avoid stale connections
  • Monitor connection acquisition latency and queue lengths continuously
  • Prefer connection pooling libraries with robust metrics hooks
  • Validate configuration changes in a staging environment under realistic load

Example use cases

  • Audit a database pool that causes high latency under peak load and get tuned settings
  • Generate code snippets to instrument pool metrics for Prometheus/Grafana
  • Validate connection timeout and retry policies after a version upgrade
  • Detect and explain root causes of connection leaks from heap/tracing data
  • Produce a checklist and configuration template for onboarding new services

FAQ

What inputs does the analyzer need?

Provide pool configuration (max/min size, timeouts), runtime metrics (acquisition latency, active/idle counts), and representative load profiles.

Can it suggest pool sizes automatically?

Yes. It recommends pool sizing based on observed concurrency, request latency targets, and resource limits, but you should validate recommendations in staging.