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.
- 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.
Curated by Skill Harbor: PostgreSQL database patterns that make Muse design schemas, pick indexes, and debug slow queries like a DBA. Based on Supabase best practices (credit: Supabase team). Covers the full quick-reference surface: an index cheat sheet mapping query patterns to index types (B-tree for equality and ranges, composite for multi-column filters, GIN for jsonb and full-text search, BRIN for time-series ranges), a data-type quick reference (bigint over int for IDs, text over varchar(255), timestamptz over timestamp, numeric over float for money), and copy-ready patterns for composite index column order (equality columns first, then range columns), covering indexes with INCLUDE, partial indexes for active rows, optimized RLS policies (wrapping auth.uid() in a SELECT), upserts with ON CONFLICT, cursor pagination (O(1) versus OFFSET), and queue processing with FOR UPDATE SKIP LOCKED. Includes anti-pattern detection queries (unindexed foreign keys, slow queries via pg_stat_statements, table bloat) and a configuration template for connection limits, timeouts, monitoring, and security defaults. Use when writing SQL or migrations, designing schemas, troubleshooting slow queries, implementing Row Level Security, or setting up connection pooling. By @affaan-m, listed here with credit to its creator. From the affaan-m/ECC repository (MIT). Honest caveats: configuration values must be tuned to your RAM and workload, they are starting points not gospel; RLS and security defaults need adapting to your tenancy model; the skill guides, you still own the schema. Skill Harbor never reviews the code, review it yourself before use.
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 4eb71d9Pinned 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.
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
- 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.