This Skill queries official PostgreSQL documentation for accurate information.

When to Use

When the user asks about or the conversation involves:

PostgreSQL SQL syntax or commands
Data types, functions, operators
Database configuration (postgresql.conf, pg_hba.conf)
Performance tuning, query optimization
Backup, restore, high availability
Extensions, procedural languages

Execution Steps (IMPORTANT!)

You MUST WebFetch official documentation - never answer from memory!

Step 1: Identify Question Category

Category	Description
SQL Commands	CREATE, SELECT, INSERT, UPDATE, DELETE, ALTER, etc.
Data Types	INTEGER, VARCHAR, JSON, ARRAY, etc.
Functions	String, Math, Date/Time, Aggregate, Window functions

This Skill queries official PostgreSQL documentation for accurate information.

When to Use

When the user asks about or the conversation involves:

PostgreSQL SQL syntax or commands
Data types, functions, operators
Database configuration (postgresql.conf, pg_hba.conf)
Performance tuning, query optimization
Backup, restore, high availability
Extensions, procedural languages

Execution Steps (IMPORTANT!)

You MUST WebFetch official documentation - never answer from memory!

Step 1: Identify Question Category

Category	Description
SQL Commands	CREATE, SELECT, INSERT, UPDATE, DELETE, ALTER, etc.
Data Types	INTEGER, VARCHAR, JSON, ARRAY, etc.
Functions	String, Math, Date/Time, Aggregate, Window functions

Question Type	Documentation URL
SQL Command Reference	https://www.postgresql.org/docs/current/sql-commands.html
Specific SQL Command	https://www.postgresql.org/docs/current/sql-{command}.html (e.g., sql-select.html)
Data Types	https://www.postgresql.org/docs/current/datatype.html
Functions & Operators	https://www.postgresql.org/docs/current/functions.html
String Functions	https://www.postgresql.org/docs/current/functions-string.html
Date/Time Functions	https://www.postgresql.org/docs/current/functions-datetime.html
Aggregate Functions	https://www.postgresql.org/docs/current/functions-aggregate.html
Window Functions	https://www.postgresql.org/docs/current/functions-window.html
JSON Functions	https://www.postgresql.org/docs/current/functions-json.html
Array Functions	https://www.postgresql.org/docs/current/functions-array.html
Indexes	https://www.postgresql.org/docs/current/indexes.html
Full Text Search	https://www.postgresql.org/docs/current/textsearch.html
Configuration	https://www.postgresql.org/docs/current/runtime-config.html
Authentication	https://www.postgresql.org/docs/current/auth-pg-hba-conf.html
Backup & Restore	https://www.postgresql.org/docs/current/backup.html
Replication	https://www.postgresql.org/docs/current/high-availability.html
PL/pgSQL	https://www.postgresql.org/docs/current/plpgsql.html
Triggers	https://www.postgresql.org/docs/current/triggers.html
Performance	https://www.postgresql.org/docs/current/performance-tips.html
EXPLAIN	https://www.postgresql.org/docs/current/using-explain.html
Error Codes	https://www.postgresql.org/docs/current/errcodes-appendix.html

PostgreSQL Guide

When to Use

Execution Steps (IMPORTANT!)

Step 1: Identify Question Category

PostgreSQL Guide

When to Use

Execution Steps (IMPORTANT!)

Step 1: Identify Question Category

Step 2: WebFetch the Corresponding Documentation

Step 3: For Specific SQL Commands

Postgres Patterns

Postgres Patterns

Database Migrations

Postgres Patterns

Postgres Patterns

Jpa Patterns