neon-postgres-egress-optimizer: Diagnose and Reduce Neon Postgres Data Egress Costs
neon-postgres-egress-optimizer is a dedicated Skill in Neon’s official agent-skills collection, designed to address high egress costs in Serverless Postgres caused by query over-fetching. It follows a four-step process—diagnose, analyze, fix, and verify—and uses pg_stat_statements to identify queries with high row counts, wide columns, and high execution frequencies. It also maps these findings to common code-level anti-patterns, such as SELECT *, missing pagination, application-side aggregation, and redundant JOINs, and provides remediation examples. You can install it by pointing npx skills add to the GitHub repository, and it is recommended to enable the parent neon Skill first. It is well suited for Neon users who want cost-focused query reviews and investigations into billing spikes.
Read Moreclaimable-postgres: One-Click Access to Claimable Postgres for Agents
claimable-postgres is an Agent Skill maintained by Neon that guides coding assistants to provision ephemeral Postgres databases instantly via the Claimable Postgres service. A single API or CLI call returns a real connection string without requiring an account, login, or credit card. It is suitable for adding a DATABASE_URL to new projects, building demo prototypes, running integration tests, and automatically configuring databases during Vite startup. Unclaimed instances expire after 72 hours and can be claimed to a Neon account for long-term use. Installation: run npx skills add specifying neondatabase/agent-skills and claimable-postgres.
Read Moreneon-postgres: Best Practices for Agents with Neon Serverless Postgres
neon-postgres is a database-specialized Skill in Neon's official agent-skills, covering connection practices (pooled/direct) for Lakebase Postgres on Neon, schema migrations, instant branching, neon inspect db diagnostics, and search-related practices. The article explains how it fits with neon, neon-realtime, and neon-postgres-branches, outlines the four-step Setup Flow, notes that migrations must use a direct connection, and describes how to install it via npx skills add, helping reduce misuse of connections and migrations in AI-assisted development.
Read MoreUse supabase-postgres-best-practices to help AI programming assistants master Postgres skills
### 翻译结果: Introduce the Agent Skill `supabase-postgres-best-practices` maintained by Supabase: A tool designed for platforms such as Cursor and Claude Code, it restricts AI when writing SQL, modifying tables and troubleshooting performance based on eight priority rules covering query performance, connection management, RLS, schema and other aspects. The article verifies the official installation commands, rule structure and typical correct and incorrect examples, and explains how it cooperates with Supabase MCP.
Read More