PostgreSQL — экспертная оптимизация и администрирование

data

Postgres pro is a Claude Code skill that turns Claude into a senior PostgreSQL DBA: it optimizes queries, sets up replication, and wires in extensions on real production databases. Reach for it when queries are inexplicably slow and you need to read EXPLAIN ANALYZE output, when table bloat is eating disk space and autovacuum isn't keeping up, when you need to configure streaming or logical replication and monitor lag, or when a JSONB-heavy schema needs proper GIN indexing. The skill covers index design and verification across B-tree, GIN, GiST, and BRIN types; JSONB operators and containment queries; extensions including PostGIS, pgvector, and pg_trgm; VACUUM and autovacuum tuning for high-churn tables; and health monitoring via pg_stat views and pg_stat_statements. All index creation goes through CREATE INDEX CONCURRENTLY to avoid production locks. The direction is administering and tuning an existing PostgreSQL database — not schema design from scratch (use database-optimizer for that) or general infrastructure work (use devops-engineer). MIT license. Works with PostgreSQL 12–16 in any environment; not applicable to MySQL, SQLite, or other databases.