Awesome Open Source
Awesome Open Source

sqliteviz

Sqliteviz is a single-page offline-first PWA for fully client-side visualisation of SQLite databases or CSV files.

With sqliteviz you can:

  • run SQL queries against a SQLite database and create Plotly charts and pivot tables based on the result sets
  • import a CSV file into a SQLite database and visualize imported data
  • export result set to CSV file
  • manage inquiries and run them against different databases
  • import/export inquiries from/to a JSON file
  • export a modified SQLite database
  • use it offline from your OS application menu like any other desktop app

https://user-images.githubusercontent.com/24638357/128249848-f8fab0f5-9add-46e0-a9c1-dd5085a8623e.mp4

Quickstart

The latest release of sqliteviz is deployed on sqliteviz.com/app.

Wiki

For user documentation, check out sqliteviz documentation.

Motivation

It's a kind of middleground between Plotly Falcon and Redash.

Components

It is built on top of react-chart-editor, PivotTable.js, sql.js and Vue-Codemirror in Vue.js. CSV parsing is performed with Papa Parse.



Alternative Project Comparisons
Related Awesome Lists
Top Programming Languages
Top Projects

Get A Weekly Email With Trending Projects For These Topics
No Spam. Unsubscribe easily at any time.
Javascript (1,075,101
Sql (22,156
Visualization (15,333
Csv (15,116
Chart (13,517
Sqlite (9,949
Data Analysis (4,899
Plotting (2,993
Visualisation (2,731
Plotly (1,691
Charting (811
Pivot Tables (188
Pivot (44