This skill equips Claude with expert-level knowledge for architecting, optimizing, and securing PostgreSQL databases. It provides a comprehensive reference for selecting optimal index types (B-tree, GIN, BRIN), choosing correct data types, and implementing advanced SQL patterns like Row Level Security (RLS), UPSERT operations, and efficient cursor pagination. Additionally, it includes diagnostic tools for detecting anti-patterns such as unindexed foreign keys, slow queries, and table bloat, ensuring your database remains performant and scalable.
Key Features
010 GitHub stars
02Anti-pattern detection scripts for performance troubleshooting
03Best practice data type mapping for storage efficiency
04Comprehensive indexing guide for B-tree, GIN, and BRIN types
05Pre-configured templates for database monitoring and security
06Optimized Row Level Security (RLS) policy templates
