LAYER_08_DATASTORE

What problem does it solve?

This Skill provides a structured approach to modeling physical database design by capturing databases, schemas, tables, columns, indexes, constraints, and triggers, bridging logical data models with concrete storage.

Core Features & Use Cases

• Define databases, schemas, and storage boundaries to organize the physical layer
• Model tables and columns with data types, nullability, defaults, constraints, and relationships
• Specify indexes, constraints, and triggers to reflect performance and integrity requirements
• Generate SQL DDL or documentation from the datastore model to support implementation and governance
• Use cases include designing relational schemas for applications, documenting storage layouts, and mapping data models to physical databases

Quick Start

Start by modeling a simple Users table with columns for id (primary key), email, and created_at, then extend the model to include indexes and a foreign key.