datasette
An open source multi-tool for exploring and publishing data
Decision gist · record as of 2026-08-14
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.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires Python 3.9 or higher; SQLite database file must exist and be readable.
- 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 · maintenance · safety
Apache License, Version 2.0 (permissive) — Licensed under Apache License 2.0 (permissive), allowing commercial use, modification, and distribution with minimal restrictions—suitable for most projects including proprietary applications.
last release 2026-08-06 (8 days) · last repo commit 2026-08-14 · 11,383 stars
1 known vulnerabilities (OSV.dev, 2026-08-14) · 171,402 downloads/mo, #10,368 on PyPI
Alternatives
Verify before relying
pip install datasette
datasette serve path/to/database.db
# Visit http://localhost:8001/ to explore the database interactively- 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.
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 on it.
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
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).
Requires Python 3.9 or higher; SQLite database file must exist and be readable.
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 interactivelyVerify 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
| License | Apache License, Version 2.0 permissive |
| Python support | Supports the current Python release >=3.9 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 20 packagesasgirefclickclick-default-groupJinja2hupperhttpxpluggyuvicornaiofilesjanusasgi-csrfPyYAMLmergedeepitsdangeroussetuptoolspipplatformdirstyping_extensionsflexcacheflexparser |
| Maintenance | Actively maintained 8 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 171,402 / month, #10,368 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | 1 PYSEC-2023-154 |
| Classifiers | Development Status :: 4 - BetaFramework :: DatasetteIntended Audience :: DevelopersIntended Audience :: End Users/DesktopIntended Audience :: Science/ResearchProgramming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.13Programming Language :: Python :: 3.14Programming Language :: Python :: 3.9Topic :: Database |
Evidence: datasette-0.65.3-py3-none-any.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “sqlite web interface”
- datasetteDatasette is a web server and CLI tool that transforms SQLite…
- anysqliteAnysqlite wraps SQLite with an async/await interface that works with…
- sqlite-anyioProvides an asynchronous client for SQLite that works with any async…
Give your agent the search over MCP, or paste the wish link into any chat.
More Database packages
psycopg2-binary is a PostgreSQL database adapter for Python that implements the DB API 2.0 specification, enabling Python applications to connect to and query PostgreSQL databases with thread-safe concurrent operations.
Python client library for connecting to and executing commands against Redis key-value stores, supporting both synchronous and asynchronous operations.
Install it if your application needs to interact with Redis; the only prerequisite is a running Redis server instance.
YDB Python SDK is the official client library for connecting to and querying YDB databases from Python applications.
Install it if you need to connect Python applications to YDB databases.
Connects Python applications to Snowflake data warehouses using the DB API 2.0 specification, enabling SQL queries, data transfers, and warehouse operations.
sqlparse tokenizes SQL text into a tree of statements, clauses, and expressions, and provides functions to split scripts, format queries, and inspect parsed tokens without validating dialect or syntax.
Install it if you need to manipulate, format, or analyze SQL text programmatically.
Provides base adapter protocols and shared functionality that database adapters use to integrate with dbt-core, handling connections, dialect translation, relation caching, and core interface management.
See also sqlite-utils · litecli · shillelagh · dash-table · collate-data-diff · django-sql-explorer · django-data-browser · django-heroku · dtale · shot-scraper