simonw/datasette

Health v2 · maintenance only

Adoption not part of the score

11412 stars · 901 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded

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

application · maturity active

database search-engine api-framework data-visualization cli csv data-science databases analytics developer-tools apis self-hosted python windows self-hosted cli sqlite data-publishing exploratory-data-analysis automatic-api asgi sql data-journalism plugin-ecosystem data-engineering linux macos docker web-server

Member repositories

For agents

markdown · JSON · MCP: product_card(name="simonw/datasette")