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

sqliteviz_demo.mp4

Quickstart

The latest release of sqliteviz is deployed on GitHub Pages at lana-k.github.io/sqliteviz.

For user documentation, check out sqliteviz Wiki.

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

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.

Name		Name	Last commit message	Last commit date
Latest commit History 382 Commits
.github/workflows		.github/workflows
lib/sql-js		lib/sql-js
public		public
src		src
tests		tests
.browserslistrc		.browserslistrc
.editorconfig		.editorconfig
.eslintrc.js		.eslintrc.js
.gitignore		.gitignore
LICENSE		LICENSE
README.md		README.md
babel.config.js		babel.config.js
karma.conf.js		karma.conf.js
karma.files.js		karma.files.js
package-lock.json		package-lock.json
package.json		package.json
vue.config.js		vue.config.js