skills.rest
SeniduRavihara
SeniduRaviharaCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

supabase-postgres-best-practices

Analyze Supabase Postgres workloads and generate optimization plans for indexing, RLS, partitioning, and maintenance.

Updated Aug 23, 2026
Search Tags:#performance#rls#supabase#indexes#best-practices#query-optimization#postgres
One-click install
npx skills add https://github.com/SeniduRavihara/construction.lk --skill supabase-postgres-best-practices-seniduravihara
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: supabase-postgres-best-practices
Source: https://github.com/SeniduRavihara/construction.lk/tree/main/.agents/skills/supabase-postgres-best-practices
Command: npx skills add https://github.com/SeniduRavihara/construction.lk --skill supabase-postgres-best-practices-seniduravihara

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.

Core Features & Use Cases

  • Comprehensive rules across 8 categories, prioritized by impact, to guide performance improvements.
  • Includes explicit incorrect vs. correct SQL examples, query plan analyses, and metrics to drive automated optimization and code generation.
  • Applicable to query tuning, schema design, security (RLS), partitioning, maintenance (VACUUM/ANALYZE), and connection management in Supabase projects.

Quick Start

Analyze a Supabase project's Postgres workload and apply recommended patterns across indexing, partitioning, RLS, and maintenance.

Frequently Asked Questions about supabase-postgres-best-practices

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I optimize Postgres query performance in Supabase?▼

To optimize Postgres query performance in Supabase, apply indexing strategies, analyze query plans, and follow schema design best practices prioritized by impact across eight performance categories to generate actionable optimization plans.

What are the best practices for writing Supabase RLS policies?▼

Supabase RLS best practices involve applying security rules using explicit incorrect versus correct SQL examples to ensure policies meet concrete security improvement requirements without degrading database performance.

How do I configure Postgres partitioning and maintenance tasks in Supabase?▼

Postgres partitioning and maintenance in Supabase requires applying recommended patterns for VACUUM, ANALYZE, and connection management to maintain schema health and workload efficiency in a live environment.

Do I need existing schema definitions to analyze Supabase Postgres gaps?▼

Yes, analyzing Supabase Postgres gaps requires access to existing schema definitions, indexes, policies, and configuration parameters to identify optimization opportunities and generate actionable performance plans.

Why is my Supabase Postgres query slow despite having indexes?▼

Slow Supabase Postgres queries despite indexes can stem from schema design flaws or missing maintenance tasks, requiring query plan analysis and configuration reviews to identify and resolve specific performance bottlenecks.

Related Skills

Explore More Software Engineering Skills→
Joel-barriosnuevoJoel-barriosnuevo

supabase-postgres-best-practices

Optimize Postgres performance and best practices for Supabase projects.

Community
Advanced
DanejwDanejw
1

supabase-postgres-best-practices

Consolidate PostgreSQL performance best practices for Supabase into a structured workflow.

Community
Advanced
MarcoAvendanoMarcoAvendano
1

supabase-postgres-best-practices

Optimize PostgreSQL queries and schema design with Supabase best practices.

Community
Intermediate
MOODMNKY-LLCMOODMNKY-LLC

supabase-postgres-best-practices

Review and optimize Postgres queries and schema designs for Supabase.

Community
Intermediate