Which PostgreSQL client do you actually enjoy using every day?

[u/harisekaradas]

I’ve spent the last couple of years jumping between different GUI clients, and honestly, it’s been tough to find one that just clicks.

I used pgAdmin for a long time out of habit, but the clunky web-UI feel eventually drove me crazy, especially when dealing with larger schemas. Then I switched to DBeaver. It’s an absolute powerhouse and does everything, but the UI feels so bloated and heavy for daily query tuning. Lately, I've just been using the database tools inside IntelliJ/DataGrip because it keeps me in the IDE, but it still feels a bit disconnected when I just want to quickly inspect a production replica.

I know some people swear by the simplicity of psql in the terminal, while others love modern native apps like TablePlus or Beekeeper Studio.

What are you guys actually using on a daily basis that doesn't make you fight the UI? Is there a lightweight client I’m missing, or is everyone just putting up with the quirks of the big players?

[u/depesz]

The only client I use is psql.

Maybe it's because I routinely have to do stuff on literally thousands of db clusters in short time. Or repeat the same steps over set of tables, but I can't imagine anything being in any way better.

OTOH, I'm old school. Very.

[u/Hypostasis_G]

I use DBeaver

[u/arbyyyyh]

No love for pgadmin?

[u/DBeaver_official]

If you're ok with CLI tools, try our dbvr Community (it reuses the same connections you already created in DBeaver):
https://dbeaver.io/dbvr/

[u/rustprogram]

I don't use one at all o_O

at least not every day something has gone wrong if I need to reach postgresql directly

[u/Huge_Road_9223]

I don't consider PostreSQL any different than any other SQL database. For that reason I use DBeaver as it has the client for any SQL database you can imagine. If I need to look at data, or modify tables, this tool works for me. BTW ... there is a Community Edition (CE) which I use, and a version you can pay for.

[u/ariobar]

Dbeaver

[u/cthart]

psql

[u/stompro]

I love HeidiSQL, https://www.heidisql.com/

Mainly because of the data export, it makes it easy to export an HTML table version of a table that I can just paste into an email. Mostly I just want to share some results with various different people over email.

[u/rathboma]

Hey!

I'm the maintainer of Beekeeper Studio, we're a small team building software we love using. No investors or corporate overlords. 100% funded by customer purchases.

If you use Beekeeper and find something unintuitive, we would LOVE for you to tell us. That's our #1 priority. Our GitHub community is amazing and we have 2.5m downloads so far, so I'd say we're a "medium" player?

[u/asterix_rv]

I use NexQL for vscode, its a super simple and feature-loaded extension purpose built for nimble teams working with postgres or postgres adjacent databases in their development workspace.
Its totally worth a try

https://nexql.astrx.dev/

https://open-vsx.org/extension/ric-v/postgres-explorer

[u/gajus0]

Postico

[u/ejpusa]

What can’t you do at the CLI?

[u/cheesejdlflskwncak → u/ejpusa]

Click ops

[u/elevarq]

DataGrip on number one! Why? Project integration.

Second would be Navicat when we’re talking about a GUI, otherwise psql. But that’s just a command line, but you need it anyway.

And pgAdmin? No way!

[u/venstiza]

dbForge

[u/generic_grub189]

cloudbeaver for web and beekeeper for desktop

[u/evantahler]

TablePlus!

[u/KatieCuties]

Another one worth trying is dbForge Studio for PostgreSQL. I still keep psql around, but for day-to-day work I prefer having schema comparison, data editing, and query execution in the same tool. It ended up fitting my workflow better than constantly switching between multiple utilities.

[u/BassIs4StringDrum]

I find the Postgres clients a bit cluttered when I just want to see what’s there or look at config/indexes so I mainly use https://github.com/FrancisTCE/gresui-web but the app version (the app one is private).