Smart Home Automation (MQTT + ESP32)

Role:IoT Systems Developer

Year:2026

Overview

Developed using C++ on ESP32 microcontrollers. Communicates state anomalies over MQTT. Features a Python listener backend that logs telemetry data in a MySQL database for visual query processing.

Problem Statement

Typical consumer smart devices rely heavily on proprietary cloud servers, creating privacy risks and introducing high device-to-cloud latency.

Proposed Solution

Prototyped a local IoT architecture routing controller telemetry signals through a local Mosquitto MQTT broker, logging records inside a local MySQL database.

System Architecture

ESP32 microcontrollers write device metrics to MQTT channels. A background Python daemon listens to these topics, deserializes payloads, and updates databases.

API Client Request

FastAPI routing

SQLAlchemy ORM

MySQL Relational DB

Key Features

Sub-100ms relay response times
ESP32 C++ sensor interface telemetry logs
Python daemon listener routing to SQL databases
Offline-first local connection recovery logic
JSON payload data structure formatting

Challenges Faced

Preventing sensor telemetry data dropping during high-frequency Wi-Fi network packet collisions.

What I Learned

Deepened understanding of event-driven messaging pipelines, network socket boundaries, and asynchronous database insertions in Python.

Gallery & Mock Previews

Mock System Frame

Active Database log

Technology Stack

Python

C++

ESP32

MQTT

MySQL

Development StatusIn Progress

Source Code

Related Projects

Backend Development

Lead Management System API

Completed

A secure RESTful API for tracking sales leads. Implements JWT token-based authentication and role-based permissions.

Python

FastAPI

SQLAlchemy

MySQL

+1 more

View Case Study

Backend Development

E-Commerce Backend API

Completed

A backend service modeling inventory, cart orders, and transactions using relational database schemas.

Python

FastAPI

SQLAlchemy

MySQL

+1 more

View Case Study