supabase-postgres-best-practices
Supabase Postgres Best Practices
Postgres query performance and runtime optimization for Supabase projects. Focus: making queries fast, connections efficient, and RLS performant at runtime.
Scope & Boundaries
| Topic | This Skill | Other Skill |
|---|---|---|
| Query optimization, indexing, EXPLAIN | Here | - |
| Connection pooling (Supavisor), timeouts | Here | - |
| RLS performance (subquery caching, index) | Here | supabase-auth-patterns (RLS policy design, auth flows) |
| Concurrency, locking, queues | Here | - |
| Monitoring (pg_stat_*, VACUUM) | Here | - |
| Unused index detection, index maintenance | Here | - |
| Full-text search, JSONB query tuning | Here | - |
| Edge Function DB connections | Here | - |
| Schema design (naming, types, constraints, FK) | - | ansem-db-patterns |
| Auth flows, session management, RLS creation | - | supabase-auth-patterns |
| Query performance debugging process | - | systematic-debugging (Phase 1 investigation) |
More from diegosouzapw/awesome-omni-skill
music-assistant
Control Home Assistant Music Assistant - browse library, search, play, manage preferences and moods.
12agent-code-generator
Generates Agent definitions (.md files) based on user intent and standard templates.
6terragrunt-generator
Comprehensive toolkit for generating best practice Terragrunt configurations (HCL files) following current standards and conventions. Use this skill when creating new Terragrunt resources (root configs, child modules, stacks, environment setups), or building multi-environment Terragrunt projects.
6_backend-mastery
Master backend architectures, REST API design, microservices, and server-side development across multiple languages. Use this as a central index to access specialized sub-skills.
6api contract sync manager
Validate OpenAPI, Swagger, and GraphQL schemas match backend implementation. Detect breaking changes, generate TypeScript clients, and ensure API documentation stays synchronized. Use when working with API spec files (.yaml, .json, .graphql), reviewing API changes, generating frontend types, or validating endpoint implementations.
5upstash/workflow typescript sdk skill
Lightweight guidance for using the Upstash Workflow SDK to define, trigger, and manage workflows. Use this Skill whenever a user wants to create workflow endpoints, run steps, or interact with the Upstash Workflow client.
5