The postgres-patterns skill provides Claude with a specialized knowledge base for PostgreSQL development, focusing on high-performance query optimization and secure schema design. Based on industry-leading Supabase best practices, it offers quick-reference guides for index types, data types, and advanced SQL patterns like UPSERT, cursor pagination, and queue processing. It is particularly useful for developers looking to audit existing databases for slow queries, implement Row Level Security (RLS), or design scalable database architectures from the ground up.
主な機能
01214,597 GitHub stars
02Security-focused templates for Row Level Security (RLS) and monitoring configuration.
03Automated anti-pattern detection scripts for unindexed keys and table bloat.
04Advanced implementation patterns for UPSERT, pagination, and 'Skip Locked' queues.
05Best-practice data type mapping to avoid common storage and performance pitfalls.
06Comprehensive index cheat sheet covering B-tree, GIN, BRIN, and composite patterns.
ユースケース
01Designing and indexing a new database schema for maximum query efficiency.
02Implementing secure multi-tenant data access using Row Level Security policies.
03Troubleshooting slow-running queries and identifying missing database indexes.