Лучшие практики Postgres от Supabase
Делает схемы, миграции и запросы Postgres по 31 правилу от Supabase, у каждого — неверный и верный SQL: индексы, пулинг, RLS, блокировки, пагинация, мониторинг. Для случаев, когда вы пишете SQL или ищете, почему Postgres тормозит.
supabase-postgres-best-practices- Автор
- Supabase
- Источник
- supabase/agent-skills/skills/supabase-postgres-best-practices @ c9be0e9
- Лицензия
- MIT · Copyright (c) 2026 Supabase
Об этом скилле
Что делает
Свод правил Postgres от Supabase — 31 короткое правило для Postgres на любом хостинге, не только на Supabase. Каждое лежит в отдельном файле в references/ и устроено одинаково: зачем это нужно, неправильный пример SQL, исправленный, а иногда ещё план EXPLAIN, измеренный выигрыш или примечание про Supabase. Агент открывает только те правила, которые относятся к задаче.
Префикс файла задаёт категорию и её приоритет. Первыми идут скорость запросов (query-) и подключения (conn-): недостающие, составные, частичные и покрывающие индексы, пулинг, лимиты подключений, таймауты простаивающих соединений, подготовленные запросы при пулинге на уровне транзакций. Дальше безопасность (security-): включение RLS, быстрые политики, где auth.uid() обёрнут в select, минимальные привилегии. Схема (schema-): типы данных, первичные ключи, индексы на внешних ключах, имена в нижнем регистре, партиционирование и добавление ограничений в миграциях — в Postgres нет ADD CONSTRAINT IF NOT EXISTS. Затем блокировки (короткие транзакции, порядок захвата, SKIP LOCKED, advisory-блокировки), доступ к данным (N+1, пакетные вставки, курсорная пагинация, upsert), мониторинг (EXPLAIN ANALYZE, pg_stat_statements, VACUUM) и два продвинутых правила — полнотекстовый поиск и индексы по JSONB.
references/_sections.md описывает восемь категорий, а _template.md и _contributing.md написаны для авторов новых правил. Скриптов нет, CLI и MCP-сервер не нужны.
Когда включать и когда не надо
Когда пишете таблицы, миграции, политики RLS или индексы, а ещё когда запрос тормозит, кончаются подключения или строки видны чужому тенанту.
Описание просит подключать скилл почти к любому изменению в Postgres и упоминает pgvector, pg_cron, pgmq, pg_restore и тесты RLS, но правил на эти темы в папке нет. Только Postgres: другие СУБД и ORM он не разбирает.
Как поставить и вызвать
Команда установки ниже скачивает всю папку.
- Claude Code:
/supabase-postgres-best-practicesили попросить скилл по имени. - Codex:
$supabase-postgres-best-practices. - Cursor: наберите
/в чате Agent и выберитеsupabase-postgres-best-practices.
Пример: /supabase-postgres-best-practices Проверь db/migrations: где не хватает индексов и какие политики RLS начнут тормозить, когда таблицы вырастут.
Чем отличается от похожих
Проекты на Supabase из того же набора — про саму платформу: CLI, MCP, Auth, Data API и ловушки, характерные для Supabase; в проекте на Supabase эти два скилла работают вместе. Ревью SQL-запросов из нашего каталога ставит неверный результат выше скорости — NULL, джойны, которые размножают строки, часовые пояса — и работает с несколькими СУБД. Безопасные миграции БД планируют изменения без простоя через expand/contract и таймауты блокировок; здесь про миграции всего одно правило.
Установка
Выполните одну команду — она сохранит SKILL.md и файлы, которые он использует, в папку скиллов агента. Claude Code и Codex подхватывают новый скилл без перезапуска; если скилл не появился, перезапустите агента.
Скилл написан на английском — агент поймёт его и ответит вам по-русски.
curl -fsSL --create-dirs -o ~/.claude/skills/supabase-postgres-best-practices/SKILL.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/SKILL.md -o ~/.claude/skills/supabase-postgres-best-practices/CHANGELOG.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/CHANGELOG.md -o ~/.claude/skills/supabase-postgres-best-practices/LICENSE https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/LICENSE -o ~/.claude/skills/supabase-postgres-best-practices/references/_contributing.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/_contributing.md -o ~/.claude/skills/supabase-postgres-best-practices/references/_sections.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/_sections.md -o ~/.claude/skills/supabase-postgres-best-practices/references/_template.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/_template.md -o ~/.claude/skills/supabase-postgres-best-practices/references/advanced-full-text-search.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/advanced-full-text-search.md -o ~/.claude/skills/supabase-postgres-best-practices/references/advanced-jsonb-indexing.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/advanced-jsonb-indexing.md -o ~/.claude/skills/supabase-postgres-best-practices/references/conn-idle-timeout.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/conn-idle-timeout.md -o ~/.claude/skills/supabase-postgres-best-practices/references/conn-limits.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/conn-limits.md -o ~/.claude/skills/supabase-postgres-best-practices/references/conn-pooling.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/conn-pooling.md -o ~/.claude/skills/supabase-postgres-best-practices/references/conn-prepared-statements.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/conn-prepared-statements.md -o ~/.claude/skills/supabase-postgres-best-practices/references/data-batch-inserts.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/data-batch-inserts.md -o ~/.claude/skills/supabase-postgres-best-practices/references/data-n-plus-one.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/data-n-plus-one.md -o ~/.claude/skills/supabase-postgres-best-practices/references/data-pagination.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/data-pagination.md -o ~/.claude/skills/supabase-postgres-best-practices/references/data-upsert.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/data-upsert.md -o ~/.claude/skills/supabase-postgres-best-practices/references/lock-advisory.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/lock-advisory.md -o ~/.claude/skills/supabase-postgres-best-practices/references/lock-deadlock-prevention.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/lock-deadlock-prevention.md -o ~/.claude/skills/supabase-postgres-best-practices/references/lock-short-transactions.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/lock-short-transactions.md -o ~/.claude/skills/supabase-postgres-best-practices/references/lock-skip-locked.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/lock-skip-locked.md -o ~/.claude/skills/supabase-postgres-best-practices/references/monitor-explain-analyze.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/monitor-explain-analyze.md -o ~/.claude/skills/supabase-postgres-best-practices/references/monitor-pg-stat-statements.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/monitor-pg-stat-statements.md -o ~/.claude/skills/supabase-postgres-best-practices/references/monitor-vacuum-analyze.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/monitor-vacuum-analyze.md -o ~/.claude/skills/supabase-postgres-best-practices/references/query-composite-indexes.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/query-composite-indexes.md -o ~/.claude/skills/supabase-postgres-best-practices/references/query-covering-indexes.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/query-covering-indexes.md -o ~/.claude/skills/supabase-postgres-best-practices/references/query-index-types.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/query-index-types.md -o ~/.claude/skills/supabase-postgres-best-practices/references/query-missing-indexes.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/query-missing-indexes.md -o ~/.claude/skills/supabase-postgres-best-practices/references/query-partial-indexes.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/query-partial-indexes.md -o ~/.claude/skills/supabase-postgres-best-practices/references/schema-constraints.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/schema-constraints.md -o ~/.claude/skills/supabase-postgres-best-practices/references/schema-data-types.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/schema-data-types.md -o ~/.claude/skills/supabase-postgres-best-practices/references/schema-foreign-key-indexes.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/schema-foreign-key-indexes.md -o ~/.claude/skills/supabase-postgres-best-practices/references/schema-lowercase-identifiers.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/schema-lowercase-identifiers.md -o ~/.claude/skills/supabase-postgres-best-practices/references/schema-partitioning.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/schema-partitioning.md -o ~/.claude/skills/supabase-postgres-best-practices/references/schema-primary-keys.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/schema-primary-keys.md -o ~/.claude/skills/supabase-postgres-best-practices/references/security-privileges.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/security-privileges.md -o ~/.claude/skills/supabase-postgres-best-practices/references/security-rls-basics.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/security-rls-basics.md -o ~/.claude/skills/supabase-postgres-best-practices/references/security-rls-performance.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/security-rls-performance.md
curl -fsSL --create-dirs -o ~/.agents/skills/supabase-postgres-best-practices/SKILL.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/SKILL.md -o ~/.agents/skills/supabase-postgres-best-practices/CHANGELOG.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/CHANGELOG.md -o ~/.agents/skills/supabase-postgres-best-practices/LICENSE https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/LICENSE -o ~/.agents/skills/supabase-postgres-best-practices/references/_contributing.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/_contributing.md -o ~/.agents/skills/supabase-postgres-best-practices/references/_sections.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/_sections.md -o ~/.agents/skills/supabase-postgres-best-practices/references/_template.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/_template.md -o ~/.agents/skills/supabase-postgres-best-practices/references/advanced-full-text-search.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/advanced-full-text-search.md -o ~/.agents/skills/supabase-postgres-best-practices/references/advanced-jsonb-indexing.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/advanced-jsonb-indexing.md -o ~/.agents/skills/supabase-postgres-best-practices/references/conn-idle-timeout.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/conn-idle-timeout.md -o ~/.agents/skills/supabase-postgres-best-practices/references/conn-limits.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/conn-limits.md -o ~/.agents/skills/supabase-postgres-best-practices/references/conn-pooling.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/conn-pooling.md -o ~/.agents/skills/supabase-postgres-best-practices/references/conn-prepared-statements.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/conn-prepared-statements.md -o ~/.agents/skills/supabase-postgres-best-practices/references/data-batch-inserts.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/data-batch-inserts.md -o ~/.agents/skills/supabase-postgres-best-practices/references/data-n-plus-one.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/data-n-plus-one.md -o ~/.agents/skills/supabase-postgres-best-practices/references/data-pagination.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/data-pagination.md -o ~/.agents/skills/supabase-postgres-best-practices/references/data-upsert.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/data-upsert.md -o ~/.agents/skills/supabase-postgres-best-practices/references/lock-advisory.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/lock-advisory.md -o ~/.agents/skills/supabase-postgres-best-practices/references/lock-deadlock-prevention.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/lock-deadlock-prevention.md -o ~/.agents/skills/supabase-postgres-best-practices/references/lock-short-transactions.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/lock-short-transactions.md -o ~/.agents/skills/supabase-postgres-best-practices/references/lock-skip-locked.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/lock-skip-locked.md -o ~/.agents/skills/supabase-postgres-best-practices/references/monitor-explain-analyze.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/monitor-explain-analyze.md -o ~/.agents/skills/supabase-postgres-best-practices/references/monitor-pg-stat-statements.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/monitor-pg-stat-statements.md -o ~/.agents/skills/supabase-postgres-best-practices/references/monitor-vacuum-analyze.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/monitor-vacuum-analyze.md -o ~/.agents/skills/supabase-postgres-best-practices/references/query-composite-indexes.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/query-composite-indexes.md -o ~/.agents/skills/supabase-postgres-best-practices/references/query-covering-indexes.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/query-covering-indexes.md -o ~/.agents/skills/supabase-postgres-best-practices/references/query-index-types.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/query-index-types.md -o ~/.agents/skills/supabase-postgres-best-practices/references/query-missing-indexes.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/query-missing-indexes.md -o ~/.agents/skills/supabase-postgres-best-practices/references/query-partial-indexes.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/query-partial-indexes.md -o ~/.agents/skills/supabase-postgres-best-practices/references/schema-constraints.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/schema-constraints.md -o ~/.agents/skills/supabase-postgres-best-practices/references/schema-data-types.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/schema-data-types.md -o ~/.agents/skills/supabase-postgres-best-practices/references/schema-foreign-key-indexes.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/schema-foreign-key-indexes.md -o ~/.agents/skills/supabase-postgres-best-practices/references/schema-lowercase-identifiers.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/schema-lowercase-identifiers.md -o ~/.agents/skills/supabase-postgres-best-practices/references/schema-partitioning.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/schema-partitioning.md -o ~/.agents/skills/supabase-postgres-best-practices/references/schema-primary-keys.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/schema-primary-keys.md -o ~/.agents/skills/supabase-postgres-best-practices/references/security-privileges.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/security-privileges.md -o ~/.agents/skills/supabase-postgres-best-practices/references/security-rls-basics.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/security-rls-basics.md -o ~/.agents/skills/supabase-postgres-best-practices/references/security-rls-performance.md https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/references/security-rls-performance.md
foreach ($f in 'SKILL.md','CHANGELOG.md','LICENSE','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') { $p = Join-Path "$HOME\.claude\skills\supabase-postgres-best-practices" $f; New-Item -ItemType Directory -Force (Split-Path $p) | Out-Null; Invoke-WebRequest "https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/$f" -UseBasicParsing -OutFile $p }foreach ($f in 'SKILL.md','CHANGELOG.md','LICENSE','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') { $p = Join-Path "$HOME\.agents\skills\supabase-postgres-best-practices" $f; New-Item -ItemType Directory -Force (Split-Path $p) | Out-Null; Invoke-WebRequest "https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/$f" -UseBasicParsing -OutFile $p }Другой агент: сохраните файл в его папку скиллов или дайте ему ссылку на файл: https://anymodel.org/en/skills/supabase/supabase-postgres-best-practices/SKILL.md
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:
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
Подключить через AnyModel API
Скилл работает на той модели, которую использует агент. Подключите Claude Code, Codex или Cursor к AnyModel и запускайте его на Claude, GPT, Gemini и других моделях по одному ключу — оплата за токены, без подписки.
AnyModel