# lana-k/sqliteviz

Instant offline SQL-powered data visualisation in your browser

Repository: https://github.com/lana-k/sqliteviz
Canonical: https://ross.abutalabs.com/products/sqliteviz
Homepage: https://sqliteviz.com
Language: JavaScript
License: Apache-2.0
License Family: permissive
Topics: sqlite, visualization, plotly, data-analysis, csv, sql, plotting, charting, pivot, pivot-table
Last push: 2026-07-26T18:58:54+00:00

## Health v2 (maintenance only)
Score: 91/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 94, release rhythm 83, longevity 100
- inputs: {"age_days": 2173, "days_push": 38, "days_rel": 38, "gap_med": 64.0, "n_releases_24m": 13}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 2353, forks 135 (observed 2026-08-28T04:06:40.465887+00:00)

## What it is
sqliteviz is a single-page offline-first PWA for fully client-side visualization of SQLite databases and CSV/JSON/NDJSON files. It lets users run SQL queries in the browser and build Plotly charts, graphs, and pivot tables from the result sets, with no server involved.

## Use cases
- visualize a sqlite database with charts in the browser
- import csv files and plot the data with sql queries
- build pivot tables from query results offline
- analyze  nd data without uploading it anywhere
- export query results to csv or charts to png svg html
- run saved sql queries against different databases
- clean and prepare data with sql before visualization

## When to choose
- you need fully client-side analysis where data never leaves your machine
- you want a no-install browser tool that also works offline as a PWA
- you need SQL-powered charting and pivot tables over SQLite or flat files
- you want to reuse and share queries and visualizations across databases

## When to avoid
- you need a multi-user server-backed BI platform with dashboards and scheduling
- you require databases other than SQLite or very large datasets beyond browser memory
- you need automated report generation or alerting
- you want programmatic visualization APIs rather than an interactive GUI

## Facets
- artifact type: application
- maturity: active
- function: data-visualization, database, charts, search-engine
- domain: data-visualization, data-science, analytics, web-development, databases
- platform: browser, cross-platform
- tags: sqlite, plotly, pwa, offline-first, csv-import, pivot-table, client-side, sql-editor, privacy, web-server

## Member repositories
- lana-k/sqliteviz (main) score 91

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:06:40.465887+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T02:36:29.840397+00:00, confidence not recorded.
  - readme: https://github.com/lana-k/sqliteviz (fetched 2026-08-28T04:06:40.465887+00:00, sha 8148f6adde73)
  - homepage: https://sqliteviz.com (fetched 2026-08-29T10:17:29.944660+00:00, sha 8bce3da85918)
  - site_page: https://sqliteviz.com/docs (fetched 2026-08-29T10:17:29.953524+00:00, sha 6e7451cae49d)
- Data as of 2026-08-30T08:39:29.467469+00:00.