supabase/agent-skills / supabase-postgres-best-practices
supabase-postgres-best-practices
- Установки
- 378,656
- Автор
- supabase/agent-skills
- Источник
- github.com/supabase/agent-skills
Сборник лучших практик Postgres от Supabase для разработчиков и AI-агентов. Помогает писать эффективные запросы, проектировать схемы, настраивать индексы, RLS-политики и миграции, а также диагностировать медленные запросы и проблемы с производительностью. Правила разбиты по приоритету влияния — от критичных (производительность запросов, управление соединениями) до дополнительных (продвинутые функции).
Установить скилл
npx skills add https://github.com/supabase/agent-skills --skill supabase-postgres-best-practices
Аудит безопасности
Gen Agent Trust Hub
passThis skill provides a comprehensive set of Postgres performance optimization guidelines and best practices. It consists of static markdown documentation and SQL examples, posing no security risks to the environment.
Audited: 4/16/2026, 9:10:18 AM
Socket
passNo alerts
Audited: 4/16/2026, 9:10:43 AM
Snyk
passRisk: LOW · No issues
Audited: 4/16/2026, 9:10:08 AM
Runlayer
pass9/38 files flagged
Audited: 2/26/2026, 4:19:53 PM
ZeroLeaks
passScore: 93/100 · 2 sections analyzed
Audited: 4/16/2026, 9:10:09 AM
Промпт скилла
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:
references/query-missing-indexes.md
references/query-partial-indexes.md
references/_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)
References
Все файлы скилла
- CHANGELOG.md
- references/_contributing.md
- references/_sections.md
- references/_template.md
- references/advanced-full-text-search.md
- references/advanced-jsonb-indexing.md
- references/conn-idle-timeout.md
- references/conn-limits.md
- references/conn-pooling.md
- references/conn-prepared-statements.md
- references/data-batch-inserts.md
- references/data-n-plus-one.md
- references/data-pagination.md
- references/data-upsert.md
- references/lock-advisory.md
- references/lock-deadlock-prevention.md
- references/lock-short-transactions.md
- references/lock-skip-locked.md
- references/monitor-explain-analyze.md
- references/monitor-pg-stat-statements.md
- references/monitor-vacuum-analyze.md
- 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
- references/schema-constraints.md
- 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
- references/security-privileges.md
- references/security-rls-basics.md
- references/security-rls-performance.md
- SKILL.md