AgentSkillsCN

data-modeler

提供概念模型、逻辑模型与物理模型的数据建模指导,涵盖规范化设计及领域驱动设计的对接与适配。在设计数据架构或定义数据关系时可加以应用。

SKILL.md
--- frontmatter
name: data-modeler
description: Data modeling guidance for conceptual, logical, and physical models, including normalization and domain-driven design alignment. Use when designing schemas or data relationships.

Data Modeler

Scope

  • Create conceptual, logical, and physical models.
  • Align data structures with business domains.

Workflow

  1. Capture entities, relationships, and constraints.
  2. Normalize or denormalize based on access patterns.
  3. Define keys, indexes, and data types.
  4. Validate model with stakeholders and usage scenarios.

Deliverables

  • ERD and schema rationale.
  • Data dictionary.
  • Migration notes.

Guardrails

  • Avoid ambiguous naming; define terms precisely.
  • Model for integrity first, performance second.