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:
Quick answer
Supabase Postgres Best Practices is a free Muse skill that gives your Muse Supabase's Postgres best-practices guide for Postgres running anywhere, organized in 8 rule categories with wrong-versus-right SQL examples. Load it before writing or changing anything in a Postgres database, from tables and schema design to migrations, RLS policies, indexes, triggers, functions, queues, vector search, and slow-query diagnosis.
Install
Copy the install package below, then paste it into Muse🧪 Install ran in our test sandbox · Nov 4, 2026📌 Pinned version: commit c9be0e9Step 0 — before installing anything: read this install prompt, summarize in a few lines what this build does and what installing it involves, then ask me to confirm before you proceed. 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://raw.githubusercontent.com/supabase/agent-skills/c9be0e931b7930f7d02126d04774d904c381e7d7/skills/supabase-postgres-best-practices/SKILL.md Pinned version: install the code at commit c9be0e931b7930f7d02126d04774d904c381e7d7 exactly (Skill Harbor tested this version). Do not substitute a newer version. If this commit is unreachable, stop and tell me. 1. Fetch the SKILL.md file (and any helper files) from the repository path into a temporary folder 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.
Saved to your recent installs. Find it anytime on /connect.
🔒 Security, provenance and what this touches
The install prompt below already includes the vetting steps: your agent follows the community checklist before installing anything with executable code. Want more?
Verification certificate
Dated facts about what was checked for this listing, and how. This is not a safety certification.
- Pinned version
- c9be0e9 · 2026-10-13
- Sandbox install test
- Install ran in our test sandbox · Nov 4, 2026 · Observed during the install test: registry.npmjs.org
- Creator identity
- Not verified
- Fingerprint watch
- Last checked · Nov 19, 2026 : no change detected in the files linked by this install prompt
- Install prompt analysis
- 2026-10-13 : No commands, network calls, packages, file writes or API keys detected.
Skill Harbor never reviews the code of a listed skill. These are dated facts about the install prompt and our install test, not a safety certification. Review a skill yourself before you install it. How we verify
Questions
How do I install a skill?
Every product page includes a copy-paste install prompt. Paste it into your Muse and it sets the skill 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 skill before installing it.