//
Search across all documentation pages
8 pages in this section.
The mental model behind a Postgres SKILL.md playbook - why it is a contract rather than a tutorial, and how its parts fit together for migration safety, EXPLAIN review, failover, and incident triage.
Learn what a Postgres SME Agent Skill is, what it contains, and when to invoke it with ten examples for AI assistants on PostgreSQL 18.4, Patroni 4.x, and pgBackRest 2.55+.
Review PostgreSQL query changes using a structured checklist. Learn to identify performance regressions with EXPLAIN output and reject problematic pull requests.
Assess DDL script lock risks for PostgreSQL 18.4 migrations. Learn to identify and mitigate high-risk patterns like CREATE INDEX and ALTER TABLE.
Verify Patroni/RDS failover for PostgreSQL 18.4 clusters with a structured drill workflow. Learn to conduct pre-checks, baselines, and controlled switchovers.
Learn best practices for creating and maintaining PostgreSQL Agent Skills. Ensure accuracy, safety, and alignment with production policies.
A single-page roundup of every highlight bullet from the 7 pages in the Agent Skills section, grouped by source page so you can scan all 41 takeaways without opening each article individually.