Datasette is a free, open-source Mac application that turns any SQLite database into a browsable, queryable web interface running entirely on your local machine — no cloud subscription, no terminal skills required.
What is Datasette?
Datasette is a data exploration and publishing tool built around SQLite. Open the Mac desktop app, drag in a .db or .sqlite file, and you instantly get a local web interface with faceted filtering, full-text search, and an ad-hoc SQL query editor — all accessible from any browser tab on your machine. The project was created by Simon Willison, co-creator of Django, and has grown into a rich open-source ecosystem with dozens of plugins covering visualisation, data export, and deeper analysis.
The desktop edition packages the Datasette server into a native Mac experience so you skip the usual setup ceremony. No Terminal window, no Python virtual environment to juggle, no memorising which port you last used — the app handles all of that silently in the background while you focus on the data itself.
What does Datasette do best?
Datasette's strongest suit is making structured data genuinely explorable without writing a dashboard from scratch. Drop in a SQLite export from Airtable, a public dataset from a government data portal, or a local database you assembled with DB Browser for SQLite, and you immediately get sortable tables, instant column-level facets, and a live SQL console where you can sketch joins and aggregations without touching any other tool.
I use it regularly for journalist-style data investigations — when a CSV has grown too wide for Numbers or too sluggish for a spreadsheet, converting it to SQLite and opening it in Datasette gives me a queryable interface in under a minute. The column facets are especially satisfying: click any value and the entire view filters down immediately, which is exactly how you hunt anomalies in messy data.
- Instant faceted browsing on any column, with zero configuration
- Live SQL editor that runs against the open database in real time
- Full-text search across any text column, powered by SQLite FTS
- Plugin ecosystem for charts, maps, CSV export, and much more
- Read-only by default — your source file is never silently mutated
Is Datasette free?
Yes — completely. Datasette Desktop is free to download and use, and the underlying project is open source under the Apache 2.0 licence. There are no in-app purchases, no premium tier, and no usage caps. Simon Willison funds the project through GitHub Sponsors and consulting work; using the app costs you nothing at all.
Who should use Datasette?
Datasette is a near-perfect fit for data journalists, researchers, analysts, and developers who regularly work with SQLite files or need a quick way to interrogate tabular exports. If you find yourself reaching for LibreOffice Base or a clunky web viewer just to inspect a database, Datasette is a far more capable replacement.
It is equally useful for developers who maintain SQLite-backed apps and want a visual way to inspect production snapshots without firing up a custom script. Power users who deploy the full Datasette server to publish data publicly will also want the desktop app as their local preview environment before pushing anything live.
Where Datasette struggles is as a general-purpose database GUI. It does not connect to PostgreSQL, MySQL, or any remote engine — SQLite is the only database it speaks. If your data lives in Postgres, you will want TablePlus or Postico instead.
What are the best Datasette alternatives?
For SQLite specifically, DB Browser for SQLite is the most widely recommended free alternative — it adds row editing and schema management that Datasette deliberately omits. TablePlus covers SQLite alongside Postgres, MySQL, and Redis in a polished native GUI, though it is a paid app beyond its free connection limit. Beekeeper Studio occupies a similar multi-engine slot with a genuinely usable free community edition.
If your goal shifts from local exploration to data publishing, the full Datasette server deployed on a VPS or a platform like Fly.io is the natural evolution from the desktop app — you get public URLs, JSON and CSV API endpoints, and plugin-powered visualisations available to anyone with a browser.
