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 |

Optimisation des performances Postgres et meilleures pratiques de Supabase. Performances des requêtes, regroupement de connexions, sécurité au niveau des lignes, conception de schéma et diagnostics. Source : dirnbauer/webconsulting-skills.

Voir l'original