D
Datasette
Datasette is an open-source tool for exploring and publishing data as interactive web pages and APIs.
About Datasette
Datasette turns SQLite databases into explorable web interfaces. You point it at a database file and it generates a read-only JSON API plus a browsable HTML frontend with faceted search, filtering, and sorting. It handles CSV, JSON, and other formats by importing them into SQLite first. The tool is written in Python and runs on any platform with Python 3.8 or later.
Datasette supports plugins for authentication, visualization, and custom metadata. It can publish databases to cloud platforms like Vercel, Heroku, or Fly.io with a single command. The built-in SQL query editor lets you run arbitrary SQL against your data, with results available as JSON, CSV, or HTML. It also generates per-row pages and supports full-text search via SQLite FTS.
Created by Simon Willison, Datasette is released under the Apache 2.0 license. It is ideal for data journalists, archivists, and anyone who needs to share structured data without building a custom web app. The project has a strong community with dozens of plugins and a growing ecosystem of related tools like Datasette Lite and sqlite-utils.
Datasette supports plugins for authentication, visualization, and custom metadata. It can publish databases to cloud platforms like Vercel, Heroku, or Fly.io with a single command. The built-in SQL query editor lets you run arbitrary SQL against your data, with results available as JSON, CSV, or HTML. It also generates per-row pages and supports full-text search via SQLite FTS.
Created by Simon Willison, Datasette is released under the Apache 2.0 license. It is ideal for data journalists, archivists, and anyone who needs to share structured data without building a custom web app. The project has a strong community with dozens of plugins and a growing ecosystem of related tools like Datasette Lite and sqlite-utils.
Database
Quick Facts
- Pricing
- Free
- License
- Open Source
- Platform
- Any Platform
- Version
- 0.64.6
- Developer
- Simon Willison