Create Data Model

Overview

Design a production-ready data model from feature requirements, including entity definitions, relationships, a Mermaid ERD, index recommendations, and migration safety analysis. The output encodes senior-level database design practices: timestamps on every table, soft deletes, audit trails, and safe migration strategies.

Workflow

1. Read project context -- Read .chalk/docs/engineering/ for:
   • Existing data model documents to understand current schema and naming conventions
   • Architecture docs for database technology (PostgreSQL, MySQL, MongoDB, etc.)
   • ADRs or RFCs related to data storage decisions
   • If no docs exist, scan the codebase for migration files, model definitions, or schema files to infer conventions