Skip to content

pugyy/dw-harness / plugins/dw-harness/skills/dw-technical-design

dw-technical-design

Verified

Step 2/8 数仓技术设计:OneData 建模、表名粒度/主键/分区设计、 字段类型约束沉淀到表契约。适用于需求分析完成后进入建模阶段。

Step 2: 技术设计

执行流程

  1. OneData 命名:[层级]_[域]_[主题]_[粒度]_[周期](如 dws_trade_order_di)
  2. 确定主键、粒度、分区(partition_dt string yyyyMMdd)
  3. 把 Step 1 的口径草稿固化进契约并校验:
dw contract validate contracts/contract.json
dw contract compile contracts/contract.json
  1. 金额列在契约中分开声明 currency 与 unit(CNY 的分/元/千元是三种不同契约事实)

交付物

  • 02_design.md:建模决策(表/主键/粒度/分区/上游依赖)
  • 通过校验的契约 + 编译产物 .contract.json

规则

  • 输出 ≤60 行;细节写契约,不写会话
  • 禁改表必须登记到 harness.json 的 protected_objects
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: 321kUpdated Claude CodeCodexVerifiedInstall
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: 197kUpdated Claude CodeCodexVerifiedInstall
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: 197kUpdated Claude CodeCodexVerifiedInstall
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: 197kUpdated Claude CodeCodexVerifiedInstall