Reading from an Array into a chart

You could use this solution as a starting point.

PS, use TOP or LIMIT clause in your query (rather than bringing 50000+ records to node-red, just limit the data coming from the database)