neon-postgres-egress-optimizer

Item: neon-postgres-egress-optimizer
Rating: 5.3
Author: Implexa

view source

installs

stars

karma

SkillRank score ↗

5.3/ 10

evaluated by implexa, claude-haiku-4-5 · 2026-07-02

neon-postgres-egress-optimizer guides diagnosis of query patterns causing excessive database egress via pg_stat_statements, though the procedure remains incomplete and lacks recovery paths for common failure modes.

structure

4.0

trigger phrases

3.0

procedure

6.0

edge cases

2.0

documentation

5.0

strengths

SKILL.md

Postgres Egress Optimizer

Guide the user through diagnosing and fixing application-side query patterns that cause excessive data transfer (egress) from their Postgres database. Most high egress bills come from the application fetching more data than it uses.

Step 1: Diagnose

Identify which queries transfer the most data. The primary tool is the pg_stat_statements extension.

Check if pg_stat_statements is available

SELECT 1 FROM pg_stat_statements LIMIT 1;

If this errors, the extension needs to be created:

CREATE EXTENSION IF NOT EXISTS pg_stat_statements;

related skills

semantically similar in the cross-vendor index

skills.sh

59% match

postgres

PostgreSQL best practices, query optimization, connection troubleshooting, and performance improvement. Load when working with Postgres databases.

don't have the plugin yet? install it then click "run inline in claude" again.