Deploy Datasette

Explore and publish SQLite data as a website and JSON API, with login

Deploy Datasette

/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 /data for the SQLite databases

Deployment Dependencies

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:

  1. Open the public URL; you are sent to the login page.
  2. Sign in as root (the ADMIN_USERNAME variable) with the ADMIN_PASSWORD value from the service's Variables tab.
  3. Use the menu at the top right: Upload CSVs imports into the data database, Upload database adds a whole .db file. 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

More templates in this category

View Template
Plausible WordPress
Cookie-free WordPress stats from your own Plausible

onepush
0
View Template
Typesense Multilingual
Locale-aware multilingual search with Typesense

onepush
0
View Template
Formbricks
Surveys, NPS and in-app feedback on your own Postgres, Hub and Cube

Two Workspaces
3