Datasette is a free, open-source tool by Simon Willison for exploring and publishing SQLite data as websites and APIs. See features, plugins, and pricing.
Category
Databases
Pricing
Free / Open Source, from Free
Verified
Not yet
Last updated
July 18, 2026
Founded
2017
Free PlanWeb AppAPIOpen SourceSelf-Hosted
Overview
Datasette is a free, open-source tool created by Simon Willison in 2017 that turns SQLite databases into interactive, browsable websites with a built-in JSON API, making it easy to publish and explore structured data without building a custom application.
It is written in Python, hosted on GitHub, and forms part of a broader family of tools by Willison, including sqlite-utils and the llm command-line utility.
Key Features
Every table, row, and query in Datasette gets its own stable URL and matching JSON API endpoint, with automatic links following foreign-key relationships between tables.
A plugin ecosystem of more than eighty community plugins adds authentication, full-text search, mapping, charting, and export capabilities, while Datasette Lite runs entirely in the browser via WebAssembly with no server required.
Pricing
The core Datasette tool is completely free and open source, with no licensing fees for self-hosting or publishing data.
Datasette Cloud offers a separately hosted, managed version for users who prefer not to self-host, aimed particularly at non-technical users like journalists.
Key Features
Automatic Website Generation — Instantly turns any SQLite database into a browsable, filterable, sortable website with pages for every table and row.
Built-In JSON API — Every page and query is also available as a JSON endpoint, making published data immediately machine-readable.
Custom SQL Queries — Users can run and share custom, safely sandboxed SQL queries against published datasets via shareable URLs.
Plugin Ecosystem — Over 80 community plugins add features like full-text search, mapping, charting, authentication, and data export.
Datasette Lite (WebAssembly) — A browser-only version of Datasette powered by Pyodide/WebAssembly that requires no backend server.
One-Command Publishing — Deploys databases to hosting platforms like Cloud Run, Vercel, Fly.io, or Heroku with a single command.
Foreign-Key Navigation — Automatically surfaces relationships between tables as clickable links across the published site.
Pros & Cons
Pros
Completely free and open source with no licensing cost
Extremely fast way to publish and explore structured data without building a custom app
Large plugin ecosystem extends functionality for search, mapping, and visualization
Datasette Lite allows zero-infrastructure, browser-only data exploration
Cons
Built specifically around SQLite, so it's not designed for live, high-write production databases
Best suited for read-only or slowly changing datasets rather than real-time dashboards
Smaller ecosystem and support structure compared to commercial BI tools
Self-hosting and plugin configuration require some technical comfort with Python and the command line
Pricing
Open Source Free N/A
Frequently Asked Questions
Is Datasette free?
Yes, Datasette's core tool is completely free and open source. A separately hosted Datasette Cloud service is also available for non-technical users.
Who created Datasette?
Datasette was created by Simon Willison, a co-creator of the Django web framework, starting in 2017.
What kind of data does Datasette work with?
Datasette is built around SQLite databases, letting users publish and explore SQLite-backed datasets as interactive websites and JSON APIs.
Can Datasette run without a server?
Yes, Datasette Lite runs entirely in the browser using WebAssembly and Pyodide, requiring no backend server.
Who uses Datasette?
Datasette is popular among data journalists, museum curators, archivists, civic governments, researchers, and engineers who need to publish or explore datasets quickly.
Does Datasette support plugins?
Yes, Datasette has a plugin directory with more than 80 community-built plugins covering search, mapping, charting, authentication, and more.