Recently searched and played with plugins.
Found couple of nice working plugins (dbquery and sql query) that I can use to fetch data from databases by using sql and output as table . Than there is couple of also nice chart plugins (c3chart and ApexCharts), that I can use to create a chart.
It looks that they both (database/sql and chart) plugins could be combined so that it would be possible to create online data charts from databases, but I did not yet manage to find an example to do so.
It seems that it could be possible by using csv as chart data source, but I did not yet manage to find an working extension, that can make sql query result as CSV output.
Another guess regarding SQL json plugin could it be used as data source for a chart, but also I yet failed to do so.
Are there could be any samples to achieve such functionality: dbquery->chart ?