StockCloud

An Azure-hosted inventory management system

cHECK OUT DOCUMENTATION      Check OUT THE SITE

Tecnologies Used

Azure OpenAI

Static Web Apps 
(Frontend)

App Services
(Backend)

Terraform

Azure SQL Server

KeyVault

React (Frontend)

Node.JS 
+ Express API (Backend)

Github CI/CD

Project Description

StockCloud is a full-stack inventory management system with AI functionalities hosted on Azure. It seamlessly integrates the frontend (Azure Static Web Apps), backend (Azure App Service), and database (Azure SQL), with CI/CD managed through GitHub. This setup allows for scalable, dynamic app development and efficient IT inventory management, enabling easy assignment of users to devices, devices to storage, and real-time inventory tracking.

App Features

Real-time Inventory

The inventory is displayed and updated in real-time.

learn more

Dynamic and Scalable

The App has been created to be dynamic and scallable as it uses modern tecnologies such as React and Node.JS

learn more

AI SQL ChatBot

I have included in this project the AI SQL Chatbot, to be able to conversate with a Azure Open AI bot to ask information about the database with AI

learn more

SQL Screen

There is a section for executing "SELECT" queries to perform other types of queries which have not been defined, used for DB Admins

learn more

24/7 Support Assitance

StockCloud offers 24/7 support via email, phone, and WhatsApp.

learn more

Analytics

The Analytics screen shows item quantities, types per storage or location, and device distribution across locations.

learn more

Multi-Language Support

The website has been implemented for Multi-Language Support for any user on the globe

learn more

Accessible anywhere

Because this App is hosted on the Cloud, it can be access by anywhere from anyone

learn more

Purpose of this Project

The purpose of this project was to expose myself to new technologies, including Azure cloud services and new programming languages for both frontend and backend (React and Node.js). I’m proud of how much I’ve learned, starting with no knowledge of React and Node.js, and now confidently applying them. 

I built a f ull-stack application with AI integration, combining the frontend, backend, and SQL Server, all from scratch. Throughout the project, I’ve learned technologies like SWA, App Services, React, Node.js, and OpenAI

This project also demonstrated my ability to tackle new challenges and stay self-motivated. Even when I faced struggles at the start, I persevered and excelled as I gained knowledge and skills along the way.