Log Modbus TCP/IP Device Data into MySQL Database using Node-RED

Overview

This Node-RED flow enables seamless logging of Modbus TCP/IP based device data into a MySQL database, either locally or remotely. The solution is designed for industrial automation, IoT, and SCADA systems, providing a flexible, scalable, and fully customizable way to collect and store sensor/device data at configurable intervals.

Key Features

✅ Modbus TCP/IP Integration – Reads data from Modbus-compatible devices (PLCs, sensors, meters, gateway, etc.).
✅ MySQL Database Logging – Stores collected data in a structured format for analysis and reporting.
✅ Customizable Polling Intervals – Supports multiple logging intervals for different tags/devices.
✅ Scalable Architecture – Easily expandable to support additional Modbus devices or database tables.
✅ User-Friendly Configuration – No coding required; fully configurable via Node-RED’s visual interface.
✅ Local & Remote Database Support – Works with both on-premise and cloud-based MySQL servers.
✅ Error Handling & Logging – Built-in mechanisms to ensure data integrity and troubleshoot connectivity issues.

Use Cases

✔ Industrial Automation – Log sensor data from PLCs, RTUs, and HMIs.
✔ Energy Monitoring – Record power consumption, voltage, and current from energy meters.
✔ Smart Manufacturing – Track machine performance and operational metrics.
✔ Environmental Monitoring – Store temperature, humidity, and pressure readings over time.

Technical Specifications

Why Choose This Solution?

🔹Low-Cost & Efficient – Uses open-source Node-RED for easy deployment.
🔹Time-Saving – Automates data collection, eliminating manual logging.
🔹Customizable – Adaptable to different Modbus devices and database schemas.
🔹Reliable & Lightweight – Optimized for stable, long-term operation.

Ideal For

🔹OT/IT Engineers looking for a simple Modbus-to-SQL solution.
🔹Industrial IoT Developers needing scalable data logging.
🔹System Integrator requiring a flexible, low-code automation tool.