Although there are lots of database plotting programs (like Grafana, etc..) you might like to take a look at the FREE version of Clarify as that integrates quite well with Node-RED.
https://clarifyapp.clarify.io/
I use it for plotting readings from a node in my greenhouse and the node in my friend's shed in Boston, USA.
Here's the simple Node-RED flow to process the readings from MQTT to Clarify.
There are posts about Clarify on this Forum. Here's just one of them...
Hi, I'm Bernt-Johan, one of the founders at Clarify.io .
I've been part of the Node-Red community for a while now, during which I've been developing the Clarify Node-Red Node. And with our release of a totally free plan, I feel it's time to tell you folks, more about what Clarify is and see how it can be useful for some of you.
Clarify is a time-series visualization platform that helps users quickly turn data into information. We do this by storing and presenting time-series data alongside comm…