selfhost.directory

The index of self-hostable projects — ranked, categorized and served with live updates.
Own your data and stop giving it to big tech.

Datasette logo

Self-host Datasette

0.65.5

Publish SQLite data as an exploratory website and JSON API

BetaOpen SourceApache-2.0
Updatedlast month
LanguagePython
Setup difficultyEasy
Stars
11 582
Port
8001 (HTTP interface and JSON API served by `datasette serve` (changeable with -p/--port))
Docker
datasetteproject/datasette
Install with Docker
A table of browser download history rendered as a browsable Datasette table page.Table view showing facet counts and their details.Full-text search results against a table of registered interests.

What is Datasette?

Datasette alternatives

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

Datasette

PyPI Changelog Python 3.x Tests Documentation Status License docker: datasette discord

An open source multi-tool for exploring and publishing data

Datasette is a tool for exploring and publishing data. It helps people take data of any shape or size and publish that as an interactive, explorable website and accompanying API.

How to install Datasette

Install Datasette with Docker

docker run -p 8001:8001 -v pwd:/mnt
datasetteproject/datasette
datasette -p 8001 -h 0.0.0.0 /mnt/fixtures.db

Official image on Docker Hub; plugins can be baked into a derived image with pip install plus docker commit.

How to configure Datasette

  • default_page_size100Default number of rows shown on a table page.
  • sql_time_limit_ms1000Time limit for a SQL query in milliseconds, after which the query is terminated.
  • max_returned_rows1000Maximum rows returned from a table or custom query before truncation.
  • default_allow_sqlTrueWhether visitors may run arbitrary SQL queries; when off, execute-sql permission checks fail by default.

    values: on/off

  • allow_facetTrueAllow users to pick facet columns with the ?_facet= URL parameter.

    values: on/off

Datasette releases & version history

@ Every self-hosted release, weekly

One Monday email with the week's stable releases across the directory.

More in Data Management

Rate this project

Click to rate — no account needed.

0 comments

Posting as guest
Loading comments…