Postico 2 for MAC

Native Mac app for PostgreSQL with a table editor, multi-file SQL editor and function editor, with a free evaluation version and a paid licence.

Postico 2 Overview

Postico 2 is a native Mac app for PostgreSQL databases. Click a table in the sidebar and its data appears at once; you can add, edit and filter rows, pick foreign keys from a list and see a row's details in a sidebar. A graphical structure editor creates and changes tables, with columns, indexes and constraints in one editor, and you can view the structure as raw SQL. The new query editor keeps SQL in files that you organize into folders, open in several tabs or windows and edit in other editors too, and it formats queries with the built-in pgFormatter.

Postico 2 is made by Jakob Egger (Egger Apps). Besides PostgreSQL it supports Amazon Redshift, Greenplum and CockroachDB; some databases such as Vertica work only in a limited way. Connections can be filtered, organized into nested groups and synced through iCloud or Dropbox, and the app updates silently in the background. Postico 2 is a paid app: the downloadable evaluation version has no time limit, but some features are disabled until you buy a licence, and it is a paid upgrade from Postico 1. It is also sold on the Mac App Store. Version 2.3.5 fixes Postico getting stuck at Loading Catalog Information. The app needs macOS 14 or later; older versions are offered for older Macs.

Key Features

Postico 2 is built for people who work with data every day.

  • Table browser: open a table and see its data instantly.
  • Data editing: add, edit and filter rows with a foreign key picker.
  • Structure editor: change columns, indexes and constraints in one place.
  • Multi-file query editor: organize SQL files into folders and tabs.
  • SQL formatting: auto-format queries with the built-in pgFormatter.
  • Function editor: edit functions and stored procedures.
  • Connection groups: filter servers and sort them into nested groups.
  • Compatible databases: PostgreSQL, Amazon Redshift, Greenplum and CockroachDB.

What’s New in Version 2.3.5

Postico 2.3.5 is a bug fix release.

  • Fixes Postico getting stuck at Loading Catalog Information

Postico 2 FAQ

Is Postico 2 free?

No. Postico 2 is a paid app. The evaluation version you can download has no time limit, but some features are disabled until you buy a licence.

Which macOS version does Postico 2 need?

Postico 2 needs macOS 14 or later. Older versions of Postico can be downloaded for older Macs.

Which databases does Postico 2 support?

PostgreSQL, plus Amazon Redshift, Greenplum and CockroachDB. Some databases such as Vertica work only in a limited way: you can run SQL, but other features do not work.

Is Postico 2 a free upgrade from Postico 1?

No. Postico 2 is a paid upgrade. If you bought a Postico 1 licence, you can use all functions of Postico 2 in a development build.

Is Postico 2 on the Mac App Store?

Yes. There are a few minor differences between the Mac App Store version and the direct download version.

Can Postico 2 edit table structure?

Yes. Its structure editor creates and changes tables, with columns, indexes and constraints in a single editor, and can show the structure as SQL.

Can Postico 2 format SQL queries?

Yes. Press Ctrl-F in the query editor to format a query with the built-in pgFormatter.

Can I sync my connection settings?

Yes. Postico 2 can sync server settings with iCloud or Dropbox.

What is new in Postico 2.3.5?

It fixes an issue where Postico got stuck at Loading Catalog Information.

Where does the Postico 2 download on postico.FULLMAC.app come from?

The download button leads to the official Postico 2 page at https://eggerapps.at/postico2/. postico.FULLMAC.app does not change or repackage the app.

Similar Apps

FULLMAC.app does not host this app. Download buttons lead to the developer’s own pages.