This is a well known concept sometimes called a SQL editor. There's definitely a need for a great implementation of the concept though. There was a really good

This is a well known concept sometimes called a SQL editor. There's definitely a need for a great implementation of the concept though. There was a really good one called Wagon years ago that of course got bricked after the team was acquired and I still haven't liked any that I have tried since. The emphasis on editing production here is a bit odd since there is a lot of value that can be delivered read-only to analysts or to editing development for developers. I have a war story about editing production with one of these tools. Someone used such an editor to edit a MongoDB database value. The ORM schema said it was a float, but it was entered as an int. This somehow broke production for a lot of users. SQL editors * PopSQL * TeamSQL * DataGrip * https://www.beekeeperstudio.io CLI tools * [usql](https://github.com/xo/usql/releases) * [dbcli](http://www.dbcli.com/)