You might need to put a jumper link on J1 in order to enable the 120 OHM termination resistor ( This is necessary for reducing the reflections on the CAN lines ). You ...

ESP32 (Publisher) → HiveMQ Cloud → Backend (Subscriber) → Supabase PostgreSQL ↘ ↗ Frontend (Publisher) → Relay Commands → ESP32 (Subscriber) ...