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.
Free and self-hostable no-code database that turns any SQL DB into a smart spreadsheet
Modern open-source CRM built as an alternative to Salesforce
Open-source low-code platform to build internal apps and admin panels fast
AI layer for existing databases: train and query ML models with standard SQL