MySQL Workbench – How to make database schema in MySQL Workbench?

By | February 13, 2023

MySQL Workbench is an integrated development environment tool for designing and modeling database architecture. It is a unified visual tool for database architects, developers and DBAs(Database Administrators). MySQL Workbench comes along with various integrated tools which can be easily used for administrating purposes of server configurations, executing SQL queries, complex database schema designing and management, backup etc. MySQL Workbench is available for almost all the common operating system such as Windows, Mac OS and Linux.

MySQL Workbench offers the following editions:

  1. MySQL Workbench Community Edition — Open Source (GPL License)
  2. MySQL Workbench Standard Edition — Commercial
  3. MySQL Workbench Enterprise Edition — Commercial

MySQL Workbench features

  • DB schema design
  • DB development and management
  • DB administrator
  • DB performance dashboard
  • DB migration
  • DB reverse engineering
  • DB forward engineering
Note: In this tutorial, we will create database schema for our Blog Application. Please refer the Blog Application Series for complete backend development with Spring Boot and MySQL.

Steps to create database schema

Step 1- Create DB Schema

In this step, we will be create database schema for Blog Application for this will be using MySQL Workbench. To create db schema Open Workbench > Schema > Right-Click > Create Schema.

MySQL Workbench - How to create database schema
Fig 1 – Create DB Schema

Step 2- Name DB Schema

Once, we click on Create Schema, workbench will open a popup for schema name. We need to write the name of our database(Here, we will be using blog-application-db).

MySQL database
Fig 2 – DB Name

Step 3- Execute SQL Script

After we have named our db, we need to click on Apply. It will open another popup window asking to apply SQL script to create database.

SQL Script
Fig 3 – Apply SQL Script to DB

Once, we click on Apply, workbench again popup a confirmation tab to execute SQL scripts.

MySQL Database
Fig 4 – Execute SQL Script

After we click Finish, workbench will execute the SQL scripts.

How to create database in mysql
Fig 5 – SQL Scripts Result


Once, the database scripts gets executed, our database will get created.

MySQL Workbench Database Schema
Fig 6 – DB Schema

Leave a Reply

Your email address will not be published. Required fields are marked *