Postgres Best Practices

概要

Postgres Best Practices is a comprehensive performance optimization guide designed to enhance database efficiency, security, and scalability within Claude Code. Maintained with insights from Supabase, it provides actionable guidance across eight critical categories, including query optimization, connection management, and Row-Level Security (RLS). This skill is essential for developers writing complex SQL, designing resilient schemas, or troubleshooting database bottlenecks, ensuring that every database interaction follows industry-leading standards for production-grade reliability.

主な機能

• Schema design patterns to prevent locking and concurrency issues
• 0 GitHub stars
• Automated query performance analysis and indexing recommendations
• Guidance on efficient connection management and pooling strategies
• Best practices for secure Row-Level Security (RLS) implementation
• Detailed SQL examples comparing optimized vs. unoptimized code

ユースケース

• Optimizing slow-running SQL queries through better indexing and structure
• Designing scalable database schemas for high-concurrency applications
• Auditing and implementing robust Row-Level Security policies for data privacy