Verified:GitHub

supabase-postgres-best-practices

Optimizes Postgres queries and provides actionable ORM-independent recommendations for improving database performance and maintainability.

Updated Apr 19, 2026

Search Tags:#indexing #database #rls #partitioning #query-optimization #postgres

Ready to run

npx skills add https://github.com/NihaalManaf/LDR-Island --skill supabase-postgres-best-practices-nihaalmanaf

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: supabase-postgres-best-practices
Source: https://github.com/NihaalManaf/LDR-Island/tree/main/.cursor/skills/supabase-postgres-best-practices
Command: npx skills add https://github.com/NihaalManaf/LDR-Island --skill supabase-postgres-best-practices-nihaalmanaf

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

A comprehensive, category-driven set of rules covering 8 priority areas (Query Performance, Connection Management, Security & RLS, Schema Design, Concurrency & Locking, Data Access Patterns, Monitoring & Diagnostics, Advanced Features).
On-demand references organized by topic to guide implementation, auditing, and automated tooling.
Real-world workflows enabling safe and scalable improvements to indexes, partitioning, policies, and configuration.

Quick Start

Begin by analyzing a representative Postgres schema to identify a common slow query and apply a targeted composite index to validate performance gains.

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 slow PostgreSQL queries in Supabase?▼

You can optimize slow PostgreSQL queries by identifying performance bottlenecks and applying targeted composite indexes. This skill codifies best-practice patterns across queries, indexing, and schema design for Supabase deployments.

What are the best practices for Supabase Row Level Security policies?▼

Supabase Row Level Security (RLS) best practices involve codifying secure data access patterns. This skill provides reference materials and rules across eight priority areas, including Security and RLS, to ensure safe and scalable policy implementations.

When should I use table partitioning in Postgres?▼

Table partitioning in Postgres is applied when optimizing large datasets through schema design and data access patterns. This skill provides workflows and reference materials to guide safe and scalable partitioning implementations for typical deployments.

Does this Supabase Postgres optimization guide cover connection management?▼

Yes, this guide covers connection management. It provides a comprehensive set of rules across eight priority areas, including Connection Management, Concurrency and Locking, and Monitoring and Diagnostics for typical Postgres deployments.

How do I diagnose and resolve database concurrency and locking issues?▼

To diagnose database concurrency and locking issues, apply codified best-practice patterns for Concurrency and Locking. This skill offers real-world workflows and on-demand references to enable safe and scalable improvements to your Postgres configuration.