postgresql-expert-best-practices-code-review by wispbit-ai/skills
npx skills add https://github.com/wispbit-ai/skills --skill postgresql-expert-best-practices-code-review简洁、实用、观点鲜明。仅包含编写生产级 PostgreSQL 查询所需的关键要点。
在以下情况时参考本指南:
| 优先级 | 类别 | 影响 | 前缀 |
|---|---|---|---|
| 1 | 索引管理 | 关键-高 | only-concurrent-indexes, add-index-for-foreign-key |
| 2 | 约束安全 | 高 | unique-constraint, , |
广告位招租
在这里展示您的产品或服务
触达数万 AI 开发者,精准高效
split-foreign-keyset-column-not-null| 3 | 模式设计 | 中 | only-jsonb, always-include-columns, limit-non-unique-index |
| 4 | 命名规范 | 低 | index-naming-standards, column-naming-standards |
only-concurrent-indexes - 始终使用 CONCURRENTLY 创建索引,防止在索引创建期间阻塞写入操作add-index-for-foreign-key - 为外键创建索引以提高查询性能unique-constraint - 将唯一约束创建拆分为并发索引 + 约束两个步骤split-foreign-key - 先添加外键但不验证,然后单独进行验证set-column-not-null - 在设置 NOT NULL 前使用检查约束,避免表锁定only-jsonb - 使用 JSONB 替代 JSON,以获得更好的性能和索引能力always-include-columns - 在所有表中包含 id、created_at 和 updated_at 字段,便于审计limit-non-unique-index - 将非唯一索引限制为最多三列以提高效率index-naming-standards - 使用一致的索引命名:idx_表名_列名column-naming-standards - 保持一致的蛇形命名法,外键使用 id 后缀阅读各个规则文件以获取详细解释和代码示例:
rules/only-concurrent-indexes.md
rules/add-index-for-foreign-key.md
rules/unique-constraint.md
rules/split-foreign-key.md
rules/set-column-not-null.md
rules/only-jsonb.md
rules/always-include-columns.md
rules/limit-non-unique-index.md
rules/index-naming-standards.md
rules/column-naming-standards.md
每个规则文件包含:
每周安装量
219
代码仓库
GitHub 星标数
5
首次出现
2026年2月10日
安全审计
安装于
cursor203
opencode113
codex107
github-copilot106
gemini-cli102
claude-code87
Simple, pragmatic, opinionated. Only what matters for writing production-grade PostgreSQL queries.
Reference these guidelines when:
| Priority | Category | Impact | Prefix |
|---|---|---|---|
| 1 | Index Management | CRITICAL-HIGH | only-concurrent-indexes, add-index-for-foreign-key |
| 2 | Constraint Safety | HIGH | unique-constraint, split-foreign-key, set-column-not-null |
| 3 | Schema Design | MEDIUM | only-jsonb, always-include-columns, limit-non-unique-index |
| 4 | Naming Standards | LOW | index-naming-standards, column-naming-standards |
only-concurrent-indexes - Always use CONCURRENTLY to prevent blocking writes during index creationadd-index-for-foreign-key - Create indexes for foreign keys to improve query performanceunique-constraint - Split unique constraint creation into concurrent index + constraint stepssplit-foreign-key - Add foreign keys without validation first, then validate separatelyset-column-not-null - Use check constraints before setting NOT NULL to avoid table locksonly-jsonb - Use JSONB instead of JSON for better performance and indexing capabilitiesalways-include-columns - Include id, created_at, and updated_at in all tables for auditabilitylimit-non-unique-index - Limit non-unique indexes to maximum three columns for efficiencyRead individual rule files for detailed explanations and code examples:
rules/only-concurrent-indexes.md
rules/add-index-for-foreign-key.md
rules/unique-constraint.md
rules/split-foreign-key.md
rules/set-column-not-null.md
rules/only-jsonb.md
rules/always-include-columns.md
rules/limit-non-unique-index.md
rules/index-naming-standards.md
rules/column-naming-standards.md
Each rule file contains:
Weekly Installs
219
Repository
GitHub Stars
5
First Seen
Feb 10, 2026
Security Audits
Gen Agent Trust HubPassSocketPassSnykPass
Installed on
cursor203
opencode113
codex107
github-copilot106
gemini-cli102
claude-code87
GSAP React 动画库使用指南:useGSAP Hook 与最佳实践
2,400 周安装
index-naming-standards - Use consistent index naming: idx_tablename_columnnamecolumn-naming-standards - Maintain consistent snake_case naming and use id suffix for foreign keys