Command Line
Employee Tracker

The Employee Tracker is a command-line application built to simplify managing a company's employee database. It allows users to view, add, and update departments, roles, and employees through a set of interactive prompts, making it a lightweight but powerful tool for organizing workforce data.

Stack: JavaScript, Node.js, PostgreSQL

Project Goal

The goal of this project was to create a tool that makes managing employee information easier without relying on a web interface. By building this application, I wanted to practice working with databases, sharpen my skills in handling user input from the command line, and learn how to structure data for real-world business use cases.

Learning Outcomes

This project helped me get much more comfortable working directly with relational databases. I learned how to design tables and relationships in PostgreSQL to reflect a company's structure, and how to write queries that return the data in clear, formatted tables. I also gained confidence in using Node.js with Inquirer to collect and validate user input, and I saw firsthand how the backend and database need to work in sync to keep everything running smoothly. Most importantly, this project showed me how to translate real-world business requirements into a technical solution that feels both practical and user-friendly.