Individual skill
postgres-pro
Deep PostgreSQL know-how — indexing, tuning, JSONB, and administration — use when working with or troubleshooting Postgres.
skills/postgres-pro/SKILL.md
Source commit faf37c0859ebf627bfcb5225e8057d088691e0ae
What was checked
- Matches the observed repository HEAD
- Yes
- Scanner rules are current
- No
- Repository scan complete
- No
- Skill scan complete
- No
- Observed behavior
- Not checked yet
- Last checked
- Nov 8, 2026
These are observations at the recorded commit, not a guarantee of safety. Review the source before running it.
Install this skill
Choose an agent in your Stack or copy a command below. Commands fetch the pinned commit and copy only this skill directory. Existing destinations are refused. Copying a command does not install anything.
An install command is unavailable: current rules, complete repository and skill scans, an eligible behavior level and a permitted license are required.
Repository context
- Repository stars (not skill ratings)
- 54
- Repository last updated
- Oct 10, 2026
- License
- MIT
Observed agent integration: No specific integration evidence. Standard SKILL.md installation does not imply verified compatibility.
- agent-skills Repository topic
- ai-agents Repository topic
- ai-agents-automation Repository topic
- ai-skills Repository topic
- awesome Repository topic
- awesome-list Repository topic
- chatgpt Repository topic
- claude-skills Repository topic
- meta-ai Repository topic
- muse-ai Repository topic
- engineering Derived category
- data Derived category
- data-databases Derived category
Files and excerpt
File metadata and permitted, redacted excerpts come from the recorded scan. Source links are pinned to that commit.
Read excerpt
## Overview
PostgreSQL is a production workhorse: ACID-compliant, extensible, and generous with
features (JSONB, full-text search, arrays, PostGIS). This skill covers the
operational knowledge that separates a working Postgres setup from a reliable one:
choosing indexes, reading plans, tuning configuration, and safe administration.
## When to use
- Choosing between B-tree, GIN, GiST, BRIN, or hash indexes
- Investigating slow queries with `EXPLAIN (ANALYZE, BUFFERS)`
- Tuning `shared_buffers`, `work_mem`, `maintenance_work_mem`, autovacuum
- Designing schemas with JSONB, arrays, or full-text search
- Managing backups, replication, connections, and upgrades