neondatabase avatar

Neon Postgres Egress Optimizer

This walks Claude through finding and fixing the query patterns that cause surprise Neon bills. It starts by running pg_stat_statements to identify which queries transfer the most data, then analyzes your codebase for common culprits like SELECT *, missing pagination, and JOINs that duplicate parent rows across children. The fixes are practical: select only needed columns, add LIMIT clauses, cache high-frequency queries, push aggregations into SQL instead of fetching raw data. Most egress problems come from application code fetching way more data than it actually uses, and this gives Claude a step-by-step diagnostic workflow to catch those issues before they show up on your invoice.

skills.sh installs
35.1K
GitHub stars
113
last updated
Aug 21, 2026

Install

$ npx -y skills add neondatabase/agent-skills --skill neon-postgres-egress-optimizer --agent claude-code

Installs into .claude/skills of the current project.

Files

This walks Claude through finding and fixing the query patterns that cause surprise Neon bills. It starts by running pg_stat_statements to identify which queries transfer the most data, then analyzes your codebase for common culprits like SELECT *, missing pagination, and JOINs that duplicate parent rows across children. The fixes are practical: select only needed columns, add LIMIT clauses, cache high-frequency queries, push aggregations into SQL instead of fetching raw data. Most egress problems come from application code fetching way more data than it actually uses, and this gives Claude a step-by-step diagnostic workflow to catch those issues before they show up on your invoice.

Browse the repository on GitHub

Sponsors

Details

Repository
github.com/neondatabase/agent-skills
Categories
Backend & APIs, AI & Agent Building, Debugging, Databases
First seen
May 16, 2026

More from neondatabase/agent-skills

All 8
1jimliu avatarbaoyu-post-to-wechatjimliu/baoyu-skillsPosts content to WeChat Official Account (微信公众号) via API or Chrome CDP. Supports article posting (文章) with HTML, markdown, or plain text input, and image-text p34.8Kskills.sh installs
2wshobson avatarnextjs-app-router-patternswshobson/agentsMaster Next.js 14+ App Router with Server Components, streaming, parallel routes, and advanced data fetching. Use when building Next.js applications, implementi33.6Kskills.sh installs
3firecrawl avatarfirecrawl-workflowsfirecrawl/firecrawl-workflowsRun outcome-focused Firecrawl workflows that produce deliverables such as research reports, SEO audits, QA reports, lead lists, knowledge bases, website design 32.9Kskills.sh installs
4stripe avatarstripe-best-practicesstripe/aiGuides Stripe integration decisions across API selection (Checkout Sessions vs PaymentIntents), Connect platform setup (Accounts v2, controller properties), bil31.6Kskills.sh installs
5jimliu avatarbaoyu-danger-x-to-markdownjimliu/baoyu-skillsConverts X (Twitter) tweets and articles to markdown with YAML front matter. Uses reverse-engineered API requiring user consent. Use when user mentions "X to ma28.4Kskills.sh installs
6expo avatareas-app-storesexpo/skillsEAS service (paid). Deploy Expo apps to the app stores with EAS - build and submit to the iOS App Store, Google Play Store, and TestFlight, configure eas.json b26.6Kskills.sh installs