neon-postgres-egress-optimizer
Diagnoses and fixes Postgres query patterns that cause excessive data transfer from a database to an application.
Setup & Installation
What This Skill Does
Diagnoses and fixes Postgres query patterns that cause excessive data transfer from a database to an application. Works by analyzing pg_stat_statements output to find queries returning too many rows, too many columns, or running too frequently. Covers SELECT * abuse, missing pagination, JOIN duplication, and application-side aggregation.
Running pg_stat_statements diagnostics manually and mapping high-row queries back to application code takes hours; this skill walks through the exact SQL, the interpretation, and the fix for each pattern in one pass.
When to use it
- Tracing a Neon bill spike to a specific unpaginated list endpoint
- Replacing SELECT * with column-specific queries to cut transferred data
- Finding queries called thousands of times daily that return static config data
- Rewriting application-side aggregation loops into single SQL GROUP BY queries
- Splitting wide JOIN results into two separate queries to eliminate row duplication
Similar Skills
minimax-xlsx
Handles Excel and CSV/TSV files through direct XML manipulation rather than library round-trips.
xlsx
Reads, writes, and edits Excel and tabular files (.
meme-rush
Meme Rush tracks meme token launches across Pump.
query-token-info
Queries token data from Binance Web3 APIs across BSC, Base, and Solana.