Self-host Datasette
0.65.5Publish SQLite data as an exploratory website and JSON API
- Stars
- 11 582
- Port
- 8001 (HTTP interface and JSON API served by `datasette serve` (changeable with -p/--port))
datasetteproject/datasetteWhat is Datasette?
Datasette is an Apache-2.0 tool for data journalists, archivists, museum curators, researchers and local government staff who want to put structured data online: point it at SQLite files and it builds a browsable website with a matching JSON API. Visitors need no login to explore the data or run read-only SQL; tables come with faceted value counts, sorting, suggested facets, SQLite full-text search boxes, expanded foreign-key labels and CSV or JSON downloads of any table, view or query. Several databases can be served from one process, either passed on the command line or dropped into a configuration directory where metadata.json (or YAML), settings.json, templates, plugins and static files are picked up automatically.
Access control uses an actor model plus "allow" blocks in metadata.json, so an instance, a database, a single table, a view or a named canned query can each be restricted, and arbitrary SQL can be disabled globally. Human authentication is left to plugins; only a local root account ships with the core. The project's own site lists 154 plugins and 44 companion tools, and the 1.0 alpha line adds SQL write queries with stored queries, an extensible "jump to" menu, background tasks and OpenTelemetry traces and metrics, while the 0.65.x stable branch continues to receive security releases.
For self-hosting there is a pip/pipx install, a Homebrew formula, a packaged Mac app and an official Docker image; the docs show systemd and OpenRC service files plus nginx and Apache proxy setups, and datasette publish can build a container and push it to Heroku or Google Cloud Run in one command. The default server port is 8001, and the pip route needs Python 3.11 or newer.
Datasette alternatives
datalineSelf-hosted, open-source AI tool to chat with data and generate SQL, charts, reports — supports PostgreSQL, MySQL, Snowflake, SQLite, CSV, Excel.Comparedataline with Datasette
DataverseDataverse is a self-hosted, open-source research data repository with DOI support, versioning, and rich metadata for sharing and preserving datasets.CompareDataverse with Datasette
ToolJetSelf-hosted, open-source low-code platform for internal tools and dashboards: visual builder, 90+ data sources, built-in database, AI app generation and MCP agent access.CompareToolJet with Datasette
nocodbSelf-hosted open-source Airtable alternative that turns any database into a no-code platform with spreadsheet-like interface, supporting PostgreSQL, MySQL, and SQLite.Comparenocodb with Datasette
databendSelf-hosted, open-source data warehouse in Rust for large-scale analytics plus vector and full-text search, with Python UDF sandboxes and git-like data branching.Comparedatabend with Datasette
DaptinAn open-source, self-hosted application server: model your data once and Daptin serves JSON:API and GraphQL endpoints, users, permissions, files, jobs and realtime.CompareDaptin with Datasette
prefectPrefect is a self-hosted, open-source workflow orchestration framework turning Python functions into production data pipelines with scheduling, retries, and caching.Compareprefect with Datasette
open-sparrowOpenSparrow is a self-hosted, open-source PHP platform generating CRUD apps, dashboards, calendars from JSON schema on PostgreSQL. Includes RAG, workflows, Kanban, 2FA.Compareopen-sparrow with Datasette
Should you self-host Datasette?
Datasette scores 74/100 on selfhost.directory (how scoring works) and ranks #3 of 10 in Data Management. It has 11 582 GitHub stars, +72 in the last 30 days.
It shipped 22 stable releases in the past year. The latest, 1.0a42, came out on 8 November 2026. New versions land roughly every 8 days.
Setup is easy: most people get it running in one sitting. An official Docker image is available. It is Apache-2.0-licensed and written mostly in Python.
Its closest alternative on selfhost.directory is OpenBB (87/100, 75 396 stars). It scores higher overall, so compare the two before you pick. See Datasette vs OpenBB side by side.
Features
- Canned queries
- CORS Support
- CSV Export
- Custom Templates
- Faceted filtering
- Fine-grained permissions
- Full-Text Search
- Geospatial support (SpatiaLite)
- HTTP cache control
- JSON API
- One-command cloud publishing
- OpenTelemetry traces and metricsAdded in the 1.0 alpha series (1.0a41), not the 0.65.x stable releases.
- Plugin System
- SQL query interface
- Write queries and stored queriesIntroduced in Datasette 1.0a31, i.e. only in the 1.0 alpha series.
Datasette README
More in Data Management
DataverseDataverse is a self-hosted, open-source research data repository with DOI support, versioning, and rich metadata for sharing and preserving datasets.
diskoverDiskover Community Edition is a self-hosted, open-source file indexer using Elasticsearch to catalog metadata, enabling search, analytics, and cost optimization.
DreamFactoryDreamFactory is a self-hosted, open-source platform that instantly generates secure REST APIs from any database with RBAC, SSO, and MCP server for AI integration.
elasticsearchOpen-source distributed search engine that handles structured, unstructured, and vector data for real-time search, observability, and AI workloads.
farmOSSelf-hosted, open-source farm record keeping web app built on Drupal: map fields, track assets and logs, collect sensor data, and use a JSON:API.
fleetbaseOpen-source logistics operating system for dispatch, fleet tracking, warehouse operations and finance. Self-host on your infrastructure with Docker Compose.
Form.ioSelf-hosted, open-source form and API platform with drag-and-drop builder, REST APIs, MongoDB backend, and enterprise features like PDF generation and RBAC.
GarageHQGarage is a lightweight, self-hostable, and geo-distributed S3-compatible object storage system designed for high resilience and simplicity.
GibbonSelf-hosted, open-source school platform for K-12: student records, lesson planner, timetable, attendance, markbook, admissions and messaging on PHP and MySQL.
graphite-webA highly scalable real-time graphing system
GristA self-hosted, open-source relational spreadsheet with database-style columns, Python formulas, row-level access rules, forms and drag-and-drop dashboards.
HindsightOpen-source agent memory server with retain, recall and reflect APIs, a web control plane and a built-in MCP endpoint; self-hosted via Docker, pip or Helm.



0 comments