# simonw/datasette

An open source multi-tool for exploring and publishing data

Repository: https://github.com/simonw/datasette
Canonical: https://ross.abutalabs.com/products/datasette
Homepage: https://datasette.io
Language: Python
License: Apache-2.0
License Family: permissive
Topics: sqlite, python, datasets, json, docker, datasette, automatic-api, asgi, csv, datasette-io, sql
Last push: 2026-08-14T00:11:42+00:00

## Health v2 (maintenance only)
Score: 86/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 97, release rhythm 64, longevity 100
- inputs: {"age_days": 3237, "days_push": 20, "days_rel": 27, "gap_med": 274, "n_releases_24m": 4}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 11412, forks 901 (observed 2026-08-28T04:10:46.949091+00:00)

## What it is
Datasette is an open-source tool for exploring and publishing data, turning SQLite databases into interactive websites with an accompanying JSON API. It includes a CLI for serving, importing, and publishing data, plus a large plugin ecosystem.

## Use cases
- publish a sqlite database as an interactive website
- spin up a JSON API for a CSV file in minutes
- explore and query a large dataset with SQL in the browser
- share data findings with colleagues or the public
- prototype a data backend without writing code
- export query results as CSV or JSON
- host annotated data explorations for journalism or research

## When to choose
- you have SQLite databases or CSV/JSON data you want to explore or publish
- you need a quick read-only JSON API over structured data
- you are a data journalist, researcher, or archivist sharing datasets
- you want a plugin-extensible data exploration UI without building a backend

## When to avoid
- you need a full multi-user write-heavy web application
- your data lives in a non-SQLite production database as the primary store
- you need fine-grained application-level business logic beyond SQL queries
- you require real-time streaming or high-write transactional workloads

## Facets
- artifact type: application
- maturity: active
- function: database, search-engine, api-framework, data-visualization, cli, csv
- domain: data-science, databases, analytics, developer-tools, apis, self-hosted
- platform: python, windows, self-hosted, cli
- tags: sqlite, data-publishing, exploratory-data-analysis, automatic-api, asgi, sql, data-journalism, plugin-ecosystem, data-engineering, linux, macos, docker, web-server

## Member repositories
- simonw/datasette (main) score 86

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:10:46.949091+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-29T17:15:36.820357+00:00, confidence not recorded.
  - readme: https://github.com/simonw/datasette (fetched 2026-08-28T04:10:46.949091+00:00, sha 301b76fb1aaf)
  - homepage: https://datasette.io (fetched 2026-08-29T08:14:27.277108+00:00, sha 93659d42fe83)
  - site_page: https://docs.datasette.io/en/latest/changelog.html (fetched 2026-08-29T08:14:27.289029+00:00, sha f2f3787fed82)
  - site_page: https://docs.datasette.io/en/stable (fetched 2026-08-29T08:14:27.280662+00:00, sha 8dcf53dbeeb4)
  - site_page: https://docs.datasette.io/en/stable/changelog.html (fetched 2026-08-29T08:14:27.282887+00:00, sha d10e7b470447)
  - registry_pypi: https://pypi.org/pypi/datasette/json (fetched 2026-08-29T08:14:27.297084+00:00, sha e0113b547053)
- Data as of 2026-08-30T08:39:29.467469+00:00.