pugyy/dw-harness / plugins/dw-harness/skills/dw-review
dw-review
Verified上线前 SQL/契约评审清单:字段口径比对、注释三段式、生命周期、 分区策略、金额单位一致性。适用于提 PR 前自查或人肉评审辅助。
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 1.1 KB |
SKILL.md
View on GitHub---
name: dw-review
description: >
上线前 SQL/契约评审清单:字段口径比对、注释三段式、生命周期、
分区策略、金额单位一致性。适用于提 PR 前自查或人肉评审辅助。
allowed-tools: Read, Grep, Glob, Bash(dw lint:*), Bash(dw contract:*), Bash(dw check:*)
---
# dw-review:上线前评审清单
## 确定性项(先跑命令)
```bash
dw lint <变更的 sql>
dw contract validate contracts/contract.json
dw check --table <表> --mode local # 完整四态
```
## 人工评审项(逐条过)
- [ ] 字段口径与需求一致(引用契约 caliber,不引用记忆)
- [ ] 金额列币种/单位与上下游契约一致(分/元/千元没有隐式混用)
- [ ] 注释三段式:业务含义 | 数据来源 | 计算逻辑
- [ ] LIFECYCLE / 保留期符合表层级策略
- [ ] 分区策略与回填幂等性(历史分区覆盖有预演)
- [ ] 下游影响已看 `dw impact --table <表>`(未知血缘如实标注)
- [ ] 破坏性变更有迁移决定记录
## 输出
评审结论 + 未决问题清单;不替人拍板,只把证据摆齐。
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |
| agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |