supabase-postgres-best-practices

01 前言 Front Matter

name

supabase-postgres-best-practices

risk

safe

license

MIT

metadata

{ "date": "January 2026", "author": "supabase", "version": "1.1.0", "abstract": "Comprehensive Postgres performance optimization guide for developers using Supabase and Postgres. Contains performance rules across 8 categories, prioritized by impact from critical (query performance, connection management) to incremental (advanced features). Each rule includes detailed explanations, incorrect vs. correct SQL examples, query plan analysis, and specific performance metrics to guide automated optimization and code generation.", "organization": "Supabase" }

description

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

02 资源文件 44

• 参考文档_AIWF_IMPORT.json346 B
• 参考文档.skillshare-meta.json4.6 KB
• 参考文档AGENTS.md2.1 KB
• 资产文件assets/okr_template.md3.7 KB
• 参考文档CLAUDE.md2.1 KB
• 参考文档README.md3.1 KB
• 参考文档references/_contributing.md4.1 KB
• 参考文档references/_sections.md1.6 KB
• 参考文档references/_template.md1.0 KB
• 参考文档references/advanced-full-text-search.md1.4 KB
• 参考文档references/advanced-jsonb-indexing.md1.4 KB
• 参考文档references/conn-idle-timeout.md1.3 KB
• 参考文档references/conn-limits.md1.3 KB
• 参考文档references/conn-pooling.md1.3 KB
• 参考文档references/conn-prepared-statements.md1.5 KB
• 参考文档references/data-batch-inserts.md1.3 KB
• 参考文档references/data-n-plus-one.md1.3 KB
• 参考文档references/data-pagination.md1.3 KB
• 参考文档references/data-upsert.md1.4 KB
• 参考文档references/examples/sample_growth_okrs.json10.0 KB
• 参考文档references/lock-advisory.md1.5 KB
• 参考文档references/lock-deadlock-prevention.md1.8 KB
• 参考文档references/lock-short-transactions.md1.3 KB
• 参考文档references/lock-skip-locked.md1.3 KB
• 参考文档references/monitor-explain-analyze.md1.4 KB
• 参考文档references/monitor-pg-stat-statements.md1.4 KB
• 参考文档references/monitor-vacuum-analyze.md1.5 KB
• 参考文档references/okr_framework.md10.0 KB
• 参考文档references/query-composite-indexes.md1.4 KB
• 参考文档references/query-covering-indexes.md1.3 KB
• 参考文档references/query-index-types.md1.5 KB
• 参考文档references/query-missing-indexes.md1.2 KB
• 参考文档references/query-partial-indexes.md1.3 KB
• 参考文档references/schema-constraints.md1.8 KB
• 参考文档references/schema-data-types.md1.4 KB
• 参考文档references/schema-foreign-key-indexes.md1.6 KB
• 参考文档references/schema-lowercase-identifiers.md1.7 KB
• 参考文档references/schema-partitioning.md1.5 KB
• 参考文档references/schema-primary-keys.md1.8 KB
• 参考文档references/security-privileges.md1.5 KB
• 参考文档references/security-rls-basics.md1.3 KB
• 参考文档references/security-rls-performance.md1.5 KB
• 参考文档references/strategy_types.md11.6 KB
• 脚本scripts/okr_cascade_generator.py22.2 KB

03 SKILL.md 正文

references/query-missing-indexes.md
references/schema-partial-indexes.md
references/_sections.md