neon-postgres-egress-optimizer

Community

Slash Postgres egress costs with smarter queries

AuthorTristan578
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Reduce costly data egress from PostgreSQL by identifying queries that transfer large volumes of data or wide columns and applying targeted fixes to minimize transfer and cost.

Core Features & Use Cases

  • Query analytics with pg_stat_statements to identify top egress contributors and unbounded queries.
  • Code and schema review to ensure selective column projection, proper pagination, and avoidance of unnecessary wide fields.
  • Cost-aware optimizations including pagination, caching, and SQL-level aggregation to cut data transfer in APIs, dashboards, and batch jobs.

Quick Start

Run the diagnostic workflow against your Neon PostgreSQL deployment to identify egress-heavy queries and begin applying fixes.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: neon-postgres-egress-optimizer
Download link: https://github.com/Tristan578/project-forge/archive/main.zip#neon-postgres-egress-optimizer

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.