Overview
Datasette is a Python tool for exploring, publishing, and sharing SQLite databases through an auto-generated web interface. It supports faceted search, CSV/JSON export, and a rich plugin ecosystem for charting and authentication. Databases can be published as static sites or served live. Deploy with a single pip install or a Docker container, optionally pushing to cloud providers with datasette publish.
Where it falls short of Airtable
- SQLite-only; no native support for PostgreSQL or MySQL without third-party plugins
- Read-oriented by default; data editing requires plugins and extra configuration
- No spreadsheet-style formula engine or pivot tables like Google Sheets
- Multi-user collaboration and permissions are minimal without plugins
We list the gaps honestly so you can decide if the trade-off is worth owning your data.
Tags
Claim this listing to keep it accurate, add a deploy template, or feature it on relevant pages.
Embed the Datasette difficulty badge in your README — it links back here.
[](https://openreplace.com/datasette)Similar open-source projects
Other self-hostable tools in the same space worth comparing.
Open-source Firebase alternative built on PostgreSQL with realtime and auth
Free and self-hostable no-code database that turns any SQL DB into a smart spreadsheet
Single-file open-source backend: SQLite database, auth, file storage, realtime
Modern open-source CRM built as an alternative to Salesforce