Design data models for construction projects. Create entity-relationship diagrams, define schemas, and generate database structures.
SkillScore91Maintained
Automatic
◆Data Engineer pack
Last verified 8/23/2026
What it changes
Passed 21 of 23 test cases with the skill, and 12 of 23 without it.
Without skill52%
With skill91%
Checks it passed that the model alone missed
Uses DataType.TEXT for long narrative descriptions
Returns the issue string Missing entity: location_zones
Maps DataType.JSON fields to JSONB when dialect is postgresql
and 9 more in the full report
9 fixed12 passed either way2 still failing0 broke
Pass-rate lift
+39 pp
Tokens
+77%
Agent turns
0%
Response time
-34%
Model gemini-3.6-flashMeasured 8/23/2026v121 of 23 cases passed with skill
Tokens, turns and time describe resource use, not a dollar price.
See it in action
One of 9 test cases the skill fixed. Same model, same prompt, with and without the skill.
1 of 9
Prompt
When linking child table 'submittals' to parent table 'projects' using the standard 1:N relationship helper method without specifying a custom foreign key field name, what default field name is assigned to the foreign key column on the child table?
What was checked, without and with the skill
Checked
Without skill
With skill
Assigns projects_id as the default foreign key column name on the child entity
Missed
Passed
case-09 · gemini-3.6-flash · 8/23/2026 · answers are capped and redacted
What's inside
The instructions your model reads when the skill loads.
SKILL.md335 linessingle file
Data Model Designer
Business Case
Problem Statement
Construction data management challenges:
Fragmented data across systems
Inconsistent data structures
Missing relationships between entities
Difficult data integration
Solution
Systematic data model design for construction projects, defining entities, relationships, and schemas for effective data management.
Technical Implementation
from typing import Dict, Any, List, Optional
from dataclasses import dataclass, field
from enum import Enum
import json
class DataType(Enum):
STRING = "string"
INTEGER = "integer"
FLOAT = "float"
BOOLEAN = "boolean"
DATE = "date"
DATETIME = "datetime"
TEXT = "text"
JSON = "json"
class RelationType(Enum):
ONE_TO_ONE = "1:1"
ONE_TO_MANY = "1:N"
MANY_TO_MANY = "N:M"