skills.rest
NihaalManaf
NihaalManafCOMMUNITY
Explore all skills by this author →
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
One-click install
npx skills add https://github.com/NihaalManaf/LDR-Island --skill supabase-postgres-best-practices-nihaalmanaf
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
kensauruskensaurus
8

database-optimization

Profile slow queries and optimize indexes in PostgreSQL, Prisma, and Supabase.

Community
Advanced
vijaykpatelvijaykpatel

supabase-postgres-best-practices

Analyze Supabase/Postgres schemas and queries to apply optimization recommendations.

Community
Advanced
markshd12-cloudmarkshd12-cloud

supabase-postgres-best-practices

Optimize PostgreSQL query performance, schema design, and security for Supabase databases.

Community
Advanced
BoraPerusicBoraPerusic

postgres-best-practices

Identify and apply Postgres performance best practices for Supabase deployments.

Community
Advanced