Alternative to HEIDISQL to view/edit DBs

Sharetribe Go Community Edition
1

Can marketplace operators share your current software & best practices for viewing and editing your marketplace databases for non-tech operations?

We are looking to do:

  1. View all tables, sort by some variables, filter by some columns
  2. Export all tables into csv files quickly (and possibly on a scheduler) (so that the business team can view them in Excel
  3. Change values in bulk (for example close all listings at once, or add a certain text to the end of all listings’ detailed description
    (I know the Rails console is the best way but we are looking for a way that is not too scary for the business team to handle)

Currently we are using HEIDISQL, I can do 1 quite OK. 2 and 3 it does not seem possible.

Any alternatives?

I have heard of myPHPAdmin. How is it? I heard that it is not too secured? How about MYSQLWorkbench?

Thanks guys!