How do I install the Reference Categories skill?

Run npx skillmds@latest add tools-only/reference-categories-3 in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

Is Reference Categories safe to use?

This skill has not completed SkillMD's automated safety review yet. Independent scanners report: SkillSpector: CAUTION, Skill Scanner: PASS. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Reference Categories?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Reference Categories free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

Who published Reference Categories?

tools-only (@tools-only) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Reference Categories by tools-only — Agent Skill

Name: Reference Categories
Author: tools-only

File contents

supabase-postgres-best-practices

Note: CLAUDE.md is a symlink to this file.

Overview

Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.

Structure

supabase-postgres-best-practices/
  SKILL.md       # Main skill file - read this first
  AGENTS.md      # This navigation guide
  CLAUDE.md      # Symlink to AGENTS.md
  references/    # Detailed reference files

Usage

Read SKILL.md for the main skill instructions
Browse references/ for detailed documentation on specific topics
Reference files are loaded on-demand - read only what you need

Reference Categories

Priority	Category	Impact	Prefix
1	Query Performance	CRITICAL	`query-`
2	Connection Management	CRITICAL	`conn-`
3	Security & RLS	CRITICAL	`security-`
4	Schema Design	HIGH	`schema-`
5	Concurrency & Locking	MEDIUM-HIGH	`lock-`
6	Data Access Patterns	MEDIUM	`data-`
7	Monitoring & Diagnostics	LOW-MEDIUM	`monitor-`
8	Advanced Features	LOW	`advanced-`

Reference files are named {prefix}-{topic}.md (e.g., query-missing-indexes.md).

Available References

Advanced Features (advanced-):

references/advanced-full-text-search.md
references/advanced-jsonb-indexing.md

Connection Management (conn-):

references/conn-idle-timeout.md
references/conn-limits.md
references/conn-pooling.md
references/conn-prepared-statements.md

Data Access Patterns (data-):

references/data-batch-inserts.md
references/data-n-plus-one.md
references/data-pagination.md
references/data-upsert.md

Concurrency & Locking (lock-):

references/lock-advisory.md
references/lock-deadlock-prevention.md
references/lock-short-transactions.md
references/lock-skip-locked.md

Monitoring & Diagnostics (monitor-):

references/monitor-explain-analyze.md
references/monitor-pg-stat-statements.md
references/monitor-vacuum-analyze.md

Query Performance (query-):

references/query-composite-indexes.md
references/query-covering-indexes.md
references/query-index-types.md
references/query-missing-indexes.md
references/query-partial-indexes.md

Schema Design (schema-):

references/schema-data-types.md
references/schema-foreign-key-indexes.md
references/schema-lowercase-identifiers.md
references/schema-partitioning.md
references/schema-primary-keys.md

Security & RLS (security-):

references/security-privileges.md
references/security-rls-basics.md
references/security-rls-performance.md

30 reference files across 8 categories

---name: reference-categories-3description: Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.---# supabase-postgres-best-practices> **Note:** `CLAUDE.md` is a symlink to this file.## OverviewPostgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.## Structure```supabase-postgres-best-practices/ SKILL.md # Main skill file - read this first AGENTS.md # This navigation guide CLAUDE.md # Symlink to AGENTS.md references/ # Detailed reference files```## Usage1. Read `SKILL.md` for the main skill instructions2. Browse `references/` for detailed documentation on specific topics3. Reference files are loaded on-demand - read only what you need## Reference Categories| Priority | Category | Impact | Prefix ||----------|----------|--------|--------|| 1 | Query Performance | CRITICAL | `query-` || 2 | Connection Management | CRITICAL | `conn-` || 3 | Security & RLS | CRITICAL | `security-` || 4 | Schema Design | HIGH | `schema-` || 5 | Concurrency & Locking | MEDIUM-HIGH | `lock-` || 6 | Data Access Patterns | MEDIUM | `data-` || 7 | Monitoring & Diagnostics | LOW-MEDIUM | `monitor-` || 8 | Advanced Features | LOW | `advanced-` |Reference files are named `{prefix}-{topic}.md` (e.g., `query-missing-indexes.md`).## Available References**Advanced Features** (`advanced-`):- `references/advanced-full-text-search.md`- `references/advanced-jsonb-indexing.md`**Connection Management** (`conn-`):- `references/conn-idle-timeout.md`- `references/conn-limits.md`- `references/conn-pooling.md`- `references/conn-prepared-statements.md`**Data Access Patterns** (`data-`):- `references/data-batch-inserts.md`- `references/data-n-plus-one.md`- `references/data-pagination.md`- `references/data-upsert.md`**Concurrency & Locking** (`lock-`):- `references/lock-advisory.md`- `references/lock-deadlock-prevention.md`- `references/lock-short-transactions.md`- `references/lock-skip-locked.md`**Monitoring & Diagnostics** (`monitor-`):- `references/monitor-explain-analyze.md`- `references/monitor-pg-stat-statements.md`- `references/monitor-vacuum-analyze.md`**Query Performance** (`query-`):- `references/query-composite-indexes.md`- `references/query-covering-indexes.md`- `references/query-index-types.md`- `references/query-missing-indexes.md`- `references/query-partial-indexes.md`**Schema Design** (`schema-`):- `references/schema-data-types.md`- `references/schema-foreign-key-indexes.md`- `references/schema-lowercase-identifiers.md`- `references/schema-partitioning.md`- `references/schema-primary-keys.md`**Security & RLS** (`security-`):- `references/security-privileges.md`- `references/security-rls-basics.md`- `references/security-rls-performance.md`---*30 reference files across 8 categories*

Frequently asked questions

Reference Categories

File contents

supabase-postgres-best-practices

Overview

Structure

Usage

Reference Categories

Available References

Related skills

Frequently asked questions

How do I install the Reference Categories skill?

What does the Reference Categories skill do?

Is Reference Categories safe to use?

Which AI agents work with Reference Categories?

Is Reference Categories free to use?

Who published Reference Categories?