Datasette

Explore and publish SQLite data as an interactive website and JSON API

Datasette is a tool for exploring and publishing data. Point it at a SQLite database to get a browsable web interface, faceted search, SQL queries, and a JSON API, with a large plugin ecosystem.

Key features

Instant web UI and JSON API for SQLite
Faceted browsing and full-text search
Publish to cloud hosts in one command
Rich plugin ecosystem

Try it on DevTools Daily

SQLite cheatsheet

Similar tools

ClickHouse
Open-source column-oriented database for real-time analytics
by ClickHouseFreemiumOpen sourceLinux, macOS, Self-hosted +2
DBeaver
Universal database client for SQL and NoSQL databases
by DBeaver CorpFreemiumOpen sourcemacOS, Windows, Linux
DuckDB
In-process analytical SQL database for fast queries over local and remote files
by DuckDB LabsFreeOpen sourceCLI, macOS, Windows +2
jq
Lightweight command-line JSON processor, like sed for JSON data
FreeOpen sourceCLI, macOS, Windows +1
Miller
Like awk, sed, cut, and sort for name-indexed data such as CSV, TSV, and JSON
FreeOpen sourceCLI, macOS, Windows +1
Turso
Hosted SQLite-compatible databases, one per user or tenant
by TursoFreemiumOpen sourceWeb, API, CLI