Skip to content

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

dw-technical-design

Verified

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

FileKindSize
SKILL.mdskill md1.1 KB
---
name: dw-technical-design
description: >
  Step 2/8 数仓技术设计:OneData 建模、表名粒度/主键/分区设计、
  字段类型约束沉淀到表契约。适用于需求分析完成后进入建模阶段。
argument-hint: "[表名或主题]"
allowed-tools: Read, Grep, Glob, Write, Bash(dw contract:*)
---

# Step 2: 技术设计

## 执行流程

1. OneData 命名:`[层级]_[域]_[主题]_[粒度]_[周期]`(如 `dws_trade_order_di`)
2. 确定主键、粒度、分区(`partition_dt string yyyyMMdd`)
3. 把 Step 1 的口径草稿固化进契约并校验:

```bash
dw contract validate contracts/contract.json
dw contract compile contracts/contract.json
```

4. 金额列在契约中分开声明 `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: 322kUpdated 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: 198kUpdated 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: 198kUpdated 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: 198kUpdated Claude CodeCodexVerifiedInstall