This skill provides a comprehensive toolkit for PostgreSQL database management, focusing on high-performance schema design and query optimization. It equips Claude with specialized knowledge for selecting the right index types, implementing advanced SQL patterns like UPSERT and cursor-based pagination, and hardening security through optimized Row-Level Security (RLS) policies. By integrating industry-standard best practices from the Supabase ecosystem, it helps developers avoid common anti-patterns such as unindexed foreign keys and table bloat while providing ready-to-use configuration templates for connection pooling and monitoring.
主要功能
01112,917 GitHub stars
02Indexing cheat sheet for B-tree, GIN, BRIN, and composite indexes
03Advanced SQL patterns for UPSERT, queue processing, and cursor-based pagination
04High-performance data type recommendations for IDs, currency, and timestamps
05Optimized Row-Level Security (RLS) policy templates for enhanced data safety
06Automated anti-pattern detection for slow queries and unindexed foreign keys
使用场景
01Designing scalable database schemas with correct indexing and data types
02Troubleshooting and optimizing slow-running SQL queries in production
03Implementing secure multi-tenant architectures using Row-Level Security