← All skills

supabase-postgres-best-practices

85 / 100 · Low risk

Fine to try.

By diegosouzapw/awesome-omni-skill (GitHub) · design · 66 stars · scanned at commit a6b3c30

Postgres query performance optimization and runtime best practices for Supabase. Covers indexing strategies (B-tree, GIN, GiST, BRIN, composite, partial, covering), EXPLAIN ANALYZE diagnostics, connection pooling (Supavisor transaction/session modes, pool sizing), RLS performance patterns (auth.uid() subquery caching, SECURITY DEFINER bypass), concurrency control (deadlock prevention, SKIP LOCKED, advisory locks), data access optimization (N+1 elimination, keyset pagination, batch inserts, UPSE…

Works with any agent that supports SKILL.md skills.

What this skill can do

Install

Paste this into your terminal. It downloads exactly the version we scanned, not whatever is newest.

if [ -e ~/.agents/skills/'supabase-postgres-best-practices' ] || [ -L ~/.agents/skills/'supabase-postgres-best-practices' ]; then echo 'A skill folder named supabase-postgres-best-practices already exists — not replacing it' >&2; false; else d=$(mktemp -d) && git clone --quiet --filter=blob:none --no-checkout 'https://github.com/diegosouzapw/awesome-omni-skill' "$d" && git -C "$d" checkout --quiet 'a6b3c3005cedf056a48b084671c6282426d6e9fc' -- 'skills/development/supabase-postgres-best-practices' && mkdir -p ~/.agents/skills && cp -R "$d"/'skills/development/supabase-postgres-best-practices' ~/.agents/skills/'supabase-postgres-best-practices' && rm -rf "$d"; fi

Codex reads ~/.agents/skills directly. For Claude Code, Cursor, Copilot, Gemini CLI, Antigravity or OpenCode, also link it. For Claude Code: ln -s ~/.agents/skills/'supabase-postgres-best-practices' ~/.claude/skills/'supabase-postgres-best-practices' (other agents: ~/.cursor/skills, ~/.copilot/skills, ~/.gemini/skills, ~/.gemini/config/skills, ~/.config/opencode/skills). Or install through the finder skill, which does both.

Badge for your README

The badge for diegosouzapw/awesome-omni-skill shows the score of its lowest-scoring skill.

[![SkillTrust](https://zalavijaysinh.github.io/skilltrust/badges/diegosouzapw/awesome-omni-skill.svg)](https://zalavijaysinh.github.io/skilltrust/repos/diegosouzapw/awesome-omni-skill/)

Score history