Postgres Best Practices
neondatabase/postgres-skills/skills/postgres-best-practicesby neondatabase27fe45e0f71eNo license48 starsListed Oct 9, 2026Updated Oct 9, 2026Repository updated 2 days ago
Best practices and guidelines for working with Postgres. Covers schema design, indexing strategies, query optimization, migrations, and common pitfalls. Use when writing SQL, designing database schemas, optimizing queries, or setting up a Postgres database.
Only the file list is public. File contents are available once the skill is installed in a workspace.
| Path | Size | Type |
|---|---|---|
| references/backup-restore.md | 11.8 KB | text/markdown |
| references/bulk-loading.md | 8.7 KB | text/markdown |
| references/connection-pooling.md | 9.2 KB | text/markdown |
| references/hot-standby.md | 7.2 KB | text/markdown |
| references/indexing.md | 10 KB | text/markdown |
| references/logical-replication.md | 17.1 KB | text/markdown |
| references/major-version-upgrades.md | 10 KB | text/markdown |
| references/performance-diagnostics.md | 15.5 KB | text/markdown |
| references/query-optimization.md | 11 KB | text/markdown |
| references/query-patterns.md | 13.2 KB | text/markdown |
| references/schema-design.md | 10.8 KB | text/markdown |
| references/security-roles.md | 15.1 KB | text/markdown |
| references/transaction-isolation.md | 13.2 KB | text/markdown |
| SKILL.md | 3.3 KB | text/markdown |
Source and attribution
Source:neondatabase/postgres-skillsinskills/postgres-best-practicesat commit27fe45e
License: No license
Content belongs to its original authors. SourceWeft indexes it from a public repository.
More in Data & Analytics
Swap Curve Strategy
anthropics
Analyzes interest rate swap curves, swap spreads, real rates and curve trade ideas using MCP pricing tools.
Unit Economics
anthropics
Analyzes unit economics for private equity targets: ARR cohorts, LTV/CAC, net retention, payback and margin waterfall.
Option Vol Analysis
anthropics
Analyzes option volatility by combining vol surfaces, option pricing with Greeks, and historical prices to compare implied and realized vol.
Macro Rates Monitor
anthropics
Builds macro and rates dashboards from MCP data on GDP, inflation, yield curves, breakevens and swaps.
Clean Data Xls
anthropics
Cleans messy spreadsheet data: trims whitespace, fixes casing, converts text numbers, standardizes dates, and removes duplicates.
Fixed Income Portfolio
anthropics
Reviews fixed income portfolios by pricing bonds, aggregating risk metrics, projecting cashflows and running rate scenarios.