pugyy/dw-harness / plugins/dw-harness/skills/dw-technical-design
dw-technical-design
VerifiedStep 2/8 数仓技术设计:OneData 建模、表名粒度/主键/分区设计、 字段类型约束沉淀到表契约。适用于需求分析完成后进入建模阶段。
Step 2: 技术设计
执行流程
- OneData 命名:
[层级]_[域]_[主题]_[粒度]_[周期](如dws_trade_order_di) - 确定主键、粒度、分区(
partition_dt string yyyyMMdd) - 把 Step 1 的口径草稿固化进契约并校验:
dw contract validate contracts/contract.json
dw contract compile contracts/contract.json
- 金额列在契约中分开声明
currency与unit(CNY 的分/元/千元是三种不同契约事实)
交付物
02_design.md:建模决策(表/主键/粒度/分区/上游依赖)- 通过校验的契约 + 编译产物
.contract.json
规则
- 输出 ≤60 行;细节写契约,不写会话
- 禁改表必须登记到
harness.json的protected_objects
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| brainstormingobra/superpowersYou MUST use this before any creative work - creating features, building components, adding functionality, modifying behavior, or planning anything new, in software or out of it (a talk, a business, a renovation). | Stars: 321k | Updated | Claude CodeCodex | Verified | Install |
| brand-guidelinesanthropics/skillsApplies Anthropic's official brand colors and typography to any sort of artifact that may benefit from having Anthropic's look-and-feel. Use it when brand colors or style guidelines, visual formatting, or company design standards apply. | Stars: 197k | Updated | Claude CodeCodex | Verified | Install |
| frontend-designanthropics/skillsGuidance for distinctive, intentional visual design when building new UI or reshaping an existing one. Helps with aesthetic direction, typography, and making choices that don't read as templated defaults. | Stars: 197k | Updated | Claude CodeCodex | Verified | Install |
| mcp-builderanthropics/skillsGuide for creating high-quality MCP (Model Context Protocol) servers that enable LLMs to interact with external services through well-designed tools. Use when building MCP servers to integrate external APIs or services, whether in Python (FastMCP) or Node/TypeScript (MCP SDK). | Stars: 197k | Updated | Claude CodeCodex | Verified | Install |