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 |