Postgres
by planetscalef6ed002d0308MIT705 starsListed Oct 8, 2026Updated Oct 8, 2026Repository updated yesterday
PostgreSQL best practices, query optimization, connection troubleshooting, and performance improvement. Load when working with Postgres databases.
Only the file list is public. File contents are available once the skill is installed in a workspace.
| Path | Size | Type |
|---|---|---|
| references/backup-recovery.md | 2.6 KB | text/markdown |
| references/indexing.md | 2 KB | text/markdown |
| references/index-optimization.md | 4.6 KB | text/markdown |
| references/memory-management-ops.md | 2.7 KB | text/markdown |
| references/monitoring.md | 3.4 KB | text/markdown |
| references/mvcc-transactions.md | 2.2 KB | text/markdown |
| references/mvcc-vacuum.md | 2.5 KB | text/markdown |
| references/optimization-checklist.md | 787 B | text/markdown |
| references/partitioning.md | 2.9 KB | text/markdown |
| references/pgbouncer-configuration.md | 1.4 KB | text/markdown |
| references/process-architecture.md | 2.7 KB | text/markdown |
| references/ps-cli-api-insights.md | 2 KB | text/markdown |
| references/ps-cli-commands.md | 1.8 KB | text/markdown |
| references/ps-connection-pooling.md | 4.2 KB | text/markdown |
| references/ps-connections.md | 1.6 KB | text/markdown |
| references/ps-extensions.md | 1.1 KB | text/markdown |
| references/ps-insights.md | 3.4 KB | text/markdown |
| references/query-patterns.md | 2.5 KB | text/markdown |
| references/replication.md | 3.7 KB | text/markdown |
| references/schema-design.md | 1.9 KB | text/markdown |
| references/storage-layout.md | 2.4 KB | text/markdown |
| references/wal-operations.md | 2.8 KB | text/markdown |
| SKILL.md | 7 KB | text/markdown |
Source and attribution
Source:planetscale/database-skillsinskills/postgresat commitf6ed002
License: MIT
Content belongs to its original authors. SourceWeft indexes it from a public repository.
More from planetscale/database-skills
Vitess
planetscale
Vitess best practices, query optimization, and connection troubleshooting for PlanetScale Vitess databases. Load when working with Vitess databases, sharding, VSchema configuration, keyspace management, or MySQL scaling issues.
Neki
planetscale
Reference guidance for working with Neki, PlanetScale's distributed sharded Postgres, from connections and shard keys to resharding.
Mysql
planetscale
Guides MySQL/InnoDB schema design, indexing, query tuning, transactions and operations with reference files.
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.