postgresql-knowledge-patch
Installation
SKILL.md
PostgreSQL Knowledge Patch
Use this skill when writing SQL, planning an upgrade, operating a cluster, building a client, or maintaining an extension. Start with the checks below, then open the topic reference that matches the task.
Reference index
| Reference | Topics |
|---|---|
| Clients, Authentication, and Command-Line Tools | MD5 migration, OAuth, TLS, libpq, wire protocol, psql, pgbench, notification failures |
| COPY, Backup, and Maintenance | Safe maintenance paths, inheritance-aware vacuum, tolerant COPY, incremental backup, dump/restore, file operations |
| Extensions, Modules, and Foreign Data Wrappers | Extension discovery and APIs, injection points, bundled modules, postgres_fdw, file_fdw, pgcrypto |
| SQL/JSON and JSON Processing | SQL-standard JSON query functions, JSON_TABLE, constructors, path conversions, null handling |
| Migration and Compatibility | Removed settings, catalog changes, checksums, pg_upgrade, security repairs, build requirements, release availability |
| Observability, Statistics, and Planning | Asynchronous I/O, vacuum progress, statistics, EXPLAIN, logging, NUMA |
| Replication and Recovery | Failover slots, standby synchronization, replica conversion, generated-column publication, apply conflicts |
| SQL, Types, and Schema Design | UUIDv7, generated columns, RETURNING, MERGE, temporal constraints, privileges, collations, PL/pgSQL |