There was a recent thread on the PostgreSQL general mailing list asking for GUI tools for PostgreSQL. This is question we get asked often at customers so I though it might be good idea to summarize some of them in a blog post. When you know other tools than the ones listed here which look promising, let me know so I can add them. There is a list of tools in the PostgreSQL Wiki as well.
Name | Linux | Windows | MacOS | Free | Screenshot |
pgAdmin | Y | Y | Y | Y | ![]() |
DBeaver | Y | Y | Y | Y | ![]() |
EMS SQL Manager for PostgreSQL | N | Y | N | N | ![]() |
JET BRAINS DataCrip | Y | Y | Y | N | ![]() |
PostgreSQL Studio | Y | Y | Y | Y | ![]() |
Navicat for PostgreSQL | Y | Y | Y | N | ![]() |
execute Query | Y | Y | Y | Y | ![]() |
SQuirreL SQL Client | Y | Y | Y | Y | ![]() |
pgModeler | Y | Y | Y | Y | ![]() |
DbSchema | Y | Y | Y | N | ![]() |
Oracle SQL Developer | Y | Y | Y | Y | ![]() |
PostgreSQL Maestro | N | Y | N | N | ![]() |
SQL workbench | Y | Y | Y | Y | ![]() |
Nucleon Database Master | N | Y | N | N | ![]() |
Razor SQL | Y | Y | Y | N | ![]() |
Database Workbench | N | Y | N | N | ![]() |