MySQL Browser

MySQL Browser is an operational which acts like a GUI app that allows users  to connect to their MySQL database and run SQL commands.

For front-end and back-end code development, JavaScript/React/MUI are utilized. For handling communication between front-end and back-end I used Express.js and Axios. The source codes in the repository are available for viewing.

This is was the first project where I learned to work with MySQL and incorporating it with node.js and using it for data retrieval, storage and manipulation.

Header and colours that were used for this project, as a banner.

The application has an easy to use and user friendly UI, where connection parameters are set to the defaults, but users can change the parameters values and connect to the database if they wish to. After connecting, it allows user to choose a schema from available options to connect to and it will display available tables and views.

Before connecting to MySQL database.

Users data such as their username and password won't be stored in database, only used to make connection to the database. 

After selecting a schema to connect, users can notice that all the tables and views are available in that database will appear on the left side of the page. By clicking on the available tables or views, they can run simple DQL, DDL, DML commands in the text area and see the results bellow in the table.

After connecting to schema and running select command to see available data in the table.

For safety of the users, I have disabled commands such as delete, truncate, or drop, in case users accidentally create a query that contains those commands. 

After executing show create table command.

This application doesn't let users to run some of MySQL commands like: 

• delete, truncate, or drop