Is there any (good) SQLite GUI for Linux?

Question

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?

score 58 · Answer 1 · edited Jul 21 '21 at 07:12

58

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

edited Jul 21 '21 at 07:12

hc_dev

129
5

answered May 14 '12 at 11:05

Huygens

8,985
3
31
36

Just installed. Current version is [3.12.2](https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/v3.12.2) released on 2021-05-18. So I added a link and install examples for Ubuntu to the answer. – hc_dev Jul 19 '21 at 18:45

score 54 · Accepted Answer · edited Feb 15 '23 at 09:27

54

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

edited Feb 15 '23 at 09:27

Nikita Kipriyanov

1,398
8
13

answered May 14 '12 at 11:02

rozcietrzewiacz

38,754
9
94
102

Can confirm - it's simple and effective. – a coder Sep 16 '14 at 19:27
On Fedora 21 I could just run: yum install sqliteman – Ahsan Jun 16 '16 at 06:13
for long text fields, it's bad. Much better alternative is sqlitebrowser (see below) – luca76 Mar 05 '18 at 10:59
4

It's not actively supported anymore... – MarcoS Apr 24 '19 at 08:13
My browser reports that sqliteman website as a security risk – Chris Grimmett Oct 06 '22 at 23:07

score 11 · Answer 3 · edited Dec 18 '18 at 19:25

11

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.

edited Dec 18 '18 at 19:25

smonff

189
8

answered Feb 05 '15 at 11:10

Al Che

111
1
2

score 9 · Answer 4 · edited Feb 15 '23 at 06:24

9

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.

edited Feb 15 '23 at 06:24

Glorfindel

805
2
10
19

answered Jul 25 '20 at 13:55

Matthew Rathbone

261
2
6

score 2 · Answer 5 · answered Oct 13 '14 at 09:44

2

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

phpLiteAdmin

answered Oct 13 '14 at 09:44

User

2,197
2
20
22

Rodriges Antonio · Answer 6 · 2013-04-08T11:33:51.810

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.

edited Apr 08 '13 at 11:33

answered Apr 08 '13 at 10:44

Rodriges Antonio

29
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](http://unix.stackexchange.com/faq) for more info. – slm Apr 08 '13 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.) – Darren Cook Jul 13 '14 at 18:58

Is there any (good) SQLite GUI for Linux?

6 Answers6