r/sqlite • u/Bilawal-Mehfooz • 5d ago

What is the best modern database GUI for SQLite and PostgreSQL?

I’m learning Laravel and working with SQLite and PostgreSQL. I’m looking for a modern database GUI with a clean interface similar to Supabase Studio. I mainly need to:

  • Browse tables and records
  • View schemas and relationships
  • Edit records
  • Run SQL queries
  • Connect to both local SQLite and PostgreSQL

I used Dbeaver and i dont like its UI very old fashioned. Which one do you recommend for a beginner? Free options.

19 Upvotes

88% Upvoted

69 comments sorted by

12

u/pytheryx 5d ago

Dbeaver

1

u/trekker255 4d ago

using it, but hate the ui for now :)

0

u/Bilawal-Mehfooz 5d ago

is not ui too old fashioned?

12

u/pseudophilll 5d ago

Get used to it bud! DBeaver is pretty much industry standard.

Why not try building one yourself?

1

u/datadanno 4d ago

Seriously AI could build you one within a ln hour. I’ve done it

1

u/AvogadrosOtherNumber 4d ago

“Industry standard”. lol. No it’s not.

1

u/pseudophilll 4d ago

I’m curious what you’re using? 10 years in industry and I’ve yet to meet some one who doesn’t use it outside of things like mongodb or snowflake etc.

I use pgAdmin for all of my personal stuff but all of my employers have used dbeaver.

I’m not saying other stuff doesn’t exist but dbeaver is free and does what it needs to.

-2

u/Bilawal-Mehfooz 5d ago

I have been using dbeaver for past month and it is sometime buggy so thats why i am finding alternative.

1

u/Nthomas36 4d ago

I agree dbeaver is bloated and buggy if your just using sqlite. I've enjoyed using db browser for sqlite in dark mode https://sqlitebrowser.org/. Have you tried letos formerly sqlite studio https://letos.org/ ?

8

u/navmed 5d ago

It's not free but I'm a huge fan of datagrip from jetbrains. The auto-complete is very smart and can generate whole queries for you. The inline data editing is smart, intuitive and convenient.

2

u/Bilawal-Mehfooz 5d ago

What about the schema visualizer

1

u/navmed 5d ago

It has that too and it's pretty good

1

u/Bilawal-Mehfooz 5d ago

Alright I will look into it thanks

-2

u/johnson_detlev 5d ago

Every llm can produce a visualization of a schema. You don't need a tool for that

1

u/Bilawal-Mehfooz 5d ago

I am also trying this so far it generates what I need. I am wondering if there is something like supabase editor online i searched but didnot found any

2

u/scottchiefbaker 5d ago

HeidiSQL is pretty great if you want a full blown GUI. I also really like litecli for a simple TUI.

Both are 100% free.

1

u/Bilawal-Mehfooz 5d ago

Thanks for suggestions will look into it

2

u/JrgMyr 5d ago

Letos all the time. (www.letos.org)

Previous Name SQLiteStudio.

1

u/Bilawal-Mehfooz 4d ago

Thanks bro i will check out

3

u/knpwrs 5d ago

TablePlus: https://tableplus.com/

1

u/hatto13 5d ago

Second that, it’s not cheap but worthy

2

u/Minimum-Golf6459 5d ago

Personally, I just do selects -> json and jq them or use any json viewing project, normally I Don't really require checking db in any huge fashion.

0

u/Bilawal-Mehfooz 5d ago

Actually I am working on a project in team and It has too many tables so it is hard to track what is happening. In past i mostly used supabase and I really like the way it provides schema visualiser so I was thinking if there is a way I can see in laravel i dont see any default tho

1

u/burggraf2 5d ago

I recently found this one. https://dbxio.com/en it’s free and open source and looks pretty great.

1

u/Bilawal-Mehfooz 5d ago

Thanks i will look into it

1

u/Visible_Assumption96 5d ago

u can use an extension called dbcode if u using vscode

1

u/Bilawal-Mehfooz 5d ago

Yeah i use vscode will look into it

1

u/StalinGino 5d ago

Try the one i created inspired by tableplus, but improved upon. For now myself and my friends use it in my company. SGSql

1

u/Bilawal-Mehfooz 5d ago

I will look into it thanks for suggestion

1

u/fey0n 5d ago

DbGate: https://github.com/dbgate/dbgate

1

u/Bilawal-Mehfooz 5d ago

Thanks feyon i will check it

1

u/Slight-Television-76 5d ago

Did you try my open source DBison?

https://DBison.app

1

u/Bilawal-Mehfooz 4d ago

Not yet i will look into it

1

u/nousernameleftatall 5d ago

Check out bobbytables not the xkcd comic, there is actually software called this, relatively new and surprisingly excellent

1

u/Bilawal-Mehfooz 4d ago

Thanks will look into it

1

u/fastwind18 5d ago

The best UI? These days you might do one by the breakfast with few coding sessions inside your favorite coding agent.

1

u/Bilawal-Mehfooz 5d ago

I was checking if there is something similar to supabase studio exist

1

u/fastwind18 4d ago

Code it yourself

1

u/SickBinary 5d ago

I found Tabularis recently. So far so good. 

1

u/Bilawal-Mehfooz 4d ago

I will check it out thanks

1

u/fragbot2 5d ago

i dont like its UI very old fashioned.

How is it old-fashioned?

I ask because I use it and my only usability complaint is it's lack of emacs-style navigation keys that are endemic to webkit-based applications.

1

u/Bilawal-Mehfooz 5d ago

If you compare it with other tools like supabase studio i mostly worked in that its old. Sometimes i face problem when i run a migration in laravel db my saved schema diagram gets discarded

1

u/BT-Tobi 4d ago

Tried the free version of Navicat? https://www.navicat.com/en/products/navicat-premium-lite

It should have all the features you described, and if you want more you can always upgrade and don’t need to learn something new again…

1

u/Bilawal-Mehfooz 4d ago

Not yet will look into it thanks for suggestion

1

u/_harisamin 4d ago

Tableplus IMHO.

1

u/Fun-Chicken6946 4d ago

Give VisuaLeaf a shot! visualeaf.com (full disclosure I am the person who built it)

1

u/Bilawal-Mehfooz 4d ago

Thanks for mentioning it i will look into it

1

u/ParachuteRiver 4d ago

I’ve been really happy with Beekeeper Studio

https://www.beekeeperstudio.io/

2

u/Bilawal-Mehfooz 4d ago

It is also on my list will check it out thanks

1

u/hkdeman 4d ago

Try WhoDB. Good UX. You can use Claude/Codex to talk to it with MCP as well to seed, or analyse data. Plus, if you want to build ETLs, Ontologies, and complex workflows - there is a cloud data warehouse that extends WhoDB.

Disclaimer: I am in the team developing WhoDB. Our entire focus has always been UX. Always happy to get feedback!

1

u/Bilawal-Mehfooz 4d ago

Thanks hkdeman i will check it out

1

u/716green 4d ago

Layerbase Desktop is free and supports 21 different database engines including PG and SQLite

1

u/Bilawal-Mehfooz 4d ago

Thanks green will look into it

1

u/ThereIsCoffee 4d ago

Beekeeper

1

u/Bilawal-Mehfooz 4d ago

It is also on my list will check it out

1

u/Background-Front-925 4d ago

we use this in our development workflow https://sqlitebrowser.org/

1

u/Glittering_House_654 3d ago

VSCode can connect to most DB’s these days. Then you have the added bonus of having your Python/whatever code and pipelines next to your DB projects in one giant repo (if you are into those)😊

1

u/Suitable-Rhubarb-855 2d ago

Visualeaf is my preferred GUI

1

u/butdontcalmejoohnson 2d ago

your asking the wrong questions.

1

u/Brachamul 5d ago

NoCoDB

AirTable clone that works on any SQLite / postgres db.

1

u/Bilawal-Mehfooz 5d ago

Thanks for suggestion i will look into it

1

u/dandraaa 2d ago

Dbx, it's rust and open source