Postgres Client Tools

Users recommend and discuss various GUI and CLI tools for managing PostgreSQL databases, frequently comparing alternatives to pgAdmin such as DBeaver, pgcli, Postico, TablePlus, and others.

📉 Falling 0.4x Databases
1,618
Comments
19
Years Active
5
Top Authors
#7912
Topic ID

Activity Over Time

2008
8
2009
18
2010
11
2011
29
2012
60
2013
131
2014
86
2015
181
2016
94
2017
160
2018
102
2019
113
2020
126
2021
114
2022
89
2023
108
2024
113
2025
71
2026
4

Keywords

MacOs REPL pgcli.com navicat.com EOF CLI OSS TablePlus postgresapp.com tableplus.com postgres postgresql mysql tool databases database command line sql gui client

Sample Comments

samaysharma • Jan 18, 2019 • View on HN

What's the most convenient tool you've found for Postgres?

csharpminor • Jun 10, 2023 • View on HN

If you work with Postgres a lot I'd recommend Postico. It's not a necessity but I've found it to make me much more productive and worth the cost.

cdubzzz • Jun 17, 2016 • View on HN

Or perhaps use pgcli?http://pgcli.com/

dorfsmay • May 21, 2015 • View on HN

Have you tried pgAdmin: http://www.pgadmin.org/

rguldener • Sep 24, 2020 • View on HN

TablePlus is a great alternative for Postgres (and many other DBs) for that on Mac & Linux IMO: https://tableplus.com/

spapas82 • Jul 30, 2017 • View on HN

Hello - I haven't got any relation to this project but I feel that it needs to be more know to HN users because I've stumbled a lot of times on people requiring a good Postgresql Client (especially after the release of PgAdmin 4). I propose to try dbeaver. It is open source, works for other databases beyond Postgresql (but the main problem was with postgresql lacking a good client) and, imho is really great!

ClayM • Sep 30, 2016 • View on HN

I've been using JetBrains DataGrip for my postgres needs. Been pretty good.

wildpeaks • Sep 13, 2017 • View on HN

Not OSS nor free, but I've always been happy with Navicat: https://www.navicat.com/en/products/navicat-for-postgresql

Dowwie • Oct 2, 2017 • View on HN

Postgres user here. pgadmin4 lead me to try alternative clients. Recently, I've found DBeaver useful. I'd give popsql a try if it didn't require google account information.

njharman • Apr 15, 2018 • View on HN

yes but pgcli, https://www.pgcli.com/