AgentSkillsCN

Supabase Postgres Best Practices

Supabase Postgres 最佳实践

SKILL.md

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

code
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

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

Reference Categories

PriorityCategoryImpactPrefix
1Query PerformanceCRITICALquery-
2Connection ManagementCRITICALconn-
3Security & RLSCRITICALsecurity-
4Schema DesignHIGHschema-
5Concurrency & LockingMEDIUM-HIGHlock-
6Data Access PatternsMEDIUMdata-
7Monitoring & DiagnosticsLOW-MEDIUMmonitor-
8Advanced FeaturesLOWadvanced-

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

Available References

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

Connection Management (conn-):

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

Security & RLS (security-):

  • •references/security-privileges.md
  • •references/security-rls-basics.md
  • •references/security-rls-performance.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

Concurrency & Locking (lock-):

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

Data Access Patterns (data-):

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

Monitoring & Diagnostics (monitor-):

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

Advanced Features (advanced-):

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

30 reference files across 8 categories