Postico
GUI client for PostgreSQL databases
Install with Homebrew
brew install --cask posticoQuick Take: Postico
In August 2026, Postico 2 is still the native Mac PostgreSQL client to beat when you care about daily editing speed more than multi-engine breadth. Personal $69, Commercial $99/device, and Team $799 are straightforward perpetual prices against SaaS database tools. PostgresGUI competes on sticker price; TablePlus and DataGrip compete on scope. Choose Postico when PostgreSQL (or Redshift / Cockroach / Greenplum) is home base and you want Mac-native tools with multi-file SQL and a function editor. Choose something else when you need ER diagrams, five database families in one window, or JetBrains-level refactoring.
Best For
- •Mac developers working primarily with PostgreSQL
- •Data analysts using Amazon Redshift or CockroachDB
- •Database administrators who want native performance and nested connection hygiene
- •Buyers who prefer a perpetual license over another subscription
What is Postico 2?
Postico 2 is a native macOS PostgreSQL client from Egger Apps, built by independent developer Jakob Egger. As of August 2026 it is still actively maintained and sold. It is not a multi-engine browser that treats every database the same. It is a Mac-first GUI for PostgreSQL and PostgreSQL-compatible systems: Amazon Redshift, CockroachDB, and Greenplum, with limited support where SQL still works (for example Vertica). The app requires macOS 14 (Sonoma) or later. That bar lets it use current Apple frameworks while staying small. If you are on macOS 10.10 through 13, Egger still publishes Postico 1.x on the legacy downloads page. Postico 2 is a ground-up rebuild of Postico 1.x and the earlier PG Commander line. The practical upgrades you notice day to day: a multi-file query editor with folders, built-in SQL formatting through pgFormatter, a native function editor for stored procedures, nested server groups, iCloud or Dropbox sync for connection settings, startup queries on connect, and silent background updates so you are not pestered mid-query. Pricing is perpetual rather than SaaS: Personal is $69 / €62 (VAT included) for one person on up to three devices, Student $29 / €27 for one device, Commercial $99 / €90 per device, and Team $799 / €730 for up to ten devices. There is a free evaluation with no time limit, though some features stay locked until you buy. Who it is for: Mac developers, analysts, and DBAs who live in PostgreSQL and want a client that launches quickly, edits rows without ceremony, and does not drag a JVM along for the ride. Who should look elsewhere: people who need MySQL, Redis, or MongoDB in the same app (TablePlus or DBeaver), people who need heavy SQL refactoring and diagrams (DataGrip), or people who only want the absolute cheapest native GUI (newer options such as PostgresGUI around $12.99). Postico wins when PostgreSQL is home base and Mac fit matters more than engine breadth.
Closer look: design choices and what they buy you
Postico is a deliberate bet on depth over breadth and native Mac craft over cross-platform sameness. That bet shows up every time you open the app for a two-minute check and it is ready before your coffee cools. History matters for trust. Jakob Egger built Postico after PG Commander to close the gap between psql and heavy Java GUIs. Postico 1.x earned a reputation for simple, reliable daily use. Postico 2 is a full rebuild after years of iteration, not a skin on the old code. The company is independent and not venture-funded, which is why you still see perpetual pricing and a focus on UX over growth gimmicks. Architecture is native. AppKit drives the UI, Core Data holds local state, and libpq speaks PostgreSQL directly. Launch times stay low, scrolling large result sets stays smooth, and macOS features work without a translation layer: iCloud, Keychain, system dark mode. Memory use is typically under 100MB with multiple connections, which is why analysts keep it open next to notebooks without drama. Specialization is the product. Because Postico does not chase every engine, the function editor can understand PL/pgSQL, the structure editor can speak PostgreSQL constraint types, and completion can lean on Postgres system catalogs. A universal JDBC client will always be broader and usually shallower. Buying advice for 2026: if PostgreSQL (or Redshift / Cockroach / Greenplum) is most of your week and you want a Mac-native perpetual license, Postico is still easy to justify. If you need diagrams, multi-engine breadth, or JetBrains-grade refactoring, pair it with DBeaver or DataGrip, or switch. Evaluate multi-file SQL, function editing, and silent updates hands-on; those workflows are the real differentiators, not a feature checklist.
Key Features
Multi-File Query Editor
Postico 2's SQL editor treats queries as files you can keep, not disposable console scrap. Create SQL files, group them into folders in the sidebar, open the same file in more than one tab or window, and rely on automatic saving so a crash does not eat your work. Drag external .sql files into the sidebar, or edit those files in VS Code, Sublime Text, or Nova while Postico keeps them in view. pgFormatter is built in: press Ctrl+F to reformat and keep house style consistent across a shared query library. This is the workflow difference people notice after a week of diagnostic scripts and migration drafts.
Data Entry and Table Browsing
Click a table in the sidebar to open its rows. Filter without writing a WHERE clause when you are just exploring. The foreign key picker jumps related tables without hand-written JOINs. A row detail sidebar opens wide fields and awkward rows. Double-click a cell to edit; Postico respects types, constraints, and validation so invalid values fail early instead of after a bad commit. It feels closer to a careful spreadsheet than to a form builder, which is what you want for spot fixes and sample data checks.
Visual Table Structure Editor
Create and alter tables in a graphical structure view that shows columns, indexes, and constraints together. Add columns, change types, set defaults, and manage constraints without memorizing every ALTER TABLE variant. A raw SQL DDL view shows the generated statements so advanced users can audit or copy the exact change before it runs. That bridge between visual design and real DDL is useful when juniors draft schema and seniors review the SQL.
Native Function and Procedure Editor
Postico 2 ships a dedicated editor for PostgreSQL functions and stored procedures. You get syntax highlighting, structure navigation, and change tracking for database-side code without bouncing to a separate editor for every PL/pgSQL tweak. View definitions, adjust parameters and return types, and keep table, query, and function work in one Mac window. Teams that still maintain migration and ETL logic in the database use this more than the marketing pages suggest.
Advanced Connection Management
Connections scale from one local Postgres to large production inventories. Nested groups keep servers organized by environment or region. Filters keep a long sidebar usable. Sync connection settings across Macs with iCloud or Dropbox. Startup queries run automatically on connect: set default_transaction_read_only, fix search_path for multi-tenant schemas, or establish session logging. SSH tunnels are configured on the connection itself so you do not keep a separate terminal session for every bastion hop.
PostgreSQL-Compatible Database Support
First-class targets include PostgreSQL itself plus Amazon Redshift for warehouses, CockroachDB for distributed deployments, and Greenplum for analytics. Limited support exists where SQL execution still works, including Vertica. The trade-off is explicit: Postico will not pretend to be a universal client for MySQL or MongoDB. If your week is all Postgres-family engines, that focus pays off in type handling and tooling depth.
Silent Background Updates
Updates download and install in the background without modal dialogs or forced restarts mid-session. You can stay on stable releases for production machines or opt into development builds for earlier features. Existing license holders can reach development builds through update preferences or the Egger Apps releases page. The design goal is simple: the database client should not be the thing interrupting your maintenance window.
Who Should Use Postico?
1The Full-Stack Developer
A Rails developer keeps Postico open beside the editor all day. Connections sit in groups for local, staging, and production, color-coded so a tired evening session does not hit the wrong host. Diagnostic SQL lives as named files in folders rather than a single growing console. When production looks wrong, the foreign key picker traces users to orders without writing JOINs under pressure. The app launches quickly enough that opening it mid-debug does not break flow. For deploy day they keep production connections on read-only startup queries and only flip write access when a migration is intentional.
2The Data Analyst
An analyst working in Amazon Redshift uses Postico as the exploration client. They browse unfamiliar schemas in the table view, open JSONB-heavy rows in the detail sidebar, and slice data with the filter bar before writing formal SQL for stakeholders. Auto-formatting keeps shared queries readable when pasted into review docs. Exports leave the grid after a final tidy in the editor. Because Postico stays light, it coexists with a Python environment on the same Mac without fighting for memory the way a full Java IDE does.
3The Database Administrator
A DBA manages many PostgreSQL clusters and nests server groups by region and environment. Production connections run startup SQL that forces read-only mode and logging so accidental writes are harder. The function editor is how they review stored procedures used in migrations and ETL. Schema changes go through the structure editor with a DDL review step before execution. Silent updates keep the tool current without interrupting maintenance windows. Seat math matters: Commercial is $99 per device while Team is $799 for up to ten devices, so past roughly eight commercial seats the Team SKU usually wins.
How to Install Postico 2 on Mac
Postico 2 needs macOS 14 (Sonoma) or later. Install with Homebrew, download from Egger Apps, or buy through the Mac App Store. Most power users prefer the direct download or Homebrew cask so App Store sandbox limits do not get in the way.
Install Homebrew if you want the cask route
Open Terminal and install Homebrew with: /bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)". Skip this step if you already use brew or plan to download the DMG from Egger Apps.
Install Postico
With Homebrew: brew install --cask postico. That places the app in Applications and keeps upgrades in the brew upgrade loop. Otherwise download from releases.eggerapps.at/postico2/downloads or the Mac App Store and drag into Applications if needed.
Create the first connection
Launch Postico, click +, and enter host, port, username, password, and database name. For bastion-protected hosts, fill SSH tunnel settings before the database credentials so the tunnel is ready when you connect. Run a trivial SELECT to confirm the path before importing large schemas or writing updates.
Pro Tips
- • Use the evaluation build as long as you need; there is no time bomb, only feature locks until purchase.
- • If you hop between a MacBook and a desk Mac, turn on iCloud or Dropbox sync for connection settings.
- • Prefer a read-only database user for production investigation, then use a separate write-capable connection for deliberate changes.
Configuration Tips
Organize with nested server groups
Right-click the sidebar and create groups, then nest groups such as Production containing US-East and EU-West. The hierarchy stays readable when you manage dozens or hundreds of instances. Solo developers benefit too: a simple Local / Staging / Production split already prevents the wrong-host mistake.
Configure startup queries
In connection settings, add SQL that runs on every connect. Common patterns: SET default_transaction_read_only = on for production safety, session variables for analytics roles, or search_path setup for multi-tenant databases. These run quietly and put the session into a known-safe state before you type anything.
Enable iCloud or Dropbox sync
Turn on sync in preferences so connection lists, saved queries, and window state follow you across Macs. Passwords stay in the macOS Keychain (and can ride iCloud Keychain if you use that). This removes the boring re-entry work when you replace a laptop or keep a travel machine.
Alternatives to Postico
PostgreSQL GUI options on Mac in August 2026 range from boutique native apps to full IDEs. Price, engine breadth, and how heavy the client is usually decide the pick.
TablePlus
DBeaver Community
pgAdmin 4
DataGrip
PostgresGUI
Newer native Mac PostgreSQL client marketed around a low one-time price (about $12.99) and open-source positioning. It undercuts Postico on cost. Postico is still the more mature pick for daily analytical editing, multi-file SQL organization, structure tools, and long-running indie support.
Pricing
Postico 2 uses a perpetual license with no subscription. Personal: $69 / €62 (VAT included) for one user on up to 3 devices. Student: $29 / €27 (VAT included) for 1 device. Commercial: $99 / €90 per device (plus VAT if applicable) for companies and organisations. Team: $799 / €730 for up to 10 devices (plus VAT if applicable). Licenses cover Postico 2.x. Evaluation is free with no time limit and some features disabled until purchase. Postico 1.x and PG Commander owners can use the paid upgrade path; Egger also documents that 1.x license holders can run full Postico 2 via development builds. Postico 2 requires macOS 14 or later and is also sold on the Mac App Store under Apple's terms. Confirm live prices on eggerapps.at/postico2/buy.html because regional VAT display can differ.
Pros
- ✓Native macOS app with quick launch and smooth scrolling through large result sets
- ✓Built for PostgreSQL (plus Redshift, CockroachDB, Greenplum) instead of generic multi-DB compromise
- ✓Multi-file query editor with folders and pgFormatter auto-formatting
- ✓Silent background updates that stay out of the way
- ✓Perpetual license without a subscription clock
- ✓iCloud or Dropbox sync for connections and saved queries across Macs
- ✓Native function editor for stored procedures and PL/pgSQL work
- ✓Clean UI that keeps daily SQL work free of IDE chrome
Cons
- ✗PostgreSQL-family focus only; MySQL, Redis, and MongoDB need another tool
- ✗No built-in ER diagram generation like DBeaver or DataGrip
- ✗No visual query builder for complex SQL construction
- ✗macOS 14+ requirement excludes older Macs (use Postico 1.x there)
Community and Support
Postico is developed by Jakob Egger through Egger Apps, a small independent software company in Austria. Support channels: email at postico@eggerapps.at, a built-in feedback flow that can attach screenshots and version info, and GitHub Issues for bugs and feature requests. There is no giant forum culture the way larger vendors run. What you get instead is direct developer attention and a GitHub issue tracker that stays active. Documentation on eggerapps.at covers connection setup, advanced features, and troubleshooting in detail. The user base is mostly Mac developers, data analysts, researchers, and DBAs who prefer native apps over Electron or Java shells. 2026 comparison write-ups still treat Postico as the native Mac purist pick at $69 perpetual. Competitive pressure is less "is it abandoned?" and more "PostgresGUI is cheaper" or "TablePlus covers more engines." That is a healthy place for a mature indie tool to live.
Frequently Asked Questions about Postico
About the Author
Expert Tips for Postico
2026 comparison writers still frame Postico as the native Mac purist pick at $69 perpetual. The competitive pressure is less about abandonment and more about cheaper natives like PostgresGUI and broader tools like TablePlus.
Egger emphasises multi-file SQL, function editing, and silent updates. Evaluate those three workflows hands-on; they are where Postico pulls away from generic database browsers.
For teams, seat math matters: Commercial is $99 per device while Team caps 10 devices at $799. Past roughly eight commercial seats the Team SKU usually wins.
Related Technologies & Concepts
Related Topics
PostgreSQL Database Tools for Mac
Native and cross-platform clients for day-to-day PostgreSQL work on macOS
Native macOS Developer Applications
Mac-first developer tools that avoid Electron or JVM overhead for common tasks
Sources & References
Fact-CheckedLast verified: Aug 9, 2026
Key Verified Facts
- Personal license is $69 / €62 (VAT included) for up to 3 devices; Student $29 / €27; Commercial $99 / €90 per device; Team $799 / €730 for up to 10 devices.[cite-postico-2]
- Postico 2 requires macOS 14 or later and offers free evaluation with no time limit (some features disabled).[cite-postico-1, cite-postico-2]
- Postico 2 includes multi-file query editor with pgFormatter, function editor, silent updates, and support for Redshift, Greenplum, and CockroachDB.[cite-postico-1]
- 2026 Mac PostgreSQL roundups still list Postico 2 around $69 personal perpetual alongside newer low-cost native options.[cite-postico-6]
- 1Postico 2 Official Site
Accessed Aug 9, 2026
- 2Postico 2 Licenses & Pricing
Accessed Aug 9, 2026
- 3Postico 2 Downloads
Accessed Aug 9, 2026
- 4Postico 2 Documentation
Accessed Aug 9, 2026
- 5Postico 2 Support
Accessed Aug 9, 2026
- 6Best PostgreSQL Client for Mac (2026)
Accessed Aug 9, 2026
- 7Top Postgres GUI Clients
Accessed Aug 9, 2026
Research queries: Postico 2 pricing 2026; Postico 2 macOS 14 features; best PostgreSQL client Mac 2026