postgres
Installation
SKILL.md
PlanetScale Postgres
Generic Postgres
| Topic | Reference | Use for |
|---|---|---|
| Schema Design | references/schema-design.md | Tables, primary keys, data types, foreign keys |
| Indexing | references/indexing.md | Index types, composite indexes, performance |
| Index Optimization | references/index-optimization.md | Unused/duplicate index queries, index audit |
| Partitioning | references/partitioning.md | Large tables, time-series, data retention |
| Query Patterns | references/query-patterns.md | SQL anti-patterns, JOINs, pagination, batch queries |
| Optimization Checklist | references/optimization-checklist.md | Pre-optimization audit, cleanup, readiness checks |
| MVCC and VACUUM | references/mvcc-vacuum.md | Dead tuples, long transactions, xid wraparound prevention |
Operations and Architecture
| Topic | Reference | Use for |
|---|---|---|
| Process Architecture | references/process-architecture.md | Multi-process model, connection pooling, auxiliary processes |
Related skills
More from wcygan/dotfiles
competitor-analysis
>
16business-review
>
12ux-review
>
12zed-config
>
12zellij-guide
All-in-one Zellij terminal multiplexer guide. Use when the user asks about Zellij keybindings, configuration, layouts, plugins, sessions, CLI commands, or troubleshooting. Also use when helping with dotfiles config at ~/Development/dotfiles/config/zellij/.
11api-workshop
>
11