CETEC EcoConnect
A live, end-to-end IoT platform that streams real-time environmental & water-quality readings from ESP32 field devices into secure, multi-site dashboards — replacing manual, spreadsheet-based data collection with live monitoring.
The live monitoring dashboard — real-time pH & dissolved-oxygen readings, per site.
From manual readings to real-time visibility
Data that was hard to act on
CETEC (Central Environmental Testing & Consultancy) collected environmental and water-quality data manually across multiple field sites — slow to gather, scattered across spreadsheets, and impossible to monitor in real time.
An end-to-end monitoring platform
A complete system from field hardware to cloud dashboard: ESP32 sensors push live readings into a secure API, and each site's team monitors and analyses their data in real time through role-scoped dashboards.
Capabilities
Real-time dashboards
Live sensor cards with status badges (online / offline / no data) and min–max range, plus historical trend charts per site.
Multi-site architecture
Six monitoring locations; each user scoped to their assigned site's data only.
Role-based access control
Super Admin, Site Admin and User roles with session auth and hashed credentials.
Live IoT ingestion
A secured HTTPS endpoint receiving continuous readings from ESP32 field devices.
Responsive & fast
Mobile-first UI, dark / light themes and a performance-tuned landing experience.
CI/CD & secure infra
Zero-touch auto-deploys, HTTPS everywhere, hardened and continuously monitored.
Role-based access, from the ground up
- Add, edit and remove monitoring sites
- Assign Site Admins to a site
- Approve or reject new sign-up requests
- Activate / deactivate any account
- View & export data across every site
- Live dashboard & analytics for their site
- Export readings for their site
- No visibility into other sites or users
- Live dashboard & analytics for their site
- Read-only — no management or export actions
Super Admins manage every site from one place — add new locations, watch live sensor status per site, and edit or retire sites as field deployments change.
Trend, comparison & distribution — not just live numbers
A dedicated analytics workspace aggregates readings daily or weekly and surfaces trend lines with min/max bands, a pH-vs-DO correlation view, and distribution breakdowns (ideal / alkaline / acidic, normal / high / low) — every view and every per-parameter data page exportable to Excel with date, status and location filters.
Per-parameter data pages (Dissolved Oxygen, pH) with status badges, date / location filters, and one-click export to Excel.
How the data flows
Technology
Beyond the app itself, I owned the entire deployment: registered the domain, provisioned and hardened a Hetzner VPS from scratch, deployed the frontend, backend and database myself, and built the GitHub Actions pipeline that handles CI/CD end to end.
Secure by design
- HTTPS everywhere — auto-renewing TLS across the whole platform.
- Hardened infrastructure — firewall, least-privilege deploy user.
- Automated patching — dependency & OS security updates.
- Continuous monitoring — health checks & alerting in place.
Explore the live platform
The system is live in production, serving CETEC across six monitoring sites.