PostgreSQL questions are easy to answer from stale memory or the wrong major version. Use this skill to ground answers in the official PostgreSQL 16 documentation and return the closest authoritative page instead of generic database advice.

When to Use

Use this skill when the request is about:

PostgreSQL concepts, terminology, or product boundaries
SQL syntax, DDL, DML, queries, data types, functions, operators, or type conversion
Indexes, full text search, concurrency, MVCC, locking, or isolation levels
Query performance, planner behavior, parallel query, or statistics
Installation, server setup, configuration parameters, or runtime operation
Client authentication, roles, privileges, databases, schemas, or localization
Routine maintenance, vacuuming, backups, restore, or WAL
High availability, physical replication, logical replication, or failover
Monitoring, activity views, disk usage, logs, or troubleshooting server behavior
Client interfaces such as libpq, large objects, ECPG, or the information schema
Server programming: triggers, event triggers, rules, PL/pgSQL, SPI, or extensions
SQL command reference, client utilities, or server applications
PostgreSQL 16 release notes, new features, or version-specific behavior

postgresql-16-docs

When to Use