Day 4 Data Structure Codex AI Architect

Codex Client Workspace Data Design Tasks

A hands-on AI teamwork Task board that uses Codex to automatically analyze and fix the data structure misunderstandings, scattered terms and change ripple problems startups face during MVP development.

Day 4 Startup MVP Tasks

From aligning data structures to standardizing terms and sharing change impact โ€” experience the key workflow of using Codex as a data design partner.

TASK 1
Task 1

Task 1. API Contract Generation Lab

Task 01: Auto-Generate an API Contract from Planning Requirements and Screen Design

Derive key entities and relationships (Mermaid ERD) from planning meeting notes written in natural language, and use AI to close the gap in how planners and developers understand the data model.

TargetRESTful API contract spec
Key toolCodex Client Workspace
Lab scopeData Structure Alignment
Step 1 ๐Ÿ“‚ Prepare the meeting notes file (day4_meeting_notes.md) and upload to Codex
Step 2 ๐Ÿ” Ask Codex to list APIs and define Req/Res variable names
ERD Req/Res Design RESTful
Expected output erd-schema.md (data spec and ERD)
Enter Task 1 lab
TASK 2
Task 2

Task 2. API Mismatch Detection Lab

Task 02: Compare Planning Docs and API Specs to Find Mismatches

Cross-check the requirements doc, screen spec and API spec draft to find API endpoints and fields that don't match or are missing from the planning requirements or screen UI design, and write a review report.

TargetAPI consistency review report
Key toolCodex Client Workspace
Lab scopeSpec Auditing Standardization
Step 1 ๐Ÿ“ Prepare 2 planning docs and the API spec draft
Step 2 ๐Ÿ“‹ Ask Codex to check consistency for mismatches and missing features between docs
Consistency Check Spec Auditing Validation
Expected output project-glossary.md (standard term dictionary)
Enter Task 2 lab
TASK 3
Task 3

Task 3. API Change Impact Analysis Lab

Task 03: Analyze Features, Docs and Interfaces Affected by API Changes

When API parameters or states change because of a business spec change, write an impact report listing the DB schema, front-end UI screens and API specs that need fixing in a chain.

TargetAPI change impact analysis
Key toolCodex Client Workspace
Lab scopeChange Impact Analysis
Step 1 ๐Ÿ“‚ Prepare the API change request file
Step 2 ๐Ÿ”„ Ask Codex to analyze the chain impact on UI and DB specs
Change Management Impact Analysis UI/API Sync
Expected output change-impact-report.md (change impact analysis)
Enter lab
SKILL 1
Skill Task 1

Skill Task 1. Endpoint Design Based on Domain Boundaries

ADD-D04-T01: Resource & URI spec for 4 Domains

Design Endpoints and usage scenarios for the Video, Playback, Campaign and Ad Serving Domains and check the boundaries.

TargetEndpoint spec per Domain
Key toolCodex Client
Lab scopeSkill Task (TECH)
Step 1 ๐Ÿ“ Derive noun-based resource URIs from the Domain Map
Step 2 โš™๏ธ Connect Methods (GET/POST/PUT/DELETE) and scenarios
Skill Task Endpoint Domain Boundary
Expected output 07_ENDPOINTS.md
Enter lab
SKILL 2
Skill Task 2

Skill Task 2. Write RequestยทResponseยทError Contracts

ADD-D04-T02: OpenAPI 3.0 spec and error format

Define input/output Schemas, Status Codes and Error Contracts, and write an OpenAPI 3.0 spec.

TargetOpenAPI 3.0 Spec written
Key toolCodex Client
Lab scopeSkill Task (HYBRID)
Step 1 ๐Ÿ“ Cross-check ERD and API field names/types
Step 2 โš™๏ธ Set the RFC 7807 error response structure and HTTP Status
Skill Task OpenAPI 3.0 Error Contract
Expected output 07_API_SPEC.yaml
Enter lab
SKILL 3
Skill Task 3

Skill Task 3. API Contract Consistency Review

ADD-D04-T03: Breaking Change and consistency review

Audit whether the API matches the Sequences/ERD and derive compatibility threats and negative test scenarios.

TargetBreaking Change & Review Report
Key toolCodex Client
Lab scopeSkill Task (AI)
Step 1 ๐Ÿ“ Audit API-Sequence-ERD consistency
Step 2 ๐Ÿ›ก๏ธ Find backward-compatibility Breaking Changes
Skill Task Breaking Change API Audit
Expected output api-review-report.md
Enter lab
๐Ÿš€ Advanced Missions โ€” Data Design Master Course
MISSION 1
Mission 1

Mission 1. API Review and Improvement Lab

Mission 01: API quality review and improvement suggestions

Review the quality of an existing API design against REST API standards and a consistent error format (RFC standard error schema).

TargetAPI review report
Key toolCodex Client Workspace
Lab scopeDesign API Review
Step 1 ๐Ÿ“‚ Prepare the API spec and review meeting transcript
Step 2 ๐Ÿ” Ask Codex to check REST standard compliance
API Review Standards
Expected output api-review-log.md
Enter assignment room
MISSION 2
Mission 2

Mission 2. API Test Scenario Lab

Mission 02: Derive normalยทexception test scenarios

Generate Happy Path and boundary-exception Sad Path test cases from the finished API contract.

TargetAPI test scenarios
Key toolCodex Client Workspace
Lab scopeAPI Test Scenarios
Step 1 ๐Ÿ“‚ Prepare the API contract spec
Step 2 ๐Ÿ›ก๏ธ Derive normal/exception cases with Codex
Test Scenarios Quality Guard
Expected output api-test-scenarios.md
Enter assignment room
MISSION 3
Mission 3

[Assignment] Mission 3. Fintech Open Banking API Spec

Skill Mission 1: Account lookup/transfer OpenAPI 3.0 & Error spec

Write OpenAPI 3.0 YAML specs and OAuth2 error formats for open banking transfer, account balance and transaction history APIs.

TargetOpenAPI 3.0 YAML spec written
Key toolCodex Client
Lab scopeSkill Task Mission (Level 1)
Step 1 ๐Ÿ“ Parse open banking endpoints and auth headers
Step 2 โš™๏ธ Standardize 401/403/422 error responses
Skill Mission OpenBanking OpenAPI 3.0
Expected output fintech-openapi-specification.yaml
Enter assignment room
MISSION 4
Mission 4

[Assignment] Mission 4. Delivery Order-Rider API Audit

Skill Mission 2: Real-time location tracking API consistency & Breaking Change

Audit Sequence-ERD consistency and compatibility for real-time delivery order creation, rider matching and location tracking APIs.

TargetAPI Audit table & Breaking Change report
Key toolCodex Client
Lab scopeSkill Task Mission (Level 2)
Step 1 ๐Ÿ“ Compare the rider matching API with Sequences/ERD
Step 2 ๐Ÿ›ก๏ธ Find v1-v2 compatibility threats and negative tests
Skill Mission Delivery API Breaking Change
Expected output delivery-api-audit-report.md
Enter assignment room