Deploy Datasette
Explore and publish SQLite data as a website and JSON API, with login
Datasette
Just deployed
/data
Deploy and Host Datasette on Railway
Datasette is an open-source tool for exploring and publishing data. Point it at SQLite databases and it gives you browsable tables, faceted filters, full-text search, a SQL console, and a JSON and CSV API for every table and query, with no front-end code. It is maintained by Simon Willison under the Apache 2.0 licence.
About Hosting Datasette
This template runs one Datasette service built from a public GitHub repository that pins the official datasetteproject/datasette:0.65.6 image by digest and adds password login, CSV and database upload, schema editing, write queries and a map plugin. Every SQLite file lives on a Railway volume at /data, so data survives redeploys and restarts. The admin password and the cookie-signing secret are generated at deploy time, and the instance is private until you choose to open it. A /healthz route checks each database. There is nothing to fill in: deploy, open the URL, sign in.
Common Use Cases
- Publish an open dataset as a searchable website with a JSON and CSV API
- Give colleagues a private, read-and-query window onto an exported database
- Load a large CSV and explore it with facets and SQL before building anything
Dependencies for Datasette Hosting
- One Datasette service (Python, built from the template repository)
- A Railway volume at
/datafor the SQLite databases
Deployment Dependencies
- Datasette: https://github.com/simonw/datasette
- Documentation: https://docs.datasette.io
- Template repository: https://github.com/aalfath/datasette-railway-template
Implementation Details
Services: Datasette serves the web UI, the JSON/CSV API and /healthz; the volume at /data holds every *.db file, which is attached writable at start.
After deploy:
- Open the public URL; you are sent to the login page.
- Sign in as
root(theADMIN_USERNAMEvariable) with theADMIN_PASSWORDvalue from the service's Variables tab. - Use the menu at the top right: Upload CSVs imports into the
datadatabase, Upload database adds a whole.dbfile. Both appear without a restart.
Optional settings you can add as variables: DATASETTE_PUBLIC=1 lets anonymous visitors browse and query (uploads, schema edits and writes stay admin-only), DATASETTE_TITLE sets the page title.
Runs in 0.5 GB RAM and 1 vCPU (about 50 MB idle in our test). A start with a missing password or secret exits with an error so Railway restarts it.
Updates: the service builds from the template repository. When a new Datasette or plugin version is merged there, Railway shows an "update available" notice on your service and you choose when to apply it; read the repository's CHANGELOG.md first. Your databases stay on the volume.
Why Deploy Datasette on Railway?
Railway is a singular platform to deploy your infrastructure stack. Railway will host your infrastructure so you don't have to deal with configuration, while allowing you to vertically and horizontally scale it.
By deploying Datasette on Railway, you are one step closer to supporting a complete full-stack application with minimal burden. Host your servers, databases, AI agents, and more on Railway.
Template Content
Datasette
aalfath/datasette-railway-template
