CtrlK
BlogDocsLog inGet started
Tessl Logo
SkillPublic

neon-postgres-egress-optimizer

Diagnose and fix excessive Postgres egress (network data transfer) in a codebase. Use when a user mentions high database bills, unexpected data transfer costs, network transfer charges, egress spikes, "why is my Neon bill so high", "database costs jumped", SELECT * optimization, query overfetching, reduce Neon costs, optimize database usage, or wants to reduce data sent from their database to their application. Also use when reviewing query patterns for cost efficiency, even if the user doesn't explicitly mention egress or data transfer.

Quality

87%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide
SecuritybySnyk

Passed

No findings from the security scan

SKILL.md
Quality
Evals
Security

Quality

Content

85%Weight 40%Scale 1-5

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

A well-structured, highly actionable workflow skill: ordered steps, executable SQL throughout, before/after examples, and genuine verification with measurement. Remaining gains are small — one anti-pattern fix (caching) lacks concrete code, and a few sentences are rhetorical padding.

DimensionReasoningScore

Conciseness

The body is efficient and assumes competence — no padding explaining what Postgres or extensions are — with each section earning its tokens. A few lines are trimmable filler (e.g., 'Two queries instead of one JOIN. The product data is fetched once. The reviews are fetched once. No duplication.'), which fits anchor 4 (efficient, minor over-explanation) rather than 5.

4 / 5

Actionability

Fully executable copy-paste SQL for all diagnostic queries and four of the five anti-patterns with before/after examples, plus concrete CLI commands (neon skills, npm i @neon/config, neon config apply). The 'High-frequency queries on static data' fix stops at 'Add a caching layer' with no code or mechanism, a minor gap that keeps this at anchor 4 rather than 5.

4 / 5

Workflow Clarity

A clearly ordered four-step workflow (diagnose, analyze, fix, verify) with explicit sequencing ('Work the four steps in order'), error-recovery feedback (the pg_stat_statements availability check and empty-stats handling), and a verify step that runs tests, checks response shape, and re-measures with a stats reset. This matches the top anchor with explicit validation steps and feedback loops for a database-operations context.

5 / 5

Progressive Disclosure

The skill ships as a single well-sectioned SKILL.md with no bundle files, and nothing in it clearly belongs in a separate file. References are well-signaled and one level deep: the parent neon skill (with install command and URL) and two Further Reading links. This matches the anchor for a clear overview with easy navigation.

5 / 5

Total

18

/

20

Passed

Description

86%Weight 40%Scale 1-5

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

A strong description with explicit what/when structure and unusually rich natural trigger coverage, including quoted user phrasings. Its only real weakness is that the capability statement covers just two actions (diagnose, fix), leaving the skill's fuller scope (analyze, verify, caching, pagination fixes) implicit, and the broad cost-review clause slightly dilutes distinctiveness.

Suggestions

Expand the capability sentence with 2-3 more concrete actions (e.g., 'identify top egress queries via pg_stat_statements, fix SELECT * and missing-pagination anti-patterns, verify the transfer drop after fixes') to lift specificity beyond two verbs.

Tighten the catch-all clause 'Also use when reviewing query patterns for cost efficiency, even if the user doesn't explicitly mention egress' to name Postgres/Neon specifically, reducing overlap with general database-optimization skills.

Consider mentioning JOIN duplication and application-side aggregation among the trigger terms, since users may describe those symptoms without knowing egress is the cause.

DimensionReasoningScore

Specificity

The description names the domain ('excessive Postgres egress (network data transfer)') and exactly two concrete actions ('Diagnose and fix'), matching the anchor for 1-2 concrete actions without comprehensive coverage. It does not reach 4 because the remaining text enumerates triggers rather than additional specific capabilities.

3 / 5

Completeness

It explicitly answers both what ('Diagnose and fix excessive Postgres egress (network data transfer) in a codebase') and when ('Use when a user mentions high database bills, unexpected data transfer costs...') with concrete trigger phrases, matching the top anchor exactly.

5 / 5

Trigger Term Quality

Comprehensive natural trigger coverage including synonyms and user-voiced phrases: 'high database bills', 'network transfer charges', 'egress spikes', 'why is my Neon bill so high', 'database costs jumped', 'SELECT * optimization', 'query overfetching', 'reduce Neon costs', 'optimize database usage'. This matches the anchor for full coverage of natural terms including variations.

5 / 5

Distinctiveness Conflict Risk

A clear niche (Postgres/Neon egress cost optimization) with distinct triggers, but the broadening clause 'Also use when reviewing query patterns for cost efficiency, even if the user doesn't explicitly mention egress or data transfer' creates minor overlap with generic database-optimization skills. Mostly distinct with minor overlap risk, matching anchor 4 rather than 5.

4 / 5

Total

17

/

20

Passed

Validation

93%

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

Validation — 15 / 16 Passed

Validation for skill structure

CriteriaDescriptionResult

metadata_version

'metadata.version' is missing

Warning

Total

15

/

16

Passed

Repository

stevenknowswhy/ProfessionalBuyer

Path

.agents/skills/neon-postgres-egress-optimizer/SKILL.md

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.