postgres
Installation
SKILL.md
PostgreSQL
Start with the provider, deployment model, PostgreSQL version, workload, and constraints already present in the repository or supplied by the user. Keep provider-specific advice within that provider's section. When the user asks for a new provider recommendation, compare current operational needs, regions, extensions, compliance, migration cost, pricing, and existing team tooling before recommending one.
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 |