1

I am looking for a GUI tool which lets me explore a databases.

MySQL AND postgres AND SQLite at least, if it supported others like Memcached, Redis and Mongodb would be nice.

For the relational databases, I want to:

  • See Table names
  • Show Table structures (column names and types)
  • Show Table content
  • Summary statistics (e.g. how many rows are in the table)
  • Search content
  • Execute queries myself

For Redis / memcached I would like to see the summary statistics and search for a key / see all available keys (paginated).

1
  • For which operating system? What's your budget? Please read How to Ask
    – Mawg
    Commented Feb 27, 2020 at 9:57

1 Answer 1

1

A good free multi-platform multi-DBMS GUI tool is DBeaver.

It provides all the features in your bullet list: viewing tables, seeing row counts (both estimated for multiple tables and exact values for individual tables), and running custom SQL. It even generates an ERD diagram for the database.

DBeaver supports MySQL/MariaDB, Postgres, SQLite, and others. The Enterprise Edition, which is not free, supports MongoDB and Redis, but the Community Edition does not.

1
  • Could you explain why? Links may die, so could you list some features which answer the question?
    – Mawg
    Commented Feb 27, 2020 at 9:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.