Responsive PostgreSQL Monitoring Dashboard

I have an AWS-hosted PostgreSQL instance that collects field data from several remote monitoring nodes. I need a secure, mobile-friendly web dashboard that lets service providers see exactly when a node needs attention, review what was done in the past, and leave fresh notes for the next technician. Core build • A backend service that connects to the existing PG database using best-practice security (parameterised queries, SSL, role separation). • 5–7 polished bar-chart or table views optimised for both laptop and phone screens. Fast render times matter, so you’ll likely add sensible indexes or query tuning along the way. • Clean role-based access control with two profiles: – Admin: can modify system settings and dig through detailed logs. – Viewer: can watch real-time data, browse complete service history, and trigger the built-in functionality test for a chosen node. Technology is your choice as long as it’s modern, maintainable and plays nicely with PostgreSQL—React, Vue, Svelte, Django, FastAPI, or similar are all acceptable. Just keep the code clear, documented, and container-ready for AWS deployment. Deliverables 1. Source code for frontend and backend (Git repo). 2. Database migrations or scripts required for new roles/tables. 3. Deployment read-me that lets me spin the stack up with a single command. 4. Short video or live demo proving responsive views and RBAC working end-to-end. I’ll test by logging in as both roles, running a functionality test from my phone, and confirming that log entries appear instantly. Please start your bid with “SQL Master” so I know you actually read the brief.

Project ID: 40446500