supabase-postgres-best-practices

The rules are divided into eight categories, sorted by impact: query performance, connection management, security and RLS, table schema design, concurrency and locking, data access patterns, monitoring and diagnostics, and advanced features. Each rule is in its own file, containing the rationale, incorrect and correct SQL examples, optional EXPLAIN output, and Supabase-specific notes. These apply to Postgres running anywhere, and are also useful for troubleshooting slow queries, connection exhaustion, locks, and multi-tenant data leakage.

The rules are divided into eight categories, sorted by impact: query performance, connection management, security and RLS, table schema design, concurrency and locking, data access patterns, monitoring and diagnostics, and advanced features. Each rule is in its own file, containing the rationale, incorrect and correct SQL examples, optional EXPLAIN output, and Supabase-specific notes. These apply to Postgres running anywhere, and are also useful for troubleshooting slow queries, connection exhaustion, locks, and multi-tenant data leakage.

Why it matters: Requires agents to load these rules before modifying any Postgres schema, migrations, RLS policies, or indexes. Rules are graded by impact, and each includes a comparison of incorrect and correct SQL.

skills.sh installs 489574 (+1258 / 24h)

Security Audit: Not audited

  • Not yet scanned

Rationale

  • skills.sh shows 1258 installs in the last 24 hours, with a total of 489574 (indicating only attention level); MIT licensed, officially maintained by Supabase
  • Reviewed SKILL.md from the repository: it consists of read-only reference files and contains no steps that execute commands

Usage

  • After installation, when you ask the agent to "add an index to the orders table and write a migration," it will first read the relevant query- and schema- rule files

Risks

  • Has not yet undergone automated desktop auditing; the website does not display installation commands
  • The rules primarily focus on generic Postgres, with some syntax specific to the Supabase environment

Open · Repository

Best Skills 每日数据(LinklyAI / @BlueeonY,CC BY 4.0)

Explore the latest AI Radar updates