This is an automated archive.

The original was posted on /r/selfhosted by /u/Oudwin on 2023-09-01 13:32:47+00:00.


I am looking for a simple app that takes in a connection string for a SQL DB & allows me to:

  1. Run sql queries & view the results
  2. Work with the data in a similar way to basic spreadsheets functionality. Maining, I am looking for simple ui for editing, filtering, sorting and deleting records.

There are lots of SQL visualizers. I am currently using Beekeeper. But generally speaking they only allow you to run sql queries and view the results in a visual way. The 2nd part I can´t do.

Anyone know any good tool? Preferably open source? Something like a generic SQL table app.

Edit: To be clear. This is basically because I want to be able to feed & query data from the SQLDB with code while also manually editing & deleting rows in the simplest way possible (excel like ui would be great). I have to review a lot of the DB records manually to either delete or update them and don’t want to have to write a gui for it or do it all in SQL