Sqliteviz
An offline web app that helps you clean and prepare data for rich visualisation with the power of SQL without leaving your browser
Features
Full-featured SQL
Filtering, sorting, joins, subqueries, aggregates, window functions and most stuff that you expect in SQL to easily massage your data for visualisation
Common format exchange
Import SQLite databases and multiple CSV files, export modified database, save result set to CSV or copy it to clipbord
Powerful visualisation
Rich palettе of Plotly’s basic, statistical, scientific, financial, geographic and 3D charts on flat result sets or pivot tables
Reuse and share your work
Load and save queries and visualisations, run them against different databases, export the visualisation to HTML, PNG, SVG or copy it to clipboard
Offline-first browser app
The app is just one click away — no need to install it, but you can, as PWA, and open it from the OS menu like any other desktop app; there’s no server, hence your data never leaves your machine
Free and open-source software
Well, it’s free and open-source :-)