PostgreSQL viewer for Mac

A clear view of your PostgreSQL data.

PostgresGUI is a native PostgreSQL viewer for Mac. Connect to a local, cloud, or remote database, then browse tables, run SQL, edit rows, inspect JSON, and export results as CSV.

Download PostgresGUIView source

Table viewer

Open schemas and tables, inspect rows, sort data, and check records without writing every lookup by hand.

Query result viewer

Run SQL and keep wide results visible, then view JSON or export the result as CSV.

Mac SQL database viewer

See PostgreSQL tables, views, and values without an ORM changing names or types.

PostgresGUI showing a PostgreSQL query and its result table

See what PostgreSQL actually stored

PostgresGUI shows the schema and query result together, which makes it easier to catch a nullable column, a timestamp conversion, or a JSONB shape that looked different through the application layer.

  • Move between schemas without rewriting connection settings.
  • Sort and filter while keeping the original SQL available.
  • Inspect JSON values and export a result to CSV.
  • Edit rows when the connected role has permission.

When a PostgreSQL viewer helps

  • You want to inspect data without memorizing table names.
  • You need to debug query results visually.
  • You want a Mac-native UI for routine PostgreSQL work.
  • You use psql for terminal work but want a clearer viewer for data exploration.

Looking for a graphical interface to use alongside psql? See the psql GUI guide. Need broader administration features? Compare Postgres managers for Mac.

For broader comparisons, read the best Mac PostgreSQL GUI client guide.

Work mostly in an application framework? See the PostgreSQL client workflows for Rails, Django, Node.js, and Prisma.

Common questions

What is a PostgreSQL viewer?
A PostgreSQL viewer is a database client that connects directly to Postgres so you can browse tables, inspect rows, run queries, and read results without writing every lookup by hand.
Can I edit rows with PostgresGUI?
Yes. PostgresGUI is built for common PostgreSQL workflows including browsing data, editing rows, running SQL, viewing JSON, and exporting CSV.
Is this different from pgAdmin?
Yes. pgAdmin is a broad PostgreSQL administration platform. PostgresGUI is a focused native Mac Postgres viewer and query client for day-to-day development.