Amazon Product & Review Intelligence
Scrapes Amazon listings and reviews, then answers questions about them in plain English. A self-query retriever pulls the constraint out of your sentence and applies it as a real filter. Built end to end, guardrailed, containerised and running on an EC2 box.
- Three ingestion modes: single URL, bulk Excel upload, live keyword search
- SQLite upserts keep repeat scrapes idempotent
- Dual Chroma collections with independently tuned self-query retrievers
- Every answer cites the products it drew from
- Separate Ask Products and Ask Reviews surfaces, one per collection
- Migrated from a Streamlit prototype to a React + FastAPI front end
- Input guards reject off-topic and prompt-injection attempts before retrieval
- Output guards redact reviewer PII and strip toxic sentences from answers
- Multi-stage Docker build: Node frontend stage, Python backend, headless Chromium
- Deployed on AWS EC2 via Docker Compose, with bind-mounted state and log rotation
