Phase 05 · Database Design

The Schema Skill reads openapi.yaml and derives the data model. It identifies all entities referenced in request/response schemas and generates DDL for your target database.

What it produces

logos/resources/api/ containing:

• schema.sql — DDL for your chosen database (SQLite, PostgreSQL, or MySQL)
• An entity-relationship diagram shown in the RunLogos schema viewer

Visual table editor

RunLogos includes a table editor where you can:

• Add or rename columns
• Set data types and constraints (NOT NULL, UNIQUE, DEFAULT)
• Define foreign key relationships
• Export the updated DDL at any time

Changes in the visual editor sync back to schema.sql.

Choosing your database

Select your target database in Settings → Project → Database. The Schema Skill adapts its DDL syntax accordingly:

Next step

→ Phase 06 · Test Design