3

I am looking for a free data graphing application that can pull data from MySQL and display it on a trend graph without any programming. It should use a GUI to select the data to be plotted, start time, end time etc. Ideally it could be historical data or live real-time data.

  • LiveGraph looks like it has all the features but it works with CSV data
  • Cacti is similar but it requires the data to be in RRDtool

Is there anything similar that is designed to retrieve data from a SQL database?

Kenster
  • 8,620
Automate
  • 31

3 Answers3

5

Simple and free real time charts for Windows/Mac/Linux: sqlDashboards. Connects to mysql/postgresql/mssql, allows heatmaps, bar charts, area charts, pie charts.. plotted straight from SQL queries and refreshed in real time.

Screenshot
(Click image to see animation)

Charts are generated straight from SQL as soon as you write the query. No delay, no complicated setup. Configuring the layout is drag-and-drop.

Disclaimer: I work for the company but I believe it fits exactly what you are looking for.

karel
  • 13,706
Ryan Hamilton
  • 151
0

I use tableau for BI data visualization, but it ain't cheap. However, it could work for your purposes, and they have a free trial.

http://www.tableausoftware.com/tableau-software

Brian Adkins
  • 2,021
0

What about Stack Exchange's own Data Explorer?

Ben Collins
  • 1,020