simonw/datasette — reverse-engineered prompt

Build me an open source Python tool for turning SQLite database files into a simple website that anyone can explore. I want to point it at a database from the command line, start a local web server, then browse tables, search and filter rows, view record pages, and download or query the same data through a JSON API.

Make it useful for journalists, researchers, archivists, local governments, and other people who need to publish data without building a custom app. Let me add a small metadata file with the title, source, license, and links, and show that information on the site and in the API.

It should be easy to install, easy to run locally, and possible to package with the database for deployment to services like Heroku or Google Cloud Run using Docker. Include clear docs, sensible defaults, and tests. Look up current docs online if you need to.