A comprehensive PostgreSQL skill from PlanetScale covering best practices for performance optimization. Includes schema design, composite indexing strategies, table partitioning, query patterns, MVCC and VACUUM operations, connection pooling with PgBouncer, memory management, WAL operations, checkpoint tuning, streaming replication, and monitoring with pg_stat views. Covers PlanetScale-specific features including connection troubleshooting, query insights, and pscale CLI commands.
npx skills add planetscale/database-skills --skill postgreswget https://github.com/planetscale/database-skills/archive/refs/heads/main.zip -O database-skills-postgres.zip