supabase-postgres-best-practices

Identify and apply Supabase Postgres performance best practices for queries, indexing, and configuration.

Updated Feb 27, 2026
One-click install
npx skills add https://github.com/pau-vega/react-router-drizzle --skill supabase-postgres-best-practices-pau-vega
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: supabase-postgres-best-practices
Source: https://github.com/pau-vega/react-router-drizzle/tree/main/.agents/skills/supabase-postgres-best-practices
Command: npx skills add https://github.com/pau-vega/react-router-drizzle --skill supabase-postgres-best-practices-pau-vega

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This skill consolidates Supabase and PostgreSQL best practices into a structured, actionable guide to improve query performance, schema design, and configuration.

Core Features & Use Cases

  • Comprehensive performance rules spanning 8 priority categories to guide automated tuning and design decisions.
  • Clear, practical examples for indexing, query strategies, and configuration adjustments applicable to real-world Postgres deployments.
  • Quick-start checklists and decision paths for on-demand performance reviews in development and production.

Quick Start

Run a prioritized Postgres optimization review against your current schema and queries to identify quick wins.

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 PostgreSQL query performance in Supabase?▼

To optimize PostgreSQL query performance in Supabase, you apply structured best practices for indexing, query strategies, and configuration adjustments. This skill provides actionable rules across 8 priority categories to guide tuning decisions.

What are the best practices for indexing a Supabase Postgres database?▼

Best practices for indexing a Supabase Postgres database involve applying concrete, category-specific rules for index creation and query strategies. The skill provides clear examples to help developers and DBAs identify quick wins for schema design.

How do I run a Postgres performance review on my current schema?▼

You run a Postgres performance review by using quick-start checklists and decision paths to evaluate your current schema and queries. This identifies actionable optimization steps and quick wins for development and production environments.

Can I use these Postgres optimization rules for deployment configuration adjustments?▼

Yes, you can use these Postgres optimization rules to make deployment configuration adjustments. The skill provides a structured rule set covering configuration, schema design, and SQL workload tuning specifically for Postgres-based projects using Supabase.

What is the best way to fix slow Supabase SQL queries?▼

The best way to fix slow Supabase SQL queries is to apply targeted performance best practices for query speed and indexing. This skill offers a prioritized optimization review with concrete examples and performance metrics to resolve bottlenecks.