Hacker News Reader

DBeaver can also open/manage SQLite databases. I use it daily (although on a tiny page).

Ah, my point was more on how to connect to the live database on some remote server.

DBeaver can connect to remote sqlite databases through an SSH tunnel:

https://dbeaver.com/docs/dbeaver/Database-driver-SQLite/#rem...

Connect to the remote server and run it?

If your app is a web app you could create a rudimental page with SQL input and table output and authorize only admins. It's risky, if someone gets access to admin account they can drop everything. I have something like this for logs, app reads log files directly and they are accessible only via private domain (tailscale), if I connect to public domain I can't access logs. Additionally you could enable only SELECT statements via web.

Another downside is that it will take time to make it look nice.

sqlite-web, put it behind nginx with basic auth or configure a password.