supabase-postgres-best-practices

A Postgres best practices skill maintained by Supabase, applicable to Postgres running anywhere. It requires agents to load it before creating or altering tables, designing schemas, writing migrations, writing and testing RLS policies, creating indexes, triggers, queues, and scheduled tasks, performing pgvector retrieval, or importing data; it is also used when troubleshooting slow queries, high CPU usage, connection exhaustion, locks, and data visibility issues across incorrect tenants. The rules are divided into 8 categories sorted by impact (prioritizing query performance, connection management, and security/RLS), with each rule accompanied by examples of incorrect and correct SQL.

A Postgres best practices skill maintained by Supabase, applicable to Postgres running anywhere. It requires agents to load it before creating or altering tables, designing schemas, writing migrations, writing and testing RLS policies, creating indexes, triggers, queues, and scheduled tasks, performing pgvector retrieval, or importing data; it is also used when troubleshooting slow queries, high CPU usage, connection exhaustion, locks, and data visibility issues across incorrect tenants. The rules are divided into 8 categories sorted by impact (prioritizing query performance, connection management, and security/RLS), with each rule accompanied by examples of incorrect and correct SQL.

Why it matters Database changes are costly when errors occur. The rules include side-by-side comparisons of incorrect and correct SQL, helping agents avoid pitfalls when writing migrations and queries.

skills.sh install count 478483 (+1074 / 24h)

Security Audit: Risk warnings present

  • Initial screening only: Only SKILL.md was scanned; no full repository audit was performed. Installation commands are not currently provided.
  • Audit scope: GitHub supabase/agent-skills/skills/supabase-postgres-best-practices/SKILL.md (only the SKILL.md text was scanned)

Rationale

  • skills.sh installs in 24 hours: 1074 (represents attention level only)

Usage

  • Automatically loaded by agents when writing or modifying any Postgres-related content. Specific rules should be looked up in the references/ directory by prefix.

Risks

  • The automated audit only scanned SKILL.md and does not currently display installation commands; the skill consists of pure documentation rules and does not require executing commands, which aligns with its purpose.
  • No account is required; some rules contain Supabase-specific instructions, so self-hosted Postgres users must evaluate applicability themselves.

Open · Repository

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

Explore the latest AI Radar updates