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
WAL internals, checkpoint tuning, durability, crash recovery
Replication
Streaming replication, slots, sync commit, failover
Storage Layout
PGDATA structure, TOAST, fillfactor, tablespaces, disk mgmt
Monitoring
pg_stat views, logging, pg_stat_statements, host metrics
Backup and Recovery
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
Supported extensions, compatibility
Connections
Connection troubleshooting, drivers, SSL
Insights
Slow queries, MCP server, pscale CLI
CLI Commands
pscale CLI reference, branches, deploy requests, auth
CLI API Insights
references/ps-cli-api-insights.md
Query insights via pscale api, schema analysis