Postico is a database client. Postico can connect to a local PostgreSQL server running on your Mac, or to remote servers running on a different computer. If you want to install a local PostgreSQL server on your Mac, I recommend Postgres.app.
I've designed Postico to be easy to use for newcomers and specialists alike. If you run into any problems at all, or have suggestions for improvements, feel free to contact me at any time via email: firstname.lastname@example.org