supabase-postgres-best-practices
Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.
- License 许可
- MIT
- 最近更新
- 2026-11-12
- Stars
- ★ 0
- Forks
- 0
01 前言 Front Matter
- name
- supabase-postgres-best-practices
- license
- MIT
- metadata
- { "author": "supabase", "version": "1.0.0" }
- 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 资源文件 37
- 参考文档AGENTS.md43.9 KB
- 参考文档agents/openai.yaml110 B
- 参考文档metadata.json818 B
- 参考文档README.md3.1 KB
- 参考文档rules/_contributing.md4.0 KB
- 参考文档rules/_sections.md1.6 KB
- 参考文档rules/_template.md1.0 KB
- 参考文档rules/advanced-full-text-search.md1.4 KB
- 参考文档rules/advanced-jsonb-indexing.md1.4 KB
- 参考文档rules/conn-idle-timeout.md1.3 KB
- 参考文档rules/conn-limits.md1.3 KB
- 参考文档rules/conn-pooling.md1.3 KB
- 参考文档rules/conn-prepared-statements.md1.5 KB
- 参考文档rules/data-batch-inserts.md1.3 KB
- 参考文档rules/data-n-plus-one.md1.3 KB
- 参考文档rules/data-pagination.md1.3 KB
- 参考文档rules/data-upsert.md1.4 KB
- 参考文档rules/lock-advisory.md1.5 KB
- 参考文档rules/lock-deadlock-prevention.md1.8 KB
- 参考文档rules/lock-short-transactions.md1.3 KB
- 参考文档rules/lock-skip-locked.md1.3 KB
- 参考文档rules/monitor-explain-analyze.md1.4 KB
- 参考文档rules/monitor-pg-stat-statements.md1.4 KB
- 参考文档rules/monitor-vacuum-analyze.md1.5 KB
- 参考文档rules/query-composite-indexes.md1.4 KB
- 参考文档rules/query-covering-indexes.md1.3 KB
- 参考文档rules/query-index-types.md1.4 KB
- 参考文档rules/query-missing-indexes.md1.2 KB
- 参考文档rules/query-partial-indexes.md1.3 KB
- 参考文档rules/schema-data-types.md1.4 KB
- 参考文档rules/schema-foreign-key-indexes.md1.6 KB
- 参考文档rules/schema-lowercase-identifiers.md1.7 KB
- 参考文档rules/schema-partitioning.md1.5 KB
- 参考文档rules/schema-primary-keys.md1.8 KB
- 参考文档rules/security-privileges.md1.5 KB
- 参考文档rules/security-rls-basics.md1.3 KB
- 参考文档rules/security-rls-performance.md1.5 KB
03 SKILL.md 正文
Supabase Postgres Best Practices
Comprehensive performance optimization guide for Postgres, maintained by Supabase. Contains rules across 8 categories, prioritized by impact to guide automated query optimization and schema design.
When to Apply
Reference these guidelines when:
- Writing SQL queries or designing schemas
- Implementing indexes or query optimization
- Reviewing database performance issues
- Configuring connection pooling or scaling
- Optimizing for Postgres-specific features
- Working with Row-Level Security (RLS)
Rule Categories by Priority
| 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- |
How to Use
Read individual rule files for detailed explanations and SQL examples:
rules/query-missing-indexes.md
rules/schema-partial-indexes.md
rules/_sections.md
Each rule file contains:
- Brief explanation of why it matters
- Incorrect SQL example with explanation
- Correct SQL example with explanation
- Optional EXPLAIN output or metrics
- Additional context and references
- Supabase-specific notes (when applicable)
Full Compiled Document
For the complete guide with all rules expanded: AGENTS.md
04 同仓库更多 Skills
webapp-testing
Toolkit for interacting with and testing local web applications using Playwright. Supports verifying frontend functionality, debugging UI behavior, capturing browser screenshots, and viewing browser logs.
web-artifacts-builder
Suite of tools for creating elaborate, multi-component claude.ai HTML artifacts using modern frontend web technologies (React, Tailwind CSS, shadcn/ui). Use for complex artifacts requiring state management, routing, or shadcn/ui components - not for simple single-file HTML/JSX artifacts.
theme-factory
Toolkit for styling artifacts with a theme. These artifacts can be slides, docs, reportings, HTML landing pages, etc. There are 10 pre-set themes with colors/fonts that you can apply to any artifact that has been creating, or can generate a new theme on-the-fly.
slack-gif-creator
Knowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack."
skill-creator
Guide for creating effective skills. This skill should be used when users want to create a new skill (or update an existing skill) that extends Claude's capabilities with specialized knowledge, workflows, or tool integrations.
mcp-builder
Guide for creating high-quality MCP (Model Context Protocol) servers that enable LLMs to interact with external services through well-designed tools. Use when building MCP servers to integrate external APIs or services, whether in Python (FastMCP) or Node/TypeScript (MCP SDK).