3.4.8: SQL Clients


We may have found that using psql to monitor DB changes can be tedious, because we need to run a query with raw SQL each time we wish to check our data.
SQL clients provide graphical user interfaces for us to monitor our data with clicks instead of typing queries. The SQL clients translate our clicks into queries under the hood, and typically we can also customise those queries if we need to.
There are many SQL clients to choose from, but Rocket recommends pgAdmin for Windows and Postico for Mac, both of which are free.


  1. 1.
    Launch Ubuntu in Windows.
  2. 2.
    Start postgres in Ubuntu terminal: sudo service postgresql
  3. 3.
    Download the latest pgAdmin and install in Windows.
  4. 4.
    Launch pgAdmin, a new tab in browser opens;
  5. 5.
    Click on Add New Server link.
  6. 6.
    In the popup Create - Server window in the browser: General tab: set Name to localhost
  7. 7.
    Connection tab: set Host name/address to
  8. 8.
    Set Password to postgres, which is the default
  9. 9.
    Click on Save password.


Download, install, and open Postico.


If we prefer a different interface we can try other Postgres SQL clients. They generally behave the same but with different user interfaces.