There are programs like sqlitebrowser that let you view databases as tables and edit them in a convenient way. But I can't encounter a similar program for linux console. I have a server that I can access via SSH, and having a convenient database browser for Linux console would be beneficial to me.

Is there such a program offering terminal-compatible "graphical" UI? It could be based on e.g. curses/ncurses/unicurses.

Example for another database engine/OS: enter image description here

  • 3
    What's wrong with the sqlite3 executable – or, put into other words, what features do you need it doesn't offer? I could think of e.g. ncurses support or the like (to provide a kind of GUI – see e.g. SQLite Commander), but I cannot tell what you've got in mind :) – Izzy Feb 25 '16 at 15:32
  • 1
    @Izzy well, basically, I was looking for something that could be based on curses/ncurses/unicurses. I'll take a look at this SQLite Commander, it might be just what I need. – Highstaker Feb 25 '16 at 20:23
  • Good luck! And don't forget letting us know of the outcome ;) – Izzy Feb 25 '16 at 20:49

Check the sqlectron. It comes both in GUI and in Term version.

Also there is sqlcrush.

| improve this answer | |

The SQLite package includes the sqlite3 command-line client, which appears to offer equivalent functionality to mysql (MySQL), psql (PostgreSQL) or sqlplus (Oracle). I don't see that it supports network connection, but that is really outside the intended use-case for SQLite and is unnecessary if you have SSH access to the server.

| improve this answer | |
  • Unfortunate timing, but apparently the asker is looking for something curses-based, I edited the question for clarity. – Nicolas Raoul Feb 26 '16 at 9:41
  • 1
    The problem is that sqlite3 is based on typing commands, not "console GUI", so to say. I want something where I can navigate my table with arrow keys, press enter to edit an entry, etc. – Highstaker Feb 26 '16 at 14:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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