I was looking for something like this the other day. Found sqliteviz(https://lana-k.github.io/sqliteviz/) which can be installed as a Chrome app, and Plotly Falcon (https://github.com/plotly/falcon) which both work well. Both are 100% free.

Very cool! This would be very useful for those who know SQL. What about a UI for users that don't know SQL? Something with drag and drop would be neat.

Hello Product Hunters, My name is Tanin, and I'm the creator of Superintendent.app, which is a Desktop app that enables you to load a bunch of CSV files and write SQL to analyze them. In my regular job, we offer accounting reports as CSVs to our customers, so I work with CSV heavily. Before Superintendent.app, the major frustration of working with CSV files was that I had to use either a command-line tool, a custom Python script, or Excel in order to analyze multiple CSV files. I chose Excel most of the times and often struggled with vlookup and pivot tables. Not to mention, Excel has the 1M row limit per sheet, which means it cannot handle a large CSV file. I hope my pain point resonates with you. As a person who knows SQL well, it felt very counter-productive. So, I've decided to build a prototype that later became Superintendent.app. Superintendent.app makes loading CSV files and writing SQL easy and quick. It is backed by Sqlite and sets up table names and columns automatically. It avoids name conflict, so you don't need to think about it. It can load 1GB CSV file within 10s. You just load a bunch of CSV files and start writing SQL immediately! As a novice in launching product, I'd love to get feedback and suggestion on any part (e.g. landing page, product). Please don't hesitate to send me your thoughts by commenting here or, privately, at tanin@superintendent.app. Thank you.