From postgresql-guide
Query PostgreSQL official documentation for accurate SQL syntax, configuration, and best practices. Use this skill proactively when the conversation involves: - PostgreSQL SQL syntax, commands, queries - Data types, functions, operators - Database configuration, postgresql.conf - Performance tuning, EXPLAIN, indexes - Backup, restore, replication - PL/pgSQL, stored procedures, triggers
How this skill is triggered — by the user, by Claude, or both
Slash command
/postgresql-guide:postgresql-guideThis skill is limited to the following tools:
The summary Claude sees in its skill listing — used to decide when to auto-load this skill
This Skill queries official PostgreSQL documentation for accurate information.
This Skill queries official PostgreSQL documentation for accurate information.
When the user asks about or the conversation involves:
You MUST WebFetch official documentation - never answer from memory!
| 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 |
Base URL: https://www.postgresql.org/docs/current/
SQL command documentation follows the pattern:
https://www.postgresql.org/docs/current/sql-{command}.html
Examples:
Extract relevant information from WebFetch results and answer the user directly.
| 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 |
Never answer PostgreSQL questions from memory!
PostgreSQL documentation is comprehensive and regularly updated. Always fetch the current documentation for:
Sub-agent responses require paraphrasing, which may cause information loss. Fetch the docs yourself for more direct and accurate information.
npx claudepluginhub psychquant/psychquant-claude-plugins --plugin postgresql-guidePostgreSQL 16+ reference for writing SQL queries (SELECT, CTEs, windows), designing schemas, creating indexes (B-tree, GIN), managing transactions, using JSONB, analyzing with EXPLAIN ANALYZE, and psql CLI.
Guides PostgreSQL operations: schema design, index selection (B-tree/GIN/GiST/BRIN), query tuning (EXPLAIN ANALYZE), backups (pg_dump/pg_basebackup), replication, vacuum tuning, monitoring (pg_stat_statements), RLS, extensions (PostGIS/timescaledb).
Optimizes PostgreSQL queries, configures replication, uses extensions, and tunes VACUUM. Use for EXPLAIN analysis, JSONB operations, and performance monitoring.