Skip to content

Data Lab

Data Lab is an integrated environment for analyzing data directly inside the ERD canvas. Execute SQL and view results instantly — right in the browser, without installing or connecting to any external database.

How It Works

Data Lab operates based on the entity structure of the currently open diagram.

  1. Entity/column structures from the diagram are auto-created as virtual tables
  2. Realistic virtual data is auto-generated by analyzing column name patterns
  3. Instantly queryable via SQL or SPARQL
graph LR
    E["📊 ERD Entities"] -->|"Structure extraction"| D["🗄️ Virtual Database"]
    F["🎲 Auto-generation"] -->|"Virtual data"| D
    D -->|"SQL query"| R["📋 Results Grid"]

    style E fill:#e0f2fe,stroke:#0284c7
    style D fill:#fef3c7,stroke:#d97706
    style R fill:#f0fdf4,stroke:#16a34a

When switching diagrams

When you switch diagrams, previous tables are automatically cleared and recreated with the new structure. No confusion from residual data.

Auto-Generated Virtual Data

Virtual data is intelligently generated to match the context by analyzing column name patterns. Rather than simple random values, it produces realistic data for validating analysis scenarios.

Column Name Pattern Generation Rule Example
email Realistic email address kim.jihye@company.co.kr
phone Phone number format 010-1234-5678
name Person names John Smith, Jane Doe
address Realistic address format 123 Main St, Suite 100
PK column UUID or unique serial number 550e8400-e29b-41d4...
Others Random values matching data type —

Feature Guides

  • SQL Scratchpad

    Execute SELECT, JOIN, aggregation, and various queries against virtual tables using the SQL editor. Supports Smart Drop — drag and drop entities to auto-generate queries.

    Details

  • SPARQL & Ontology

    Convert ERD structures to ontology (RDFS/OWL) in real time and perform semantic analysis with SPARQL. Explore entity relationships from a graph perspective.

    Details