58

I'm looking for a SQLite graphical administration utility for Linux but I can't seem to find any (I found an extension for Firefox I'm not a user of that browser).

Is there any that you know of?

0

7 Answers 7

52

Tried Sqliteman? Look for sqliteman in your package manager. It is stable, so should be broadly available.

4
  • Can confirm - it's simple and effective.
    – a coder
    Sep 16, 2014 at 19:27
  • On Fedora 21 I could just run: yum install sqliteman
    – Raptor
    Jun 16, 2016 at 6:13
  • for long text fields, it's bad. Much better alternative is sqlitebrowser (see below)
    – luca76
    Mar 5, 2018 at 10:59
  • 3
    It's not actively supported anymore...
    – MarcoS
    Apr 24, 2019 at 8:13
51

I've been using sqlitebrowser, it is a really good option. Though probably not the only one!

On Ubuntu, it is available in the default package repositories.

sudo apt-get install sqlitebrowser

or as Snap package:

snap install sqlitebrowser
2
  • 1
    Thank you, SQLite Database Browser seems good too, I'll give both a try.
    – Jimmy
    May 14, 2012 at 11:19
  • Just installed. Current version is 3.12.2 released on 2021-05-18. So I added a link and install examples for Ubuntu to the answer.
    – hc_dev
    Jul 19, 2021 at 18:45
10

I've used the SQLiteStudio for working with sqlite3 database. It looks very well.

The project is maintained (as of 2018). For some reason it is not available in common packages repositories.

1
  • Downloaded to Debian 10, extracted, ran. Works. 👍 Oct 26, 2019 at 19:50
6

A friend and I made Beekeeper Studio because we wanted a modern, easy to use SQL gui client. I'm a full time Linux desktop user, so we care about Linux.

It's 100% open source! Hope someone finds it as useful as I do. Oh, it supports sqlite, MySQL, psql, etc.

enter link description here

1
  • Looks good! Did you mean to enter a link description, or just to inline the link? Mar 1 at 21:32
2

You can use for this purpose Valentina http://www.valentina-db.com/valentina-studio-overview, the program is free. It works on 3 OS: LIN, MAC, WIN. It works as with mySQL/mariaDB, so with PostgreSQL, SQLite and Valentina DB.

2
  • 2
    Welcome to Unix & Linux! Generally we like answers on the site to be able to stand on their own - Links are great, but if that link ever breaks the answer should have enough information to still be helpful. Please consider editing your answer to include more detail. See the FAQ for more info.
    – slm
    Apr 8, 2013 at 11:02
  • 3
    Just to add: free, but not open source. The pro version is $199, and adds "Report Editor, Digram Editor, SQL Diff Wizard, Query Builder". (The free version seems to have just about everything else you'd normally need, though, and working with multiple DB engines is useful.) Jul 13, 2014 at 18:58
2

I have not used this yet but looks promising especially if you're looking for a web-based interface.

phpLiteAdmin

2

You can try Sqlite Manager Firefox Add-on.

2
  • Not maintained anymore
    – smonff
    Dec 18, 2018 at 16:53
  • There indeed used to be a great Sqlite GUI as a Firefox extension with this name: SQLiteManager@mrinalkant.blogspot.com. But in 2017, FF 57 made it incompatible, and it has been abandoned. The provided link is dead now. If you try to look for it, you will end up on other FF extensions with a similar name, but which are not GUI interfaces as requested. So, unfortunately, this answer which was great in 2015 is now obsolete.
    – mivk
    Nov 7, 2021 at 16:50

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.