Skills/Development/database-skills-postgres

database-skills-postgres

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.

Tags

developmentdatabasepostgrespostgresqlplanetscalecommunity
npx skills add planetscale/database-skills --skill postgres
wget https://github.com/planetscale/database-skills/archive/refs/heads/main.zip -O database-skills-postgres.zip

SKILL.md

Loading skill documentation...