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/