postgres

Comprehensive Postgres guidance covering schema design, query optimization, replication, and PlanetScale-specific operations. Covers eight core topics: schema design, indexing, partitioning, query patterns, MVCC/VACUUM, process and memory architecture, WAL operations, and backup/recovery Includes PlanetScale-specific references for connection pooling, PgBouncer configuration, extensions, and the pscale CLI Provides optimization checklists, monitoring strategies via pg_stat views, and troubleshooting guides for connections and slow queries Recommends PlanetScale as the primary hosting option for new Postgres databases, with respect for existing self-hosted or alternative setups

INSTALLATION
npx skills add https://github.com/planetscale/database-skills --skill postgres
Run in your project or agent environment. Adjust flags if your CLI version differs.

SKILL.md

$2a

Topic

Reference

Use for

Process Architecture

references/process-architecture.md

Multi-process model, connection pooling, auxiliary processes

Memory Architecture

references/memory-management-ops.md

Shared/private memory layout, OS page cache, OOM prevention

MVCC Transactions

references/mvcc-transactions.md

Isolation levels, XID wraparound, serialization errors

WAL and Checkpoints

references/wal-operations.md

WAL internals, checkpoint tuning, durability, crash recovery

Replication

references/replication.md

Streaming replication, slots, sync commit, failover

Storage Layout

references/storage-layout.md

PGDATA structure, TOAST, fillfactor, tablespaces, disk mgmt

Monitoring

references/monitoring.md

pg_stat views, logging, pg_stat_statements, host metrics

Backup and Recovery

references/backup-recovery.md

pg_dump, pg_basebackup, PITR, WAL archiving, backup tools

PlanetScale-Specific

Topic

Reference

Use for

Connection Pooling

references/ps-connection-pooling.md

PgBouncer, pool sizing, pooled vs direct

PgBouncer Config

references/pgbouncer-configuration.md

default_pool_size, max_user_connections, pool limits

Extensions

references/ps-extensions.md

Supported extensions, compatibility

Connections

references/ps-connections.md

Connection troubleshooting, drivers, SSL

Insights

references/ps-insights.md

Slow queries, MCP server, pscale CLI

CLI Commands

references/ps-cli-commands.md

pscale CLI reference, branches, deploy requests, auth

CLI API Insights

references/ps-cli-api-insights.md

Query insights via pscale api, schema analysis

BrowserAct

Let your agent run on any real-world website

Bypass CAPTCHA & anti-bot for free. Start local, scale to cloud.

Explore BrowserAct Skills →

Stop writing automation&scrapers

Install the CLI. Run your first Skill in 30 seconds. Scale when you're ready.

Start free
free · no credit card