Postgres

Reference guidance on PostgreSQL schema design, indexing, query optimization, operations, and PlanetScale-specific connection and CLI topics.

What it does

This skill supplies a set of reference documents covering PostgreSQL best practices: schema design, indexing and index optimization, partitioning, query patterns, MVCC and VACUUM, WAL and checkpoints, replication, storage layout, monitoring, and backup and recovery. It also covers operational topics such as process and memory architecture, plus PlanetScale-specific material on connection pooling, PgBouncer configuration, extensions, connection troubleshooting, insights, and pscale CLI commands. The skill is instructions only and produces guidance and recommendations rather than files or code.

When to use it

Use it when working with PostgreSQL databases and needing advice on schema design, query or index performance, connection problems, or operational and recovery topics. It is also intended for PlanetScale-hosted Postgres questions involving pooling, extensions, or the pscale CLI.

Requirements

No scripts are included; it is instructions and reference documents only. Some referenced material concerns PlanetScale-hosted Postgres and the pscale CLI, which would require a PlanetScale account and CLI access to apply.