Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

closed as off-topic by fixer1234, DavidPostill, mdpc, random Dec 3 '15 at 22:20

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions seeking product, service, or learning material recommendations are off-topic because they become outdated quickly and attract opinion-based answers. Instead, describe your situation and the specific problem you're trying to solve. Share your research. Here are a few suggestions on how to properly ask this type of question." – fixer1234, DavidPostill, mdpc, random
If this question can be reworded to fit the rules in the help center, please edit the question.

    
What is your price range? ... Or free? – BrianAdkins Jul 17 '12 at 0:12
    
Yes, Free. Prefer open source but not required. Modified original question – Automate Jul 17 '12 at 0:38
    
How about excel? You could set up an odbc data source and suck the data into excel for graphing – BrianAdkins Jul 17 '12 at 0:50
    
As BrianAdkins mentioned, Excel is probably your best option, if you have it? – dav Jul 17 '12 at 11:42
    
I would rather not use Excel. I am leaning toward setting up something that dumps the DB table to a CSV file and then use LiveGraph – Automate Jul 17 '12 at 16:13

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.

share|improve this answer

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

share|improve this answer
    
Thanks, I am familiar with Tableau but was looking for something simple and free. – Automate Jul 17 '12 at 0:40

What about Stack Exchange's own Data Explorer?

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.