Datasette

2026-08-05data·python·tool

Datasette is a tool for exploring data in SQLite databases. You point it at a database file and it gives you a web page for each table, where you can sort and filter the rows and run your own SQL queries. Every result is also available as JSON.

You install it with pipx:

pipx install datasette

and then give it a database:

datasette mydata.db

This starts a local server at http://localhost:8001. There is also a datasette publish command for putting a database online, and plugins that add things like charts, maps and full-text search.

I use it when I have a pile of CSV files or a database dump and want to look through the data without setting anything up first.