OpenFileConverter Edge WASM Studio
Screen #40 of 60 Batch 7 desktop • 1440x900px

Desktop Database DDL Schema to Mermaid ERD Diagram Converter

Open Route
Specification & Codex Reference Prompt (Click to expand) (Database DevOps studio converting raw SQL DDL `CREATE TABLE` scripts into interactive Mermaid.js entity-relationship diagrams (ERD).)

Screen Role: Database DevOps studio converting raw SQL DDL `CREATE TABLE` scripts into interactive Mermaid.js entity-relationship diagrams (ERD).

Design Intent: A developer-grade database schema migration and diagram studio UI at 1440x900 resolution in bright Light Mode. White background (#FFFFFF). Split-screen workstation layout: - Left Panel (50%): Syntax-highlighted SQL editor containing PostgreSQL DDL statements (`CREATE TABLE users...`, `CREATE TABLE orders...`, foreign keys, indexes). - Right Panel (50%): Interactive vector Mermaid.js Entity-Relationship Diagram (ERD) canvas: clean rectangular table entities connected by cardinality lines (crow's foot notation) showing relationships between Users, Subscriptions, Invoices, and AuditLogs. Top control bar: Format selector dropdown "[ PostgreSQL / MySQL / SQLite DDL v ]", toggle "Show Column Types", and export buttons: Primary indigo "Export Vector SVG Diagram", secondary "Copy Mermaid Code", and "Export DBML". Developer aesthetic, JetBrains Mono font, zero emojis.

Component Architecture: Django Cotton components (<c-file_converter.* />) with Tailwind tokens matching Labb.io design language.

Direct route: /file-converter/studio/ddl-erd/ Template: file_converter/screens/screen_40.html
Live Django Implementation (desktop)
Isolate →
ERD

Database DDL Schema to Mermaid ERD Studio

SQL DDL → Visual Entity-Relationship Diagrams & DBML

Dialect: PostgreSQL DDL
schema.sql (PostgreSQL) 4 Tables Parsed
CREATE TABLE users (
    id UUID PRIMARY KEY,
    email VARCHAR(255) UNIQUE NOT NULL,
    created_at TIMESTAMPTZ DEFAULT NOW()
);

CREATE TABLE subscriptions (
    id UUID PRIMARY KEY,
    user_id UUID REFERENCES users(id),
    plan_tier VARCHAR(50) NOT NULL,
    status VARCHAR(20) NOT NULL
);

CREATE TABLE invoices (
    id UUID PRIMARY KEY,
    subscription_id UUID REFERENCES subscriptions(id),
    amount_cents INT NOT NULL
);
Parser: pure Rust SQLAST • zero runtime latency
USERS
PK iduuid
emailvarchar
created_attimestamptz
SUBSCRIPTIONS
PK iduuid
FK user_iduuid
plan_tiervarchar
Mermaid.js v11 • Crow's Foot Cardinality (1:N)
Original Codex Reference Mockup Full PNG
Authoritative Reference for Screen #40