Datasette

Datasette turns SQLite (or other) databases into interactive, searchable websites and JSON APIs with a single command. It automatically renders tables, lets users filter and sort rows, and provides a built‑in SQL console for deeper analysis. Metadata such as licensing and source information can be supplied via a JSON file and is displayed on the site and included in API responses.

The tool is aimed at data journalists, archivists, museum curators, local governments, scientists, researchers, and anyone who needs to share structured data publicly or within a team. It supports importing data from CSV, JSON, and database connections, and can be deployed to cloud platforms like Heroku or Google Cloud Run using a one‑line publish command that builds a Docker image containing the data and the web interface.

Datasette is open source under the Apache 2.0 license, runs on Python 3.8+, and offers a self‑hostable, free‑tier experience without subscription requirements. It is extendable through a plugin ecosystem, and a macOS desktop version provides a graphical way to run the same functionality locally.