npm

datasette

Explore and publish data with SQL queries in a web interface.

brewmacoslinux
Try with needOr install directly
Source

About

Open source multi-tool for exploring and publishing data

Commands

datasette

Examples

load a CSV file and query it with SQL$ datasette data.csv
start a web server to explore SQLite database$ datasette mydata.db
publish database online and generate shareable links$ datasette publish heroku mydata.db --project myproject
convert JSON data into searchable database$ datasette insert mydata.db data.json
run SQL query and output results as JSON$ datasette query mydata.db 'SELECT * FROM table' --json