Domains
Forms
Mechanism
Breaks down how the skill works and what it produces, so you can quickly judge whether it fits your scenario and value.
When a user faces high Postgres egress bills or wants to optimize data transfer from their database, especially on Neon. Use when diagnosing excessive data fetching.
pg_stat_statements to find top row/wide-column/high-frequency queries.neon.ts.Reduced egress cost via optimized queries and cheaper non-prod branches, with measurable before/after comparison.
Use Cases
A startup receives a surprisingly high Neon bill. The engineer invokes this skill to run pg_stat_statements diagnostics, identifies a JOIN duplicating wide JSONB columns across child rows, and splits it into two queries. After verification, egress drops significantly, cutting monthly cost without changing features.
A dev team builds a new list API without pagination. Using this skill, they detect the unbounded SELECT anti-pattern, add LIMIT/OFFSET and document params, then set neon.ts to auto-expire preview branches. They prevent future egress spikes and keep CI branches cheap by default.
Skill Relationships
Dependency relationships read as "the upper tier points to the lower tier." The current Skill sits in the middle tier — above are Skills that depend on it, below are Skills it depends on.
Tier 1 · These Skills Use Me
Tier 2 · Current Skill
Tier 3 · I Use These Skills
Browse this skill's relationships within its skillset. Click a node to switch the side panel; use the search box to jump to any skill.
Skill File