I\'m looking for a general-purpose, open-source, graphical user interface databa

Question

I'm looking for a general-purpose, open-source, graphical user interface database management and manipulation application for Linux. I've been using Navicat Premium Essentials on my Mac, and am in search for a similar Linux tool.

Requirements:

open-source/Linux support, preferably in default Debian repository
broad DBMS support (PostgreSQL, MySQL, MariaDB are mandatory; MS SQL Server and Oracle nice to have)
remote connection capability with SSH tunnels
viewing and altering data in tables
query editor with some syntax highlighting

UML/ER-diagram (or similar graphical representation) export would be nice to have, but not mandatory.

There is quite a bunch of similar questions on Stack Overflow and Server Fault, but they all got closed some years ago for being off-topic and thus not rather up to date ([1], [2], [3], [4], [5], ...).

Explanation / Answer

The only thing that springs to mind here is LibreOffice Base, in terms of multi-database support. It's free and open source, available in all (as far as I'm aware) Linux repos, has a query editor, and you can view and edit tables and data.

The only thing I am unsure of here is SSH tunnelling - it certainly can connect to remote databases, but I've only ever tinkered with that through ODBC and JDBC rather than via SSH. My instinct here is that it would be possible, but not without some modification. One method I can see would be to mount your settings in an SSHFS (SSH filesystem - using Fuse) or NFS connecting to the server with your databases.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.