Tech Stack
Node.js
express.js
MySQL
Description
InStock Server is the backend API for an inventory management system. It provides warehouse, inventory, and category endpoints that allow managing product stock and warehouse metadata via a MySQL database.
- Express 5 REST API
- MySQL database connection via mysql2/promise
- CRUD operations for warehouses and inventory items
- Inventory categories endpoint
- Input validation for relationships, email, phone, and quantities
- Centralized inventory control for multi-warehouse operations
- Data integrity with relational warehouse/inventory checks
- Simple JSON API suitable for integration with frontends or mobile apps
- Production-ready foundation with optimistic defaults and clear status responses