Realtime Tuya Data Collector

I need a lightweight PHP solution that can pull three data points from my Tuya smart plug—energy consumption, current device status, and the operational log—and push them straight into a database in real time. The Tuya IoT API will be the bridge; the code should handle authentication, token refresh, signing, and parsing of the JSON responses.

Once the data is captured, it must be written immediately to a MySQL table (I’m open to a different engine if you have a strong reason). Structure the table so I can easily query usage trends by timestamp, flag status changes, and review historical logs without extra post-processing.

Deliverables
• PHP source code with clear, inline comments
• SQL file that creates the necessary table(s)

Acceptance criteria
• Script authenticates against my Tuya credentials and continues to refresh tokens automatically
• All three data types arrive in the database with accurate timestamps on the first run


If you have previous experience with Tuya’s signing method or webhook/websocket options, mention it—the smoother and more reliable the feed, the better.