I've done something pretty similar that with my project here [0]. Instead of using MQTT the ESP32 feeds directly to an InfluxDB database.

[0] - https://github.com/dcmorton/esp32-dht22-upython