For the general access to a database you could use the KNIME DA Nodes:
https://docs.knime.com/2019-06/db_extension_guide/index.html
Then I have a few more examples of graphics using R and Python you might find useful.
R - multiple graphics
R - Venn Gram - Export graphics to PNG
R - Heatmaps with Dendrograms
Python - some graphics from the Iris data set
2 Likes