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
OrbStackOrbStack is a fast, light and simple way to run Docker containers and Linux machines on your Mac. It is a drop-in replacement for Docker Desktop: your docker and docker compose commands keep working, and on first start OrbStack offers to copy over your existing Docker Desktop containers, images and volumes. It starts in seconds, uses less than 0.1% background CPU on Apple Silicon and returns unused memory to macOS. Besides containers it runs full Linux machines from 16 distributions, and a lightweight Kubernetes cluster for local development. OrbStack is made by Orbital Labs.Developer Tools- RazorSQLRazorSQL is an SQL query tool, database browser, SQL editor and database administration tool from Richardson Software, LLC. It has been tested on over 40 databases and connects through JDBC or ODBC, with support for systems such as MySQL, PostgreSQL, Oracle, MS SQL Server, SQLite, MariaDB, MongoDB, Snowflake, DuckDB and Redshift. A database navigator lets you browse schemas, tables, columns, keys, views, indexes, procedures and functions, and visual tools create, alter, describe and drop these objects without writing the statements by hand. RazorSQL is also available for Windows, Linux and Solaris.Developer Tools
CorkCork is a graphical companion app for Homebrew, the popular package manager for macOS. Instead of typing commands in the Terminal, you look up formulae and casks, press Install, and Cork does the rest. You can add taps for more packages, uninstall anything you no longer need, see detailed information about packages and taps that Homebrew does not show easily, clear old caches to free up space, and start and stop Homebrew services. Cork needs Homebrew itself to be installed.Developer Tools
SerialSerial is a terminal app for connecting your Mac to just about anything: routers, switches, firewalls, servers, industrial control and IoT devices. It has built-in support for almost every USB serial adapter, from FTDI, Silicon Labs, Prolific, TI, Microchip and more, so you do not need to find and install drivers. It is also a full SSH client with an identity manager, and supports Telnet with RFC2217 remote serial port control and raw TCP sockets.Developer Tools
Cocoa Packet AnalyzerCocoa Packet Analyzer is a native Mac network protocol analyzer and packet sniffer. It captures traffic on Ethernet and Wi-Fi, dissects each packet as it arrives and shows it field by field, with more than 50 protocol analyzers. It can record which app sent or received each packet, so you see Safari or your own app rather than an anonymous connection, and an Applications window adds up packets and bytes per app while the capture runs. It reads and writes pcap and pcapng files, so you can also open traces made with other tools.Developer Tools
SharkSpaceSharkSpace, also called Shark, is a free virtual workspace manager for Mac. It creates a real folder for each workspace and mounts your project and component folders inside it with symbolic links, so Codex, Claude Code, Cursor, the terminal and other agent tools can open the whole workspace like an ordinary project. The window shows your workspaces in a sidebar, the folders of the selected workspace with their Git branch, latest tag and sync status, and the Codex sessions that belong to it.Developer Tools
FULLMAC.app does not host this app. Download buttons lead to the developer’s own pages.