Datasette by cloudimg | SQLite Data Explorer and API

This is a repackaged open source software product wherein additional charges apply for cloudimg support services.

Datasette is an open source multi-tool for exploring and publishing data. It takes one or more SQLite databases and instantly publishes them as a browsable, searchable web interface with a faceted UI and a full JSON API over every table and query. This AMI delivers Datasette fully installed and running as a system service, so a working data explorer is serving within minutes of launch - no manual configuration, no dependency management, no custom code.

Deploying Datasette yourself means installing Python, managing virtual environments, configuring a reverse proxy, setting up authentication, and writing systemd units. This image handles all of that out of the box:

• Zero-setup deployment - Launch the instance and your data explorer is live on port 80
• Production-grade service management - systemd starts Datasette on boot and restarts it on failure automatically
• Built-in authentication - nginx reverse proxy with HTTP Basic auth protects your data from the first request
• Resizable storage - SQLite databases live on a dedicated data disk you can expand independently of the root volume
• No shared credentials - A unique admin password is generated per instance on first boot

• Datasette installed into a dedicated Python virtual environment under /opt/datasette
• Run by an unprivileged service account for defense in depth
• Served databases directory on a dedicated, independently resizable data disk
• systemd service with automatic restart on failure
• nginx reverse proxy publishing the interface on port 80 behind HTTP Basic authentication

A demo SQLite database ships at /var/lib/datasette/demo.db with sample tables and rows. The interface is populated out of the box so you can immediately browse tables, run filters, drill into facets, and call the JSON API. Copy your own .db files into the data directory and restart the service to publish them.

On first boot, a one-shot service generates a fresh admin password unique to that instance, writes it into the nginx credentials file, and stores the password in a root-only file. The Datasette process binds to loopback only and is never exposed without authentication. No shared or default credentials ship in the image.

• Government open data teams publishing budget, procurement, or geographic datasets for citizen access with a browsable interface and downloadable JSON
• Research labs sharing experiment results or datasets with collaborators as a queryable, reproducible site
• Data engineers on small teams who need an instant browsable interface and JSON API over SQLite databases without building a custom front end
• Internal data catalogues and reporting dashboards for teams that want self-serve data exploration
• Reproducible data publishing where analysts share the results of a data analysis as a queryable site

24/7 technical support by email and live chat. Our engineers help with deployment, loading your own databases, enabling plugins, configuring faceting and full-text search, the JSON API, TLS setup, and authentication configuration.

Launch the AMI, retrieve your unique admin password from the root-only credentials file, and start exploring the demo database immediately. When you are ready to publish your own data, copy your SQLite files to the data directory and restart the service. For a guided setup or help planning your deployment, contact cloudimg support.

All product and company names are trademarks or registered trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.