sqlalchemy-alembic-expert-best-practices-code-review by wispbit-ai/skills
npx skills add https://github.com/wispbit-ai/skills --skill sqlalchemy-alembic-expert-best-practices-code-review简洁、实用、观点鲜明。只关注编写生产级 SQLAlchemy 和 Alembic 代码所需的核心要点。
在以下情况时参考本指南:
| 优先级 | 类别 | 影响 | 前缀 |
|---|---|---|---|
| 1 | 索引管理 | 关键-高 | only-concurrent-indexes, verify-query-patterns-are-indexed |
| 2 | 约束安全 | 高 | unique-constraint, , |
广告位招租
在这里展示您的产品或服务
触达数万 AI 开发者,精准高效
split-foreign-keychange-column-type| 3 | 优化 | 中 | split-check-constraint, limit-non-unique-index |
| 4 | 索引效率 | 低 | ensure-index-not-covered |
only-concurrent-indexes - 索引操作始终使用 postgresql_concurrently=True 并配合自动提交块verify-query-patterns-are-indexed - 确保 SQLAlchemy 查询已定义适当的索引unique-constraint - 将唯一约束创建拆分为并发索引 + 约束两个步骤split-foreign-key - 先使用 NOT VALID 添加外键,然后单独验证change-column-type - 使用多步骤方法进行列类型更改以避免表锁定split-check-constraint - 先使用 NOT VALID 添加检查约束,然后单独验证limit-non-unique-index - 将非唯一索引限制在最多三列以提高效率ensure-index-not-covered - 防止被复合索引已覆盖的冗余索引阅读各个规则文件以获取详细解释和代码示例:
rules/only-concurrent-indexes.md
rules/verify-query-patterns-are-indexed.md
rules/unique-constraint.md
rules/split-foreign-key.md
rules/change-column-type.md
rules/split-check-constraint.md
rules/limit-non-unique-index.md
rules/ensure-index-not-covered.md
每个规则文件包含:
每周安装数
272
代码仓库
GitHub 星标数
6
首次出现
2026年2月10日
安全审计
安装于
cursor235
opencode208
gemini-cli199
codex199
github-copilot198
kimi-cli179
Simple, pragmatic, opinionated. Only what matters for writing production-grade SQLAlchemy and Alembic code.
Reference these guidelines when:
| Priority | Category | Impact | Prefix |
|---|---|---|---|
| 1 | Index Management | CRITICAL-HIGH | only-concurrent-indexes, verify-query-patterns-are-indexed |
| 2 | Constraint Safety | HIGH | unique-constraint, split-foreign-key, change-column-type |
| 3 | Optimization | MEDIUM | split-check-constraint, limit-non-unique-index |
| 4 | Index Efficiency | LOW | ensure-index-not-covered |
only-concurrent-indexes - Always use postgresql_concurrently=True with autocommit blocks for index operationsverify-query-patterns-are-indexed - Ensure SQLAlchemy queries have appropriate indexes definedunique-constraint - Split unique constraint creation into concurrent index + constraint stepssplit-foreign-key - Add foreign keys with NOT VALID first, then validate separatelychange-column-type - Use multi-step approach for column type changes to avoid table lockssplit-check-constraint - Add check constraints with NOT VALID first, then validate separatelyRead individual rule files for detailed explanations and code examples:
rules/only-concurrent-indexes.md
rules/verify-query-patterns-are-indexed.md
rules/unique-constraint.md
rules/split-foreign-key.md
rules/change-column-type.md
rules/split-check-constraint.md
rules/limit-non-unique-index.md
rules/ensure-index-not-covered.md
Each rule file contains:
Weekly Installs
272
Repository
GitHub Stars
6
First Seen
Feb 10, 2026
Security Audits
Gen Agent Trust HubPassSocketPassSnykPass
Installed on
cursor235
opencode208
gemini-cli199
codex199
github-copilot198
kimi-cli179
Android 整洁架构指南:模块化设计、依赖注入与数据层实现
902 周安装
长上下文Transformer技术指南:RoPE、ALiBi、YaRN实现与扩展模型上下文窗口
268 周安装
Flutter开发指南:构建高性能跨平台移动应用,掌握Dart与组件化开发
268 周安装
产品指标追踪指南:定义北极星指标、L1健康指标与OKR目标设定框架
268 周安装
价值实现框架:产品价值发现与用户采用分析指南 | 产品管理方法论
268 周安装
Sentry Skills技能创建工具 - 兼容skill-creator,使用skill-writer标准工作流
268 周安装
Salesforce 数据操作专家指南:sf-data 技能详解与最佳实践
268 周安装
limit-non-unique-index - Limit non-unique indexes to maximum three columns for efficiencyensure-index-not-covered - Prevent redundant indexes that are already covered by composite indexes