Supabase

Supabase Postgres Best Practices

Review PostgreSQL queries, schemas, indexes, locking, connections, and RLS with prioritized operational guidance from Supabase.

Vecbase review

A well-structured PostgreSQL review library for agents that need concrete rules instead of generic database advice. Apply each recommendation to the actual workload and migration safety boundary.

What stands out

  • Maintained by Supabase and organized into focused references prioritized by operational impact.
  • Covers performance, schema design, concurrency, connections, monitoring, and RLS in one workflow.
  • The inspected skill contains no bundled executable scripts.

What to know

  • Vecbase reviewed the complete source and license but did not run a task-shaped evaluation for this listing.
  • Query and index advice requires evidence from the target schema, workload, and query plans.

What it can do

  • Review query plans, indexes, pagination, and data-access patterns
  • Check types, constraints, keys, partitioning, and naming choices
  • Identify locking, deadlock, transaction, and connection risks
  • Review privileges and row-level security behavior

Try it

Review this PostgreSQL migration for indexing, locking, RLS, and rollback risks.
Explain why this query is slow and propose changes supported by its query plan.