Add to Chrome
Add to Edge
Add to Firefox
Add to Opera
Add to Brave
Add to SafariWhen comparing Postico vs DbSchema, the Slant community recommends Postico for most people. In the question“What are the best PostgreSQL management tools?” Postico is ranked 3rd while DbSchema is ranked 11th. The most important reason people chose Postico is:
Postico is a native OS X app which is available through Mac App Store. The UI is fast, responsive and integrates seamlessly with the OS.
Specs
Question Ranking
Pros
![[deleted]](https://avatars.slant.co/identicons/50/01aa8b5b-42bc-570f-8f6d-1c48ea34388e)
Pro Native experience and clean user interface
Postico is a native OS X app which is available through Mac App Store. The UI is fast, responsive and integrates seamlessly with the OS.
Pro Created by an experienced developer in the field
Postico is the successor of PG Commander, an older Mac Posgres GUI tool which is also widely used. They are both maintained by the same person.
Pro Graphical Diagram Editor
Includes the possibility to edit tables and data directly in the diagram without writing SQL statements.
Pro Multi-platform
Runs on Windows, Mac, and Linux.
Pro Virtual Foreign Keys
If the Database schema is missing real foreign keys, it is possible to create virtual ones to be used within the tool.
Pro Generator for Random Data
Includes the possibility to generate random numerical data or fetch random entries from a text file to populate the database.
Pro Generate schema from existing database
Includes the possibility to generate an ER diagram from an existing database.
Pro SQL editor with syntax highlighting
Includes an SQL editor with syntax highlighting and code completion feature.
Pro Graphical Query Editor
Includes a visual query editor capable of using different join types, filters as well as the 'group by' clause.
Cons
Con No multiple query tabs in the free trial version
To be fair, multiple windows / tabs IS a feature. It's just part of the paid version.
Con Commercial
Postico is a commercial app, with a one-time fee of $35. There is a free trial available.
