postgres-best-practices

SKILL.md

Source: This skill is based on Supabase's Postgres Best Practices for AI agents. See the announcement blog post.

Comprehensive Postgres performance optimization guide. Contains rules across 8 categories, prioritized by impact from critical (query performance, connection management) to incremental (advanced features).

| 1 | Query Performance | CRITICAL | | 2 | Connection Management | CRITICAL | | 3 | Security & RLS | CRITICAL | | 4 | Schema Design | HIGH | | 5 | Concurrency & Locking | MEDIUM-HIGH | | 6 | Data Access Patterns | MEDIUM | | 7 | Monitoring & Diagnostics | LOW-MEDIUM | | 8 | Advanced Features | LOW |

Postgres performance optimization and best practices from Supabase. Query performance, connection pooling, Row Level Security, schema design, and diagnostics. Source: dirnbauer/webconsulting-skills.

View raw