Implements optimized PostgreSQL schema designs, indexing strategies, and Row Level Security policies based on industry best practices.
This skill provides an expert reference for PostgreSQL development, helping users write high-performance SQL queries and maintain robust database schemas. It includes quick references for index selection (B-tree, GIN, BRIN), optimal data type usage, and implementation patterns for advanced features like UPSERT, cursor pagination, and 'Skip Locked' job queues. By leveraging Supabase-aligned standards, it ensures your database remains scalable, secure via Row Level Security (RLS), and free from common anti-patterns like unindexed foreign keys or table bloat.
主要功能
01Comprehensive Indexing Guide for B-tree, GIN, BRIN, Partial, and Covering indices
02Configuration templates for connection limits, timeouts, and security defaults
03Efficient pagination and queue processing patterns for scalable backends
04Automated anti-pattern detection for unindexed foreign keys and table bloat
050 GitHub stars
06Optimized Row Level Security (RLS) policy implementation for secure multi-tenancy
使用场景
01Designing high-performance database schemas for new production applications
02Implementing secure data access layers using PostgreSQL Row Level Security
03Troubleshooting and optimizing slow SQL queries and database bottlenecks
