Datasette
Datasette is an open-source tool for exploring and publishing data. It turns data in SQLite and other supported sources into an interactive website and JSON API, helping people analyze, share and publish findings.
At a Glance
- Data journalists and newsrooms
- Museum curators and archivists
- Local governments and open-data teams
- Scientists and researchers
- +2 more
AI Tools by Datasette
(1)datasette-agent
Datasette LLM Chat Assistant Plugin
Discussions
No discussions yet
Be the first to start a discussion about Datasette
Latest News
Datasette 0.65.5 and 1.0a40 security releases fixed a table-permissions bypass; 1.0a40 also added plugin background tasks.
Datasette 1.0a39 and 0.65.4 security releases announced.
Datasette 1.0a41 released with OpenTelemetry support and a new JavaScript modal API.
Datasette Apps launched for hosting custom HTML applications inside Datasette.
Products & Services
Open-source multi-tool for exploring and publishing data, with browsable HTML interfaces, URL-driven queries and JSON APIs for SQLite databases.
Browser-based version of Datasette compiled to WebAssembly through Pyodide; explores SQLite files hosted on CORS-enabled static hosting without a server.
SaaS hosting platform for Datasette with private team spaces, secure data collaboration, imports, editing, APIs and selective publishing.
Plugin framework for enriching selected rows with custom code, including workflows such as geocoding and processing text or images with GPT-4.
Market Position
Datasette positions itself as an open-source, SQLite-native alternative to building a bespoke data portal or API: it combines exploration, SQL, publishing and APIs in one deployable tool, with a plugin ecosystem and browser-only option. Its differentiation is read-only immutable SQLite serving, URL-driven APIs and a workflow aimed at journalists, researchers and public-data publishers rather than a general transactional application backend.
Leadership
Founders
Simon Willison
Creator and lead developer of Datasette; independent open-source developer focused on data journalism, SQLite and Python. Previously engineering director at Eventbrite after Eventbrite acquired Lanyrd, which he co-founded in 2010; also co-created the Django web framework.
Executive Team
Simon Willison
Creator and lead developer
Independent open-source developer building tools for data journalism around Datasette and SQLite; former Eventbrite engineering director, Lanyrd co-founder and Django co-creator.
Founding Story
Simon Willison announced Datasette's first public version on November 13, 2017 as a tool for instantly creating and publishing JSON APIs for SQLite databases. The initial vision was to make it easy to explore and share data, including data-journalism datasets, without building a custom application; the first examples used FiveThirtyEight and ParlGov data.
Business Model
Revenue Model
The core Datasette software is open source and self-hostable. The ecosystem's commercial model includes hosted SaaS through Datasette Cloud and sponsorship/support of Simon Willison's open-source work; Datasette Cloud was explicitly created so teams could pay for hosted collaboration and support sustainable development.
Target Markets
- Data journalists and newsrooms
- Museum curators and archivists
- Local governments and open-data teams
- Scientists and researchers
- Companies and organizations analyzing or publishing structured data
- Developers building SQLite-backed APIs and data applications
- Exploratory data analysis
- Instant data publishing and public data portals
- Rapid prototyping of JSON APIs
- Data journalism and newsroom collaboration
- Museum, archive and cultural-heritage collections
- Local government and open-data publishing
- FiveThirtyEight datasets
- ParlGov political-party database
- ScotRail
- Stable Diffusion training-data exploration