Datasette: Instant Data Exploration and Publishing Tool
Datasette turns SQLite data from CSVs/JSON into interactive websites and JSON APIs, enabling quick analysis, sharing, and prototyping without custom backends—backed by 44 tools and 154 plugins.
Transform Any Data into Explorables and APIs
Load CSVs, JSON, or database files into SQLite and instantly get a faceted, searchable web interface plus JSON API endpoints. Patterns emerge automatically: filter/sort by facets, expand foreign keys into linked pages, and export subsets via CSV/SQL. Publish with datasette publish to Heroku, Vercel, or Cloud Run in one command—no servers needed. Demo: explore 33,000 global power plants at datasette.io/global-power-plants/global-power-plants, revealing distributions by country/fuel without code.
Trade-offs: Excels for read-heavy sharing (journalists, scientists, governments) but alphas introduce breaking changes like metadata shifts or permission overhauls—check upgrade guides. Desktop app runs locally on macOS for offline prototyping.
Accelerate Workflows: Analysis, Prototyping, Enrichment
For exploratory data analysis, import data and share live views with colleagues—faceted search surfaces outliers fast. Prototype APIs in minutes: spin up /-/rows, /-/facet, /-/upsert endpoints for any table, proving ideas before full backends. Recent alphas add column_types (e.g., url, email, json) for custom rendering/validation—plugins like datasette-files leverage this for smarter displays.
Enrichments run custom code per row (e.g., GPT-4 geocoding/images), comments enable collaboration, write-ui adds insert/edit/delete. New CSRF uses Sec-Fetch-Site/Origin headers (no tokens needed, modern-browser only). Rename tables trigger RenameTableEvent for plugin reactions; actor= param tests permissions.
Ecosystem Powers Productivity
154 plugins extend facets (e.g., GraphQL, Atom feeds, gzip), 44 companion tools handle extraction/indexing. Alphas target 1.0: SQL permissions, transaction wrappers, file uploads via request.form(files=True), mobile column actions, startup hooks post-metadata. Security fixes patched open redirects/exposed privates—always upgrade. Newsletter tracks monthly progress; Discord/Mastodon for community.