supabase-postgres-best-practices
Postgres performance optimization rules across 8 priority categories, from query tuning to advanced features.
- Organized into 8 rule categories prioritized by impact: query performance and connection management (critical), security and RLS, schema design, concurrency, data access patterns, monitoring, and advanced features
- Each rule includes detailed explanations, incorrect vs. correct SQL examples, EXPLAIN output analysis, and performance metrics to guide optimization decisions
- Covers query indexing, connection pooling, Row-Level Security configuration, schema design patterns, locking behavior, and Postgres-specific tuning
- Designed for use during SQL writing, schema design, performance reviews, and database scaling decisions
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- |
More from supabase/agent-skills
supabase
Use when doing ANY task involving Supabase. Triggers: Supabase products (Database, Auth, Edge Functions, Realtime, Storage, Vectors, Cron, Queues); client libraries and SSR integrations (supabase-js, @supabase/ssr) in Next.js, React, SvelteKit, Astro, Remix; auth issues (login, logout, sessions, JWT, cookies, getSession, getUser, getClaims, RLS); Supabase CLI or MCP server; schema changes, migrations, security audits, Postgres extensions (pg_graphql, pg_cron, pg_vector).
64.0Kskill-creator
Guide for creating effective skills. This skill should be used when users want to create a new skill (or update an existing skill) that extends Claude's capabilities with specialized knowledge, workflows, or tool integrations.
691
More in Databases
firebase-basics
Firebase setup, Firestore queries, security rules, and project configuration
firebase/agent-skillsfirebase-auth-basics
Firebase Authentication flows, providers, custom claims, and session management
firebase/agent-skillsfirebase-firestore-enterprise-native-mode
Firestore at scale: sharding, composite indexes, and enterprise data modeling
firebase/agent-skillsconvex-quickstart
Convex schema, queries, mutations, and real-time reactivity patterns
get-convex/agent-skillsconvex-setup-auth
Authentication in Convex with Clerk, Auth0, and custom JWT providers
get-convex/agent-skills