PostgreSQL Guide
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 |
| Configuration |
postgresql.conf, pg_hba.conf settings |
| Administration |
Backup, Restore, Replication, Monitoring |
| Programming |
PL/pgSQL, Triggers, Rules |
Step 2: WebFetch the Corresponding Documentation
Base URL: https://www.postgresql.org/docs/current/
Step 3: For Specific SQL Commands
SQL command documentation follows the pattern:
https://www.postgresql.org/docs/current/sql-{command}.html
Examples:
Step 4: Parse and Respond
Extract relevant information from WebFetch results and answer the user directly.
Common Questions Quick Reference
| Question |
Fetch URL |
| "How to create index?" |
sql-createindex.html |
| "JSON operators?" |
functions-json.html |
| "Window functions?" |
functions-window.html |
| "How to backup?" |
backup.html |
| "Connection config?" |
runtime-config-connection.html |
| "pg_hba.conf syntax?" |
auth-pg-hba-conf.html |
| "EXPLAIN ANALYZE?" |
using-explain.html |
| "PL/pgSQL syntax?" |
plpgsql.html |
Important Reminder
Never answer PostgreSQL questions from memory!
PostgreSQL documentation is comprehensive and regularly updated. Always fetch the current documentation for:
- Exact syntax (especially for complex commands)
- Available options and parameters
- Version-specific features
- Best practices and warnings
Why not use a sub-agent?
Sub-agent responses require paraphrasing, which may cause information loss.
Fetch the docs yourself for more direct and accurate information.
Converted and distributed by TomeVault — claim your Tome and manage your conversions.
1---2name: kiki830621-che-claude-plugins-postgresql-guide3description: PostgreSQL Guide4---56# PostgreSQL Guide78This Skill queries official PostgreSQL documentation for accurate information.910## When to Use1112When the user asks about or the conversation involves:13- PostgreSQL SQL syntax or commands14- Data types, functions, operators15- Database configuration (postgresql.conf, pg_hba.conf)16- Performance tuning, query optimization17- Backup, restore, high availability18- Extensions, procedural languages1920## Execution Steps (IMPORTANT!)2122**You MUST WebFetch official documentation - never answer from memory!**2324### Step 1: Identify Question Category2526| Category | Description |27|----------|-------------|28| SQL Commands | CREATE, SELECT, INSERT, UPDATE, DELETE, ALTER, etc. |29| Data Types | INTEGER, VARCHAR, JSON, ARRAY, etc. |30| Functions | String, Math, Date/Time, Aggregate, Window functions |31| Configuration | postgresql.conf, pg_hba.conf settings |32| Administration | Backup, Restore, Replication, Monitoring |33| Programming | PL/pgSQL, Triggers, Rules |3435### Step 2: WebFetch the Corresponding Documentation3637**Base URL:** `https://www.postgresql.org/docs/current/`3839| Question Type | Documentation URL |40|---------------|-------------------|41| SQL Command Reference | https://www.postgresql.org/docs/current/sql-commands.html |42| Specific SQL Command | https://www.postgresql.org/docs/current/sql-{command}.html (e.g., sql-select.html) |43| Data Types | https://www.postgresql.org/docs/current/datatype.html |44| Functions & Operators | https://www.postgresql.org/docs/current/functions.html |45| String Functions | https://www.postgresql.org/docs/current/functions-string.html |46| Date/Time Functions | https://www.postgresql.org/docs/current/functions-datetime.html |47| Aggregate Functions | https://www.postgresql.org/docs/current/functions-aggregate.html |48| Window Functions | https://www.postgresql.org/docs/current/functions-window.html |49| JSON Functions | https://www.postgresql.org/docs/current/functions-json.html |50| Array Functions | https://www.postgresql.org/docs/current/functions-array.html |51| Indexes | https://www.postgresql.org/docs/current/indexes.html |52| Full Text Search | https://www.postgresql.org/docs/current/textsearch.html |53| Configuration | https://www.postgresql.org/docs/current/runtime-config.html |54| Authentication | https://www.postgresql.org/docs/current/auth-pg-hba-conf.html |55| Backup & Restore | https://www.postgresql.org/docs/current/backup.html |56| Replication | https://www.postgresql.org/docs/current/high-availability.html |57| PL/pgSQL | https://www.postgresql.org/docs/current/plpgsql.html |58| Triggers | https://www.postgresql.org/docs/current/triggers.html |59| Performance | https://www.postgresql.org/docs/current/performance-tips.html |60| EXPLAIN | https://www.postgresql.org/docs/current/using-explain.html |61| Error Codes | https://www.postgresql.org/docs/current/errcodes-appendix.html |6263### Step 3: For Specific SQL Commands6465SQL command documentation follows the pattern:66```67https://www.postgresql.org/docs/current/sql-{command}.html68```6970**Examples:**71| Command | URL |72|---------|-----|73| SELECT | https://www.postgresql.org/docs/current/sql-select.html |74| CREATE TABLE | https://www.postgresql.org/docs/current/sql-createtable.html |75| CREATE INDEX | https://www.postgresql.org/docs/current/sql-createindex.html |76| ALTER TABLE | https://www.postgresql.org/docs/current/sql-altertable.html |77| INSERT | https://www.postgresql.org/docs/current/sql-insert.html |78| UPDATE | https://www.postgresql.org/docs/current/sql-update.html |79| DELETE | https://www.postgresql.org/docs/current/sql-delete.html |80| GRANT | https://www.postgresql.org/docs/current/sql-grant.html |81| COPY | https://www.postgresql.org/docs/current/sql-copy.html |82| VACUUM | https://www.postgresql.org/docs/current/sql-vacuum.html |83| EXPLAIN | https://www.postgresql.org/docs/current/sql-explain.html |8485### Step 4: Parse and Respond8687Extract relevant information from WebFetch results and answer the user directly.8889## Common Questions Quick Reference9091| Question | Fetch URL |92|----------|-----------|93| "How to create index?" | sql-createindex.html |94| "JSON operators?" | functions-json.html |95| "Window functions?" | functions-window.html |96| "How to backup?" | backup.html |97| "Connection config?" | runtime-config-connection.html |98| "pg_hba.conf syntax?" | auth-pg-hba-conf.html |99| "EXPLAIN ANALYZE?" | using-explain.html |100| "PL/pgSQL syntax?" | plpgsql.html |101102## Important Reminder103104**Never answer PostgreSQL questions from memory!**105106PostgreSQL documentation is comprehensive and regularly updated. Always fetch the current documentation for:107- Exact syntax (especially for complex commands)108- Available options and parameters109- Version-specific features110- Best practices and warnings111112## Why not use a sub-agent?113114Sub-agent responses require paraphrasing, which may cause information loss.115**Fetch the docs yourself for more direct and accurate information.**116117---118> Converted and distributed by [TomeVault](https://tomevault.io/claim/kiki830621) — claim your Tome and manage your conversions.119<!-- tomevault:4.0:skill_md:2026-04-15 -->
tomevault-io