skills sourced live from GitHub · all skills listed are free · each skill is provided under its author's license.
home / Database / Supabase Postgres Best Practices Skill by @supabase
The skill is the skills/supabase-postgres-best-practices folder inside that repository. Copy it into the folder your agent loads skills from; check your agent's documentation for where that is.
Postgres best practices maintained by Supabase, for Postgres running anywhere.
Postgres best practices maintained by Supabase, for Postgres running anywhere. Load it before creating or changing tables, columns and queries. It is organised as prioritised rule categories with references.
The original SKILL.md is organised into these sections:
Written and maintained by @supabase. It is published under the MIT license, which allows reuse with attribution. See the author profile. SkillDirectory does not claim authorship: this page adds our own review and links back to the original, and the skill's text belongs to its author.
# Supabase Postgres Best Practices Comprehensive performance optimization guide for Postgres, maintained by Supabase. Contains rules across 8 categories, prioritized by impact to guide automated query optimization and schema design. ## When to Apply Reference these guidelines when: - Writing SQL queries or designing schemas - Implementing indexes or query optimization - Reviewing database performance issues - Configuring connection pooling or scaling - Optimizing for Postgres-specific features - Working with Row-Level Security (RLS) ## Rule Categories by Priority | Priority | Category | Impact | Prefix | |----------|----------|--------|--------| | 1 | Query Performance | CRITICAL | `query-` | | 2 | Connection Management | CRITICAL | `conn-` | | 3 | Security & RLS | CRITICAL | `security-` | | 4 | Schema Design | HIGH | `schema-` | | 5 | Concurrency & Locking | MEDIUM-HIGH | `lock-` | | 6 | Data Access Patterns | MEDIUM | `data-` | …
Excerpt only, quoted from the author's repository. Open the repository for the complete file.