datasette

What it is and what it does

Datasette is a command-line tool and web application framework that serves SQLite databases as interactive websites with built-in REST APIs. It eliminates the need to write custom web code: point it at a database file, and it automatically generates a browsable interface with search, filtering, and sorting, plus JSON endpoints for programmatic access. The tool is built on modern Python async infrastructure (uvicorn, asgiref) and includes templating (Jinja2), form handling (itsdangerous), and plugin support (pluggy).

It's designed for data journalists, researchers, archivists, and anyone publishing datasets—from CSV uploads to complex multi-table databases. Datasette can also publish databases to cloud platforms (Heroku, Google Cloud Run) via Docker, and offers a browser-based WebAssembly version (Datasette Lite) for client-side exploration. The project is actively developed, supports Python 3.9 through 3.14, and has a permissive Apache 2.0 license.

Use it for:

• Publish a CSV or SQLite database as a searchable, filterable website with zero custom backend code.
• Create a read-only REST API from an existing database for third-party integrations or data journalism.
• Deploy a data exploration interface to the cloud with a single command for sharing datasets with stakeholders.
• Build interactive dashboards for archival or museum collections without writing HTML or JavaScript.
• Analyze local application data (e.g., browser history, logs) through a web interface without manual SQL queries.

Worth the install?

AI-flagged interpretation of the facts on this page — verify before relying

Datasette is a web server and CLI tool that transforms SQLite databases into interactive, queryable websites with a REST API, designed for exploring and publishing data without writing custom code.

Yes. Datasette is worth installing if you need to quickly publish or explore SQLite data as a web interface or API. It is actively maintained, has low install friction, carries a permissive license, and solves a real problem for data sharing and exploration. One known vulnerability (PYSEC-2023-154) exists; verify its severity and whether a patch is available before deploying to production.

Install

datasette on PyPI

pip install datasette

uv add datasette

poetry add datasette

Installing datasette

Before you install

Installation is straightforward with low friction—a pure Python wheel with no compiled dependencies. The project is actively maintained with recent releases and strong community engagement (11383 GitHub stars), though it carries 20 runtime dependencies including web frameworks (uvicorn, asgiref) and utilities (click, Jinja2, PyYAML).

License in practice

Licensed under Apache License 2.0 (permissive), allowing commercial use, modification, and distribution with minimal restrictions—suitable for most projects including proprietary applications.

Quickstart

pip install datasette
datasette serve path/to/database.db
# Visit http://localhost:8001/ to explore the database interactively

Requires Python 3.9 or higher; SQLite database file must exist and be readable.

Verify before relying

• Performance characteristics and scalability limits for large databases are not documented in the fact sheet.
• Details on plugin/extension ecosystem and customization capabilities beyond the core tool.
• Specific remediation status and impact of PYSEC-2023-154 vulnerability.

Package facts

Evidence: datasette-0.65.3-py3-none-any.whl

Tags

More Database packages