bshubhayu07/Nexora-Retail ? reverse-engineered prompt

Build me a local retail analytics app for a shop or supermarket that runs completely offline on the store computer.

I want it to track shopper footfall in real time, monitor shelves for out of stock items, and manage queue congestion, all from camera based edge AI. It should save alerts, logs, queue data, and heatmap info locally in a SQLite database, and nothing should leave the device. Please include a simple web dashboard I can open on localhost to see live metrics, alerts, and basic analytics, plus an API and docs page for testing.

Also add a small local assistant that can answer store related questions from the saved data, like busiest hours, queue status, or stock alerts. Use a clean backend structure, make it easy to run locally, and include a few sample records or seed data so the dashboard looks useful right away. If you need current docs for any local AI or web libraries, look them up online first.