optimizing-database-connection-pooling

This skill optimizes database connection pooling for enhanced performance and resource management. It is activated when the user requests assistance with connection pooling, database performance tuning, or connection lifecycle management. Use this skill to implement and configure connection pools in various programming languages, identify optimal pool settings, and troubleshoot common connection-related issues. The skill is triggered by phrases like "connection pooling," "optimize database connections," or "improve database performance with connection pool."

Install with Tessl CLI

npx tessl i github:jeremylongshore/claude-code-plugins-plus-skills --skill optimizing-database-connection-pooling

What are skills?

1.01x

Quality

55%

Does it follow best practices?

Impact

96%

1.01x

Average score across 6 eval scenarios

Optimize this skill with Tessl

npx tessl skill review --optimize ./backups/skills-migration-20251108-070147/plugins/database/database-connection-pooler/skills/database-connection-pooler/SKILL.md

SKILL.md

Review

Evals

Evaluation results

89%

-8%

Python API Service Database Setup

Python PostgreSQL pool setup

Criteria

Without context

With context

Approved library used

100%

Max pool size configured

100%

Connection timeout set

100%

Connection validation present

80%

53%

get_connection function

100%

Workload-aware pool size

100%

66%

Configuration documented

100%

Timeout rationale

100%

Runnable script block

100%

Without context: $0.2378 · 1m 15s · 17 turns · 17 in / 3,752 out tokens

With context: $0.4375 · 1m 44s · 27 turns · 27 in / 5,035 out tokens

100%

Java Microservice Connection Pool Tuning

HikariCP Java optimization

Criteria

Without context

With context

maximumPoolSize increased

100%

minimumIdle adjusted

100%

connectionTimeout addressed

100%

Workload-based reasoning

100%

Original config analyzed

100%

All three key params changed

100%

Parameter-by-parameter justification

100%

Output files present

100%

Without context: $0.1806 · 1m 9s · 10 turns · 11 in / 3,595 out tokens

With context: $0.3944 · 1m 50s · 22 turns · 154 in / 5,271 out tokens

95%

Database Pool Health Dashboard

Pool monitoring and validation

Criteria

Without context

With context

Connection usage tracked

100%

Wait time metric present

41%

58%

Error rate tracking

100%

Connection validation implemented

100%

Stats reporting mechanism

100%

SQLAlchemy retained

100%

Three metrics in design doc

100%

Validation mechanism explained

100%

Output files present

100%

Without context: $0.3089 · 1m 56s · 16 turns · 16 in / 6,144 out tokens

With context: $0.6147 · 2m 58s · 25 turns · 58 in / 10,447 out tokens

96%

Database Pool Configuration Review

Workload-justified pool sizing

Criteria

Without context

With context

Approved library used

100%

Max pool size configured

100%

Pool size references workload

100%

Connection timeout set

100%

Timeout prevents indefinite waiting

100%

Timeout behavior explained

100%

Connection validation present

66%

Acquire function exposed

100%

Per-parameter justification

100%

Without context: $0.2904 · 1m 44s · 16 turns · 16 in / 5,054 out tokens

With context: $0.4073 · 2m 13s · 24 turns · 24 in / 6,049 out tokens

100%

Java Checkout Service Database Setup

Java HikariCP greenfield setup

Criteria

Without context

With context

HikariCP used

100%

maximumPoolSize set

100%

Pool size within allocation

100%

minimumIdle configured

100%

minimumIdle rationale present

100%

connectionTimeout set

100%

Timeout rationale in README

100%

Workload-based sizing argument

100%

JDBC URL present

100%

Connection validation configured

100%

Without context: $0.2032 · 1m 10s · 13 turns · 16 in / 3,614 out tokens

With context: $0.2488 · 1m 11s · 17 turns · 17 in / 3,555 out tokens

100%

Fixing Intermittent Database Connection Failures

Stale connection handling and validation

Criteria

Without context

With context

psycopg2 retained

100%

Connection validation added

100%

Validation on acquire

100%

Stale connection replaced

100%

Root cause identified

100%

Validation change explained

100%

Timeout consideration present

60%

100%

Output files present

100%

Without context: $0.2832 · 1m 12s · 18 turns · 19 in / 3,891 out tokens

With context: $0.3281 · 1m 32s · 22 turns · 52 in / 3,985 out tokens

Evaluated: 5 days ago
Agent: Claude Code
Model: Claude Sonnet 4.6

Table of Contents

Python API Service Database Setup Java Microservice Connection Pool Tuning Database Pool Health Dashboard Database Pool Configuration Review Java Checkout Service Database Setup Fixing Intermittent Database Connection Failures

Is this your skill?

If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.