What PostgreSQL client do you use?

Question

There are seemingly a plethora of clients for Postgres [1].What client(s) do HN use day-to-day? Why have you chosen it?I'm looking for recommendations to use for light usage. Ideally, something that would help build the schema visually.[1] https://wiki.postgresql.org/wiki/PostgreSQL_Clients

OJFord · Accepted Answer

DBeaver.It suffers from 'oh God this was definitely written in Java, wasn't it', but it's mostly good.Then I happened across pgAdmin recently which probably does everything I want from DBeaver, and has a docker image (it's browser based) but I haven't really tried it properly. Keep meaning to though, I have a hopeful feeling that it'd be 100% what I recommended if I had.

zippoxer · Answer

TablePlus - Love it! Cross-platform without Electron and yet still pretty. They got UX right, it's minimal yet powerful enough for me.

kmstout · Answer

psql. It's installed everywhere I need to use it, it reads from stdin, and it writes to stdout. It's often the case that I want to take a SQL query that I've developed, generalize it a bit, and use something like psql OPTIONS

atonse · Answer

I use and love Postico. But I do very basic stuff (SQL, DDL, editing rows, etc)

evo_9 · Answer

MS added PostgresSQL support to their excellent cross platform dB tool Azure Data Studio:https://azure.microsoft.com/en-us/blog/azure-data-studio-an-...

nsxwolf · Answer

I use the database tool built into IntelliJ. It&rsquo;s amazing. It&rsquo;s available as a stand-alone product named DataGrip.

aarpmcgee · Answer

Postico seems to be heavily optimized for the 80% of what I need in a postgres tool. I love it.

oliwarner · Answer

Django.It's not the answer you thought you were looking for, but it's a bloody good framework for modelling data, reporting, and also scripting things around it.

nickreese · Answer

For visual schema building the best I&rsquo;ve found is pgmodeler. It is buggy and isn&rsquo;t really a client but it is great at modeling, viewing schemas in a model, and overall making sense of how complex data connects.Edit: For day-to-day I use Postico but am playing with beekeeper as soon as JSON and JSONB support are figured out.

oftenwrong · Answer

pgcli https://www.pgcli.com/

pella · Answer

For PostGIS / Spatial data#1. DBeaver: Working with spatial/GIS datahttps://dbeaver.com/docs/wiki/Working-with-Spatial-GIS-data/#2. pgAdmin4: now offers PostGIS geometry viewerhttps://www.bostongis.com/blog/index.php?/archives/272-pgAdm...---------Any other?

rgoulter · Answer

I'd guess in your case ("light usage"), just choose one of the open-source GUI clients would be best. Probably DBeaver.
Here's the decision-tree I'd go with:
Do you want to pay money for it? If not, use a free or open source one.
Are you comfortable with running SQL commands from the command line? If not, go for a GUI one.
This leaves "OS-specific or cross platform" (which should be straightforward to resolve), and "desktop client or web interface". I'd expect a desktop client to be easier to setup.

alexandernst · Answer

Navicat , it has everything I can ask from a RDBMS client (it even supports NoSQL!), from days transfer, database diffing, scheme reversing, advanced DBA related tasks...

soheilpro · Answer

My very own pgcmd [1]. I usually pipe the output to jq [2] or catj [3] for further processing.
[1] https://github.com/soheilpro/pgcmd
[2] https://stedolan.github.io/jq
[3] https://github.com/soheilpro/catj

wolfgang000 · Answer

dbeaver It's really good and surprisingly lightweight considering it's java app.

rboyd · Answer

Most of these comments don't seem to cover what you're asking for, which was building the schema visually.SQLEditor (https://www.malcolmhardie.com/sqleditor/) is quite good if you're on OS X. It'll generate entire schema or migration since last save.

tomashertus · Answer

I'm using pgAdmin4 and I'm super happy with that. For the day-to-day tasks it's a great tool!

pvsukale3 · Answer

PGWeb : https://github.com/sosedoff/pgweb Web-based PostgreSQL database browser written in Go.very lite and minimal.

yen223 · Answer

Psql when I want to do anything programmaticTablePlus when I want to do data exploration.I've heard good things from colleagues about JetBrain's DataGrip, but I haven't given it a fair go.

dataminded · Answer

I've been using aquadata for years. It's been a fairly good time.I have started to transition more of my work to datagrip because I use pycharm and it's right there.

sheeshkebab · Answer

postico is great

dahdum · Answer

I used Aqua Data Studio for years until they changed to $500/yr license. Tried using DataGrip but couldn't used to it, now I just use pgAdmin4.

goldfix · Answer

I suggest: https://www.sql-workbench.eu/lightweight and JDBC compatible

bsg75 · Answer

DbVisualizer has been my main SQL &ldquo;IDE&rdquo; for years. https://www.dbvis.com

nhumrich · Answer

Datagrip. I love the tight integration with PyCharm.

pavelevst · Answer

https://github.com/Paxa/postbird

Insanity · Answer

PgAdmin but I've not really looked around, it's the one I used when I learned postgres and stuck with it.

ahsd1 · Answer

Valentine studio rocks. Free ver is sufficient.

1ark · Answer

Valentina Studio does the job for me.

brightball · Answer

DBeaver

iamthelord · Answer

Can&rsquo;t live without postico

alphabettsy · Answer

Postico and Pgweb

turrini · Answer

psql and dbeaver

hexyoungs · Answer

pgcli

KristiMKE · Answer

1. pgAdmin 2. DBeaver 3. Navicat 4. DataGrip 5. OmniDBThis article breaks down the pros and cons, features, and pricing for each of the top PostgreSQL GUI tools: https://scalegrid.io/blog/which-is-the-best-postgresql-gui-2...

What PostgreSQL client do you use?

There are seemingly a plethora of clients for Postgres [1].
What client(s) do HN use day-to-day? Why have you chosen it?
I'm looking for recommendations to use for light usage. Ideally, something that would help build the schema visually.
[1] https://wiki.postgresql.org/wiki/PostgreSQL_Clients

TablePlus - Love it! Cross-platform without Electron and yet still pretty. They got UX right, it's minimal yet powerful enough for me.

psql. It's installed everywhere I need to use it, it reads from stdin, and it writes to stdout. It's often the case that I want to take a SQL query that I've developed, generalize it a bit, and use something like
`psql OPTIONS <`
`in a shell script (probably wrapped in a function for convenience).`

I use and love Postico. But I do very basic stuff (SQL, DDL, editing rows, etc)

MS added PostgresSQL support to their excellent cross platform dB tool Azure Data Studio:
https://azure.microsoft.com/en-us/blog/azure-data-studio-an-...

I use the database tool built into IntelliJ. It’s amazing. It’s available as a stand-alone product named DataGrip.

Postico seems to be heavily optimized for the 80% of what I need in a postgres tool. I love it.

Django.
It's not the answer you thought you were looking for, but it's a bloody good framework for modelling data, reporting, and also scripting things around it.

pgcli https://www.pgcli.com/

For PostGIS / Spatial data
#1. DBeaver: Working with spatial/GIS data
https://dbeaver.com/docs/wiki/Working-with-Spatial-GIS-data/
#2. pgAdmin4: now offers PostGIS geometry viewer
https://www.bostongis.com/blog/index.php?/archives/272-pgAdm...
---------
Any other?

Navicat , it has everything I can ask from a RDBMS client (it even supports NoSQL!), from days transfer, database diffing, scheme reversing, advanced DBA related tasks...

My very own pgcmd [1]. I usually pipe the output to jq [2] or catj [3] for further processing.
[1] https://github.com/soheilpro/pgcmd
[2] https://stedolan.github.io/jq
[3] https://github.com/soheilpro/catj

dbeaver It's really good and surprisingly lightweight considering it's java app.

Most of these comments don't seem to cover what you're asking for, which was building the schema visually.
SQLEditor (https://www.malcolmhardie.com/sqleditor/) is quite good if you're on OS X. It'll generate entire schema or migration since last save.

I'm using pgAdmin4 and I'm super happy with that. For the day-to-day tasks it's a great tool!

PGWeb : https://github.com/sosedoff/pgweb Web-based PostgreSQL database browser written in Go.
very lite and minimal.

Psql when I want to do anything programmatic
TablePlus when I want to do data exploration.
I've heard good things from colleagues about JetBrain's DataGrip, but I haven't given it a fair go.

I've been using aquadata for years. It's been a fairly good time.
I have started to transition more of my work to datagrip because I use pycharm and it's right there.

postico is great

I used Aqua Data Studio for years until they changed to $500/yr license. Tried using DataGrip but couldn't used to it, now I just use pgAdmin4.

I suggest: https://www.sql-workbench.eu/
lightweight and JDBC compatible

DbVisualizer has been my main SQL “IDE” for years. https://www.dbvis.com

Datagrip. I love the tight integration with PyCharm.

https://github.com/Paxa/postbird

PgAdmin but I've not really looked around, it's the one I used when I learned postgres and stuck with it.

Valentine studio rocks. Free ver is sufficient.

Valentina Studio does the job for me.

DBeaver

Can’t live without postico

Postico and Pgweb

psql and dbeaver

pgcli

1. pgAdmin 2. DBeaver 3. Navicat 4. DataGrip 5. OmniDB
This article breaks down the pros and cons, features, and pricing for each of the top PostgreSQL GUI tools: https://scalegrid.io/blog/which-is-the-best-postgresql-gui-2...

What PostgreSQL client do you use?

There are seemingly a plethora of clients for Postgres [1].What client(s) do HN use day-to-day? Why have you chosen it?I'm looking for recommendations to use for light usage. Ideally, something that would help build the schema visually.[1] https://wiki.postgresql.org/wiki/PostgreSQL_Clients

TablePlus - Love it! Cross-platform without Electron and yet still pretty. They got UX right, it's minimal yet powerful enough for me.

psql. It's installed everywhere I need to use it, it reads from stdin, and it writes to stdout. It's often the case that I want to take a SQL query that I've developed, generalize it a bit, and use something like psql OPTIONS < in a shell script (probably wrapped in a function for convenience).

I use and love Postico. But I do very basic stuff (SQL, DDL, editing rows, etc)

MS added PostgresSQL support to their excellent cross platform dB tool Azure Data Studio:https://azure.microsoft.com/en-us/blog/azure-data-studio-an-...

I use the database tool built into IntelliJ. It’s amazing. It’s available as a stand-alone product named DataGrip.

Postico seems to be heavily optimized for the 80% of what I need in a postgres tool. I love it.

Django.It's not the answer you thought you were looking for, but it's a bloody good framework for modelling data, reporting, and also scripting things around it.

pgcli https://www.pgcli.com/

For PostGIS / Spatial data#1. DBeaver: Working with spatial/GIS datahttps://dbeaver.com/docs/wiki/Working-with-Spatial-GIS-data/#2. pgAdmin4: now offers PostGIS geometry viewerhttps://www.bostongis.com/blog/index.php?/archives/272-pgAdm...---------Any other?

Navicat , it has everything I can ask from a RDBMS client (it even supports NoSQL!), from days transfer, database diffing, scheme reversing, advanced DBA related tasks...

My very own pgcmd [1]. I usually pipe the output to jq [2] or catj [3] for further processing.[1] https://github.com/soheilpro/pgcmd[2] https://stedolan.github.io/jq[3] https://github.com/soheilpro/catj

dbeaver It's really good and surprisingly lightweight considering it's java app.

Most of these comments don't seem to cover what you're asking for, which was building the schema visually.SQLEditor (https://www.malcolmhardie.com/sqleditor/) is quite good if you're on OS X. It'll generate entire schema or migration since last save.

I'm using pgAdmin4 and I'm super happy with that. For the day-to-day tasks it's a great tool!

PGWeb : https://github.com/sosedoff/pgweb Web-based PostgreSQL database browser written in Go.very lite and minimal.

Psql when I want to do anything programmaticTablePlus when I want to do data exploration.I've heard good things from colleagues about JetBrain's DataGrip, but I haven't given it a fair go.

I've been using aquadata for years. It's been a fairly good time.I have started to transition more of my work to datagrip because I use pycharm and it's right there.

postico is great

I used Aqua Data Studio for years until they changed to $500/yr license. Tried using DataGrip but couldn't used to it, now I just use pgAdmin4.

I suggest: https://www.sql-workbench.eu/lightweight and JDBC compatible

DbVisualizer has been my main SQL “IDE” for years. https://www.dbvis.com

Datagrip. I love the tight integration with PyCharm.

https://github.com/Paxa/postbird

PgAdmin but I've not really looked around, it's the one I used when I learned postgres and stuck with it.

Valentine studio rocks. Free ver is sufficient.

Valentina Studio does the job for me.

DBeaver

Can’t live without postico

Postico and Pgweb

psql and dbeaver

pgcli

1. pgAdmin 2. DBeaver 3. Navicat 4. DataGrip 5. OmniDBThis article breaks down the pros and cons, features, and pricing for each of the top PostgreSQL GUI tools: https://scalegrid.io/blog/which-is-the-best-postgresql-gui-2...

There are seemingly a plethora of clients for Postgres [1].
What client(s) do HN use day-to-day? Why have you chosen it?
I'm looking for recommendations to use for light usage. Ideally, something that would help build the schema visually.
[1] https://wiki.postgresql.org/wiki/PostgreSQL_Clients

psql. It's installed everywhere I need to use it, it reads from stdin, and it writes to stdout. It's often the case that I want to take a SQL query that I've developed, generalize it a bit, and use something like
`psql OPTIONS <`
`in a shell script (probably wrapped in a function for convenience).`

MS added PostgresSQL support to their excellent cross platform dB tool Azure Data Studio:
https://azure.microsoft.com/en-us/blog/azure-data-studio-an-...

Django.
It's not the answer you thought you were looking for, but it's a bloody good framework for modelling data, reporting, and also scripting things around it.

For PostGIS / Spatial data
#1. DBeaver: Working with spatial/GIS data
https://dbeaver.com/docs/wiki/Working-with-Spatial-GIS-data/
#2. pgAdmin4: now offers PostGIS geometry viewer
https://www.bostongis.com/blog/index.php?/archives/272-pgAdm...
---------
Any other?

My very own pgcmd [1]. I usually pipe the output to jq [2] or catj [3] for further processing.
[1] https://github.com/soheilpro/pgcmd
[2] https://stedolan.github.io/jq
[3] https://github.com/soheilpro/catj

Most of these comments don't seem to cover what you're asking for, which was building the schema visually.
SQLEditor (https://www.malcolmhardie.com/sqleditor/) is quite good if you're on OS X. It'll generate entire schema or migration since last save.

PGWeb : https://github.com/sosedoff/pgweb Web-based PostgreSQL database browser written in Go.
very lite and minimal.

Psql when I want to do anything programmatic
TablePlus when I want to do data exploration.
I've heard good things from colleagues about JetBrain's DataGrip, but I haven't given it a fair go.

I've been using aquadata for years. It's been a fairly good time.
I have started to transition more of my work to datagrip because I use pycharm and it's right there.

I suggest: https://www.sql-workbench.eu/
lightweight and JDBC compatible

1. pgAdmin 2. DBeaver 3. Navicat 4. DataGrip 5. OmniDB
This article breaks down the pros and cons, features, and pricing for each of the top PostgreSQL GUI tools: https://scalegrid.io/blog/which-is-the-best-postgresql-gui-2...