Why should you care?

Visual table diagrams help when DataFlow grows to dozens of tables. Beginners also find query tabs easier than memorizing CLI flags.

See it live — copy this example

Run in MySQL Workbench or the mysql CLI.

-- Run in a Workbench SQL tab after connecting:
CREATE DATABASE IF NOT EXISTS DataFlow;
USE DataFlow;
SELECT 'Workbench connected' AS message;

What happened?

• CREATE DATABASE makes DataFlow if missing.
• USE selects it.
• The SELECT returns one row — if you see it in the result grid, Workbench is wired to your server.

Practice next

1. Install MySQL Workbench from the same MySQL Installer or standalone download.
2. Click + to add a connection: hostname 127.0.0.1, port 3306, user root.
3. Open the connection and paste the example SQL.
4. Open Database → Reverse Engineer and pick DataFlow (after tables exist).
5. Run EXPLAIN on a simple SELECT to preview the execution plan panel.

Remember

Workbench is a client GUI, not the database engine. SQL tabs behave like mysql CLI. Save scripts for repeatable DataFlow setup.

DataFlow schema review

A DBA shares an EER diagram exported from Workbench so the team agrees on orders ↔ order_items before coding.

Outcome: Fewer wrong JOIN assumptions in API design.