Supabase Postgres Best Practices
Supabase's Postgres best-practices guide for Postgres running anywhere — 8 rule categories with wrong-vs-right SQL examples
- What
- Supabase's Postgres best-practices guide for Postgres running anywhere — 8 rule categories with wrong-vs-right SQL examples
- Cost
- Free
- Needs
- a Muse account with skill installation enabled
- Install
- Copy the installer prompt below into your Muse — your agent does the rest.
Curated by Skill Harbor — the official Postgres best-practices skill maintained by Supabase, written for Postgres running anywhere, not just on Supabase. Load it before writing or changing anything that lives in a Postgres database — tables and column types, schema design, migrations, RLS policies and their tests, indexes, triggers, functions, queues and scheduled jobs (pg_cron, pgmq), vector search (pgvector), or diagnosing slow queries, high CPU, EXPLAIN plans, connection exhaustion, locking and bloat. Rules are organised in 8 categories prioritised by impact, from critical (query performance, connection management, security & RLS) down to incremental (advanced features), each rule pairing a wrong SQL example with the right one plus query-plan analysis. By @supabase, listed here with credit to its creator. Honest caveats: it's guidance, version 1.1.1 (January 2026) — it doesn't replace testing against your own workload and data shape; the deep rule files live in the repo's references directory, so install the whole folder, not just the SKILL.md. Skill Harbor never reviews the code, review it yourself before use.
Version:
Install
Prerequisites: a Muse account with skill installation enabled Install "Supabase Postgres Best Practices" for me. Supabase's Postgres best-practices guide for Postgres running anywhere — 8 rule categories with wrong-vs-right SQL examples Repository: https://github.com/supabase/agent-skills/blob/main/skills/supabase-postgres-best-practices/SKILL.md 1. Fetch the SKILL.md file (and any helper files) from the repository path into a temporary folder and summarize what it does in one or two sentences. 2. Safety check: review the SKILL.md and scripts for anything suspicious (unexpected network calls, shell commands, credential harvesting). This repo should contain zero secrets in code, credentials only via the secure vault. Verify that holds here; STOP on any red flag and tell me. 3. Install it as a skill: copy SKILL.md and its helper files into the agent's skills directory, in a folder named "supabase-postgres-best-practices". 4. Verify with no network calls: frontmatter valid, files in place. 5. Report what was installed, where, and what I still need to do myself (e.g. save my API key in the vault). GitHub is optional: if I have a GitHub account or the gh CLI, you may use it; otherwise public access is fine. Never require it unless it's in the prerequisites above. Rules: don't touch anything outside the temp folder and the install target. If anything looks off, stop and ask me.
Questions
How do I install a build?
Every product page includes a copy-paste install prompt. Paste it into your Muse and it sets the build up for you — no manual configuration.
Where does my money go?
Straight to the seller. Skill Harbor never processes payments: checkout happens on the seller’s own page, usually Stripe.
What does the ✓ next to a creator’s name mean?
It means we confirmed the identity of the person behind the listing. It says nothing about the code itself — always check a build before installing it.