Claude Code plugin for postgresql development
Administer PostgreSQL - security, roles, permissions, maintenance
Master advanced PostgreSQL queries - CTEs, window functions, recursive queries
PostgreSQL backup and recovery - pg_dump, pg_basebackup, PITR
Essential PostgreSQL extensions - pg_stat_statements, pg_trgm, PostGIS
Master PostgreSQL SQL fundamentals - data types, tables, constraints, schema design
Work with JSONB data - queries, indexing, transformations
PostgreSQL monitoring - metrics, alerting, observability
Optimize PostgreSQL performance - EXPLAIN ANALYZE, indexing, query tuning
Write PL/pgSQL - functions, procedures, triggers, error handling
PostgreSQL streaming replication - setup, monitoring, failover
Scale PostgreSQL - partitioning, connection pooling, high availability