Optimizes PostgreSQL database design and performance using industry-standard best practices and patterns.
This Claude Code skill provides a comprehensive reference for PostgreSQL development, covering everything from schema design and indexing strategies to security through Row Level Security (RLS). It helps developers implement efficient query patterns, avoid common anti-patterns like unindexed foreign keys, and configure database settings for optimal performance. Based on Supabase best practices, it is an essential tool for backend engineers looking to build scalable and secure database architectures directly within their AI-powered workflow.
Key Features
01Row Level Security (RLS) policy optimization for secure multi-tenancy
0261 GitHub stars
03Advanced performance patterns for UPSERT, cursor pagination, and job queues
04Optimized indexing strategies including B-tree, GIN, BRIN, and composite indices
05Automated anti-pattern detection for unindexed foreign keys and table bloat
06Schema design best practices for data types, IDs, and naming conventions
Use Cases
01Implementing secure access control policies for web and mobile applications
02Designing high-performance database schemas for new backend services
03Troubleshooting and refactoring slow-running SQL queries
