A node CLI application for managing the employees in your organization using a MySQL database.
- add employees, roles, and departments
- assign salaries to roles
- identify managers for each employee
- update and view your employees' data
- run unique queries (e.g., total budget by department)
mysql2
inquirer
console.table
figlet
- Download MySQL
- Clone this repository
npm install
- Enter your MySQL Username and Password in the
connection.js
file
- In app folder, type
npm start
- Use arrow keys to select menu option
- Enter information / select a query
- Select Quit close database
NOTE: The app automatically seeds 8 employee records into an organization
database upon initial usage; use Delete
option(s) in main menu to adjust to your needs.