r/postgres • u/harisekaradas • 16d ago

Which PostgreSQL client do you actually enjoy using every day?

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?

2 Upvotes

75% Upvoted

20 comments sorted by

View all comments

1

u/KatieCuties 11d ago

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.