datasette
Tool to turn any SQLite database into an interactive website and API.
Smart Download
Visit Project Homepage
No installer available yet — head to the source repository
Instantly turn any data into an explorable website and public API, no coding required.
Core Features
- Converts SQLite DB to interactive website + RESTful API
- Export to CSV, JSON, etc.
- One-command deploy to Heroku / Google Cloud Run
- Built-in faceted search and filtering UI
- Embed license and source metadata automatically
What It Can't Do
- •SQLite not suitable for high-concurrency writes; use for read-only or low-write scenarios,Requires basic command-line familiarity,Cloud deployment needs separate account and CLI setup for Heroku/Google Cloud
Use Cases
- Journalists publish datasets for public exploration
- Museums share collection databases online
- Researchers expose experimental data via API
Detailed Introduction
Datasette is an open-source multi-tool for data exploration and publication. It converts SQLite databases (or any data you can import) into a fully interactive, explorable website with a built-in read-only JSON API. Designed for journalists, archivists, researchers, and anyone sharing data, it requires no web development skills. Features include automatic table browsing, faceted search, CSV/JSON export, metadata embedding (license, source), and one-command deployment to Heroku or Google Cloud Run. Datasette Lite runs entirely in the browser via WebAssembly for instant demos without a server.
Troubleshooting & FAQ (1)
TroubleshootingWhy can't I use SQLite functions like randomblob() in execute-sql-write statements with Datasette?
Datasette previously blocked SQLite functions in write queries for safety, but after discovering a reliable bypass (e.g., create table t(x default (hex(randomblob(4))))), the restriction was lifted. As of the resolution of issue #2751, all SQLite functions are now allowed in write SQL. Update to the latest Datasette version to use them directly; no workaround is needed.
Tags
Getting Started
Download installer
Click the button above to download the installer for your system
Install the software
Double-click the downloaded installer and follow the prompts
Step 1: Install Python 3.8+
Step 2: Run pip install datasette in terminal
Step 3: Execute datasette serve your-database.db
- Step 1: Install Python 3.8+
- Step 2: Run pip install datasette in terminal
- Step 3: Execute datasette serve your-database.db
Checksum not available
This project has not published a SHA-256 checksum on its GitHub Release page
SHA256 Checksum
No checksum available
Download directly from GitHub Releases and verify file integrity yourself
All SHA-256 checksums on this platform are extracted from the project's official GitHub Release page, without any modification. You can independently verify them on the GitHub Releases page.
Open Source Transparency
View GitHub SourceUninstall Info
Run pip uninstall datasette in terminal
No Extra Dependencies
Ready to use after download. No additional runtime required.
Having issues? Check the FAQ below
1 FAQ
Similar Projects
pocketbase
PocketBase is an open source Go backend that includes embedded SQLite with realtime subscriptions, built-in file & user management, admin dashboard UI, and simple REST API. Can be used as standalone app or Go framework.
Visual Studio Code (Code - OSS)
A free, open-source code editor by Microsoft with rich extensions, debugging, and Git integration. The most popular developer tool worldwide.
scrcpy
Display and control your Android device from your computer via USB or TCP/IP. No root required, high performance, low latency, supports audio and video mirroring.