CtrlK
BlogDocsLog inGet started
Tessl Logo

optimizing-database-connection-pooling

Process use when you need to work with connection management. This skill provides connection pooling and management with comprehensive guidance and automation. Trigger with phrases like "manage connections", "configure pooling", or "optimize connection usage".

54

Quality

45%

Does it follow best practices?

Impact

Pending

No eval scenarios have been run

SecuritybySnyk

Advisory

Suggest reviewing before use

Optimize this skill with Tessl

npx tessl skill review --optimize ./plugins/database/database-connection-pooler/skills/optimizing-database-connection-pooling/SKILL.md
SKILL.md
Quality
Evals
Security

Quality

Discovery

40%

Based on the skill's description, can an agent find and select it at the right time? Clear, specific descriptions lead to better discovery.

This description suffers from vagueness and buzzword-heavy language ('comprehensive guidance and automation') without specifying concrete actions or the type of connections being managed. While it does include explicit trigger phrases, the lack of specificity about what the skill actually does and what domain of connections it covers makes it weak for skill selection among many options.

Suggestions

Replace 'comprehensive guidance and automation' with specific concrete actions like 'configure pool sizes, monitor idle connections, handle connection timeouts, manage connection lifecycle'.

Specify the type of connections (e.g., database connections, HTTP connections, WebSocket connections) to reduce conflict risk with other skills.

Add more natural trigger terms including technology-specific keywords users would mention, such as 'connection pool', 'max connections', 'connection leak', or specific technologies like 'HikariCP', 'pgBouncer', etc.

DimensionReasoningScore

Specificity

The description uses vague language like 'connection pooling and management' and 'comprehensive guidance and automation' without listing any concrete actions. No specific operations (e.g., 'set pool size', 'monitor idle connections', 'handle timeouts') are mentioned.

1 / 3

Completeness

It attempts to answer both 'what' and 'when' with trigger phrases, but the 'what' is extremely vague ('connection pooling and management with comprehensive guidance and automation') and the 'when' clause is present but tied to generic triggers. The explicit trigger guidance prevents capping at 1, but the weak 'what' prevents a score of 3.

2 / 3

Trigger Term Quality

It includes some relevant trigger phrases like 'manage connections', 'configure pooling', and 'optimize connection usage', but these are somewhat generic and miss common variations like 'database connections', 'connection pool size', 'connection timeout', or specific technologies.

2 / 3

Distinctiveness Conflict Risk

The term 'connection management' is somewhat specific to a domain but could overlap with database skills, network skills, or API management skills. Without specifying the type of connections (database, HTTP, WebSocket, etc.), there's meaningful conflict risk.

2 / 3

Total

7

/

12

Passed

Implementation

50%

Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.

This is a comprehensive and knowledgeable skill covering database connection pooling across multiple technologies. Its main strengths are the breadth of coverage, specific formulas and parameter recommendations, and a useful error handling table. Its weaknesses are the lack of executable configuration examples (actual config file snippets), missing validation/verification checkpoints in the workflow, and a monolithic structure that could benefit from splitting detailed per-technology guidance into separate files.

Suggestions

Add executable configuration snippets: include a complete pgbouncer.ini example, a HikariCP application.yml block, and a ProxySQL config snippet that are copy-paste ready.

Add explicit validation checkpoints after key steps, e.g., 'After deploying PgBouncer, verify with: psql -h pgbouncer_host -p 6432 -c "SHOW POOLS"' and 'After changing max_connections, verify with: SHOW max_connections'.

Split per-technology details (PgBouncer config, ProxySQL config, application pool config) into separate referenced files to improve progressive disclosure and reduce the main file's length.

Trim narrative examples into concrete before/after config snippets rather than paragraph-form descriptions.

DimensionReasoningScore

Conciseness

The content is mostly efficient and provides useful, non-obvious information (pool sizing formulas, memory calculations, PgBouncer/ProxySQL specifics). However, it's quite lengthy (~100+ lines) and some sections could be tightened—e.g., the examples section narrates scenarios rather than showing config snippets, and some explanations (like what transaction pooling mode does) are things Claude would know.

2 / 3

Actionability

Provides concrete SQL queries, formulas, and specific parameter values, which is good. However, it lacks executable configuration file examples (no actual pgbouncer.ini snippet, no HikariCP YAML/properties block, no ProxySQL config). The guidance is specific but mostly descriptive rather than copy-paste ready.

2 / 3

Workflow Clarity

The 10-step sequence is logically ordered (audit → calculate → configure → deploy → monitor → document), but there are no explicit validation checkpoints or feedback loops. For operations that modify database infrastructure and connection settings, there should be verification steps (e.g., 'verify PgBouncer is accepting connections before switching application traffic') to catch errors before they cascade.

2 / 3

Progressive Disclosure

The content is well-structured with clear sections (Overview, Instructions, Output, Error Handling, Examples, Resources), but it's a monolithic document with no references to supporting files. The detailed PgBouncer, ProxySQL, and application-level configurations could each be separate reference files, with the main SKILL.md serving as a concise overview.

2 / 3

Total

8

/

12

Passed

Validation

81%

Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.

Validation9 / 11 Passed

Validation for skill structure

CriteriaDescriptionResult

allowed_tools_field

'allowed-tools' contains unusual tool name(s)

Warning

frontmatter_unknown_keys

Unknown frontmatter key(s) found; consider removing or moving to metadata

Warning

Total

9

/

11

Passed

Repository
jeremylongshore/claude-code-plugins-plus-skills
Reviewed

Table of Contents

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.