Supabase Postgres Best Practices
davila7/claude-code-templates/cli-tool/components/skills/database/supabase-postgres-best-practices作者 davila78da17d671b6fMIT32K 个星标收录于 2026年10月8日更新于 2026年10月8日仓库今天更新
Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.
仅公开文件列表。将技能安装到工作区后即可查看文件内容。
| 路径 | 大小 | 类型 |
|---|---|---|
| AGENTS.md | 43.9 KB | text/markdown |
| metadata.json | 818 B | application/json |
| README.md | 3 KB | text/markdown |
| rules/advanced-full-text-search.md | 1.4 KB | text/markdown |
| rules/advanced-jsonb-indexing.md | 1.4 KB | text/markdown |
| rules/conn-idle-timeout.md | 1.3 KB | text/markdown |
| rules/conn-limits.md | 1.3 KB | text/markdown |
| rules/conn-pooling.md | 1.3 KB | text/markdown |
| rules/conn-prepared-statements.md | 1.5 KB | text/markdown |
| rules/_contributing.md | 4 KB | text/markdown |
| rules/data-batch-inserts.md | 1.3 KB | text/markdown |
| rules/data-n-plus-one.md | 1.3 KB | text/markdown |
| rules/data-pagination.md | 1.3 KB | text/markdown |
| rules/data-upsert.md | 1.4 KB | text/markdown |
| rules/lock-advisory.md | 1.5 KB | text/markdown |
| rules/lock-deadlock-prevention.md | 1.8 KB | text/markdown |
| rules/lock-short-transactions.md | 1.3 KB | text/markdown |
| rules/lock-skip-locked.md | 1.3 KB | text/markdown |
| rules/monitor-explain-analyze.md | 1.4 KB | text/markdown |
| rules/monitor-pg-stat-statements.md | 1.4 KB | text/markdown |
| rules/monitor-vacuum-analyze.md | 1.5 KB | text/markdown |
| rules/query-composite-indexes.md | 1.4 KB | text/markdown |
| rules/query-covering-indexes.md | 1.3 KB | text/markdown |
| rules/query-index-types.md | 1.4 KB | text/markdown |
| rules/query-missing-indexes.md | 1.2 KB | text/markdown |
| rules/query-partial-indexes.md | 1.3 KB | text/markdown |
| rules/schema-data-types.md | 1.4 KB | text/markdown |
| rules/schema-foreign-key-indexes.md | 1.6 KB | text/markdown |
| rules/schema-lowercase-identifiers.md | 1.7 KB | text/markdown |
| rules/schema-partitioning.md | 1.5 KB | text/markdown |
| rules/schema-primary-keys.md | 1.8 KB | text/markdown |
| rules/_sections.md | 1.6 KB | text/markdown |
| rules/security-privileges.md | 1.5 KB | text/markdown |
| rules/security-rls-basics.md | 1.3 KB | text/markdown |
| rules/security-rls-performance.md | 1.5 KB | text/markdown |
| rules/_template.md | 1 KB | text/markdown |
| SKILL.md | 1.8 KB | text/markdown |
来源与署名
来源：davila7/claude-code-templates位于cli-tool/components/skills/database/supabase-postgres-best-practices提交8da17d6
许可证： MIT
内容归原作者所有。SourceWeft 从公开仓库中收录这些内容。
更多来自 davila7/claude-code-templates 的技能
Brainstorming
davila7
引导协作式头脑风暴，在实现前把想法转化为经过验证的设计与规格。
Planning With Files
davila7
引导智能体使用持久化 Markdown 文件进行规划、进度跟踪和存储研究发现。
Canvas Design
davila7
依据写好的设计理念创作原创视觉艺术，输出 PNG 或 PDF，适用于海报、艺术作品等静态成品。
Frontend Design
davila7
在构建或改造用户界面时，提供打造独特、有意图的视觉设计的指导。
Content Research Writer
davila7
作为写作伙伴，协助研究、拟大纲、起草、添加引用并打磨文章等内容。
React Best Practices
davila7
面向 React 与 Next.js 的性能指南，包含 40 多条关于瀑布请求、打包体积、渲染与重渲染的规则。
更多Software Development技能
Playground
anthropics
构建自包含的交互式 HTML 演练场，包含控件、实时预览和可复制的提示词输出。
M5 Onboard
anthropics
通过 USB 检测 M5Stack ESP32 开发板，刷写 UIFlow 2.0 固件并安装 MicroPython 应用包。
Cardputer Buddy
anthropics
指导迭代 Cardputer-Adv 的 MicroPython 应用包：添加应用、通过 USB 串口推送文件、查看日志并运行 REPL 命令。
Web Design Guidelines
vercel-labs
依据从远程来源获取的 Web Interface Guidelines 审查 UI 代码，并以 file:line 形式报告问题。
Vercel React Native Skills
vercel-labs
React Native 与 Expo 最佳实践规则，涵盖列表性能、动画、导航、UI 模式、状态与 monorepo 配置。
Vercel React Best Practices
vercel-labs
Vercel 的 React 与 Next.js 性能指南，以 70 条规则的形式用于编写、审查和重构代码。