Hi Andrea welcome to the forum
Which part are you stuck on querying the database or building the chart?
There are quite a few examples of mySQL to chart in the forum already if you search.
E.g. this one works pretty much without modification: Dynamic series identification from message, send data to Chart - #5 by Steve-Mcl
Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.
The OpenJS Foundation | Terms of Use | Privacy Policy | OpenJS Foundation Bylaws | Trademark Policy | Trademark List | Cookie Policy