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
- Use "PostgreSQL Patterns" with your Muse.
- 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:
Install
Copy the install package below, then paste it into MuseThe install prompt below already includes the vetting steps: your agent follows the community checklist before installing anything with executable code. Want more?
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://github.com/affaan-m/ECC/blob/main/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.
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.