← Search

PostgreSQL Patterns
Database 🧪 Install ran in our test sandbox · Nov 11, 2026 📌 Pinned version: commit 4eb71d9
Install test only, on the date shown. This does not guarantee the code is safe.
⚙ Needs: none to install.

PostgreSQL Patterns

PostgreSQL for Muse: index cheat sheet (B-tree, GIN, BRIN), composite and partial indexes, RLS policies, upserts, cursor pagination, queue processing, and anti-pattern detection queries.

At a glance
What
PostgreSQL for Muse: index cheat sheet (B-tree, GIN, BRIN), composite and partial indexes, RLS policies, upserts, cursor pagination, queue processing, and anti-pattern detection queries.
Cost
Free
Needs
none to install. Pure guidance; a PostgreSQL database (or a schema to design) helps.
Level
Beginner
Install
Copy the installer prompt below into your Muse — your agent does the rest.

Version:

Quick answer

PostgreSQL Patterns is a free skill for Muse. It helps Muse design schemas, pick indexes, and debug slow queries like a DBA, following Supabase best practices. It covers an index cheat sheet mapping query patterns to B-tree, composite, GIN, and BRIN indexes, plus copy-ready patterns for upserts, cursor pagination, and queue processing.

⌁

Install

Copy the install package below, then paste it into Muse🧪 Install ran in our test sandbox · Nov 11, 2026📌 Pinned version: commit 4eb71d9

Pinned version: install the code at commit 4eb71d92a39cab44ad40ac9d8a6a5ccb4029d6c2 exactly (Skill Harbor tested this version). Do not substitute a newer version. If this commit is unreachable, stop and tell me. Use "PostgreSQL Patterns" with your Muse. Prerequisites: none to install. Pure guidance; a PostgreSQL database (or a schema to design) helps. 1. Open the skill: https://raw.githubusercontent.com/affaan-m/ECC/4eb71d92a39cab44ad40ac9d8a6a5ccb4029d6c2/skills/postgres-patterns/SKILL.md and copy the full SKILL.md text. 2. Paste it into a chat with Muse and add: "Review this schema (or slow query) against PostgreSQL best practices: [paste schema or query]." 3. Ask it to propose the right index type per query pattern, flag anti-patterns (unindexed foreign keys, OFFSET pagination, float for money), and draft the migration. Tip: paste the output of pg_stat_statements and ask "which queries need an index, and which index type?" Safety: a skill is plain-text instructions; it runs nothing by itself. Review generated SQL before running it on production data.

🔒 Security, provenance and what this touches
🧭 What this touches
Based on the install prompt we scanned, this skill does not run commands, make third-party network calls, install packages, write files, or ask for API keys.
Install prompt analysis · 2026-10-13
🔒 Security and provenance
📌 Pinned version: commit 4eb71d9 · 2026-10-13
🧪 Install ran in our test sandbox · Nov 11, 2026
👁 Observed during the install test · Nov 11, 2026 : no network contact
🔎 Last checked · Nov 21, 2026 : no change detected in the files linked by this install prompt
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
Wanna be extra careful?

The install prompt below already includes the vetting steps: your agent follows the community checklist before installing anything with executable code. Want more?

How to check a skill before installing →

✓

Verification certificate

Dated facts about what was checked for this listing, and how. This is not a safety certification.

Pinned version
4eb71d9 · 2026-10-13
Sandbox install test
Install ran in our test sandbox · Nov 11, 2026
Creator identity
Not verified
Fingerprint watch
Last checked · Nov 21, 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.