Product Design & Development

PartsPilot

A production-deployed full-stack automotive inventory management and analytics platform bringing stock control, supplier management, reporting and operational insight into one clear product experience.

Type

Full-Stack Web Application

Industry

Automotive

My Role

Designer & Developer

StatusLive · Public demo ↗

PartsPilot dashboard showing inventory metrics and recent activity

The Problem

Inventory shouldn't become harder to understand as it grows.

PartsPilot was created around a practical operational problem: managing inventory requires more than keeping a list of parts. Teams need to understand what is available, what needs attention, where stock comes from and what the wider inventory data is telling them.

The product brings inventory management, stock monitoring, supplier information and reporting into one automotive-focused application, turning day-to-day records into clearer operational information.

The Approach

From inventory records to a complete operational workflow.

PartsPilot was designed as a complete full-stack product rather than a standalone interface. The React frontend communicates with a FastAPI REST API, with SQLAlchemy managing persistence through PostgreSQL.

The product was developed around practical workflows: managing inventory, tracking stock levels, maintaining supplier records, reviewing operational analytics and exporting useful reporting data without separating each task into a different tool.

PartsPilot inventory management interface with search, filtering and stock controls

The Product

One place to manage and understand inventory.

Authenticated inventory management

Create, view, update and delete inventory items

Search, filtering, sorting and pagination

Stock-level monitoring

Supplier management

Dashboard operational analytics

Inventory value and category analytics

Reports and CSV export

Power BI business intelligence

Authenticated read-only public demo

Responsive desktop and mobile experience

Analytics

Operational insight with a dedicated reporting layer.

PartsPilot combines reporting within the application with a dedicated Power BI dashboard, giving operational inventory data a clearer business intelligence layer.

The application provides inventory value, stock, product and category reporting alongside CSV export, while Power BI extends the reporting experience with interactive visual analysis of the automotive inventory dataset.

PartsPilot Power BI inventory analytics dashboard

Engineering

Built as a complete full-stack application.

Frontend

React, TypeScript, Vite, Tailwind CSS

Backend

Python, FastAPI, SQLAlchemy, JWT

Database

PostgreSQL

Analytics

Power BI

Infrastructure

Docker, Docker Compose

GitHub Actions

Deployment

Vercel, Railway

React + TypeScript · Vercel

↓ REST API

FastAPI · Railway

↓ SQLAlchemy

PostgreSQL · Railway

Deployment

PartsPilot is deployed as a complete full-stack application, with the React frontend hosted on Vercel and the FastAPI API and PostgreSQL database hosted on Railway. The live environment uses persistent production data, JWT authentication and read-only demo access to protect the shared dataset.

Current Result

A feature-complete full-stack product, deployed end to end.

PartsPilot has reached its v2.0.0 feature-complete milestone, bringing together authenticated inventory management, supplier workflows, operational analytics, reporting and Power BI within one automotive-focused product.

The application is now deployed as a full-stack public demo, with the React and TypeScript frontend hosted on Vercel, the FastAPI backend deployed on Railway, and PostgreSQL providing persistent production data. The public demo uses authenticated read-only access, allowing visitors to explore inventory, suppliers, reports and analytics without modifying the shared demo dataset.

PartsPilot is in maintenance, with future work focused on reliability, automated testing, documentation, monitoring and infrastructure improvements rather than continued feature expansion.

View live public demo ↗