This is a nodejs command line employee tracker application that allows users to create and view department, role, and employee information stored in a SQL database.
- Run
npm install
to install dependencies. - Log into your mysql shell using your username and password
- Run the commands in the schema.sql in your mysql shell to create the database and tables.
- Run
npm start
to connect to the server
Be sure to update your .env file with your password. An example file is provided.
Checkout this demo of the intended functionality for intended usage.
Ideas for future functionality include:
- View employees by manager/department/role
- Delete departments, roles, and employees
- View the total utilized budget of a department -- ie the combined salaries of all employees in that department
MySQL Employee Tracker is MIT licensed
Feel free to contribute to this project by forking the repo, making your changes and creating a pull request when you're ready.
If you have any questions, contact me:
Email: l.teal21@gmail.com