SQLPro for Postgres is a advanced but lightweight PostgresSQL database client, allowing quick and simple access to Postgres servers.
This is not a free app. Please don't download this app assuming it will be free.
+ Syntax highlighting.
+ Tabbed based interface.
+ Support for executing multiple queries at once.
+ Quick access to tables, columns and more.
See what others are saying, by checking out these great reviews:
This SQL Client does NOT work with MySQL or Microsoft SQL Server.
SQLPro requires a Premium upgrade in order to interact with database result sets. Premium is available as either a Lifetime Purchase or through a Subscription with Monthly and Yearly options. Subscriptions auto-renew within 24 hours of the expiration date unless auto-renewal is turned off in the iTunes account settings. Your Account will be charged for renewal (based on your selected plan) within 24-hours prior to the end of the current period. Any unused portion of a free trial period, if offered, will be forfeited when the user purchases a subscription to that publication, where applicable. Payment will be charged to your iTunes Account at confirmation of purchase.
+ Fixed an issue where new connections were defaulting to read-only.
Ratings and Reviews
As a developer...
... I understand and love the notion of getting paid for your work, and I pay for my tools. I was using this package through SetApp the last few years, and recently dropped SetApp from my life just to simplify things. I always loved and relied on this tool. Happy to pay for it, except... come on, IN APP purchase just to actually do anything with the results? That's dumb. It's a good application. Just make it a pay-to-use application. I'll pay the purchase price, but that's just sleazy. Not a fan of the apparent bait-n-switch, especially since I coudln't find a price for it on the app store without installing it and doing the actual work to bang a query only to see the paywall. That's some serious used car salesman level of sleaze right there. :(
SQLite is as handy as it gets for database creation and management. The drawback, of course, is that it's not intended for access by multiple clients that may attempt to connect simultaneously. Postgresql is an open source (free) database system that is very similar in syntax to SQLite, and which accommodates multiple simultaneous calls for data. SQLPro makes creation, entry and retrieval from a Postgresql database located on a remote server nearly as easy to carry out as it is with a local SQLite database. Doing that requires ssh tunneling, which the app makes easy to set up. When migrating from SQLite to Postgresql, binary data from SQLite can be imported directly into Postgresql's bytea hex format, with binary data automatically converted to a hex string. So far, I'm very pleased with how the app makes an otherwise fairly complicated migration easy.
Better than most postgres tools for Mac, needs improvement
This tool has some annoying bugs.
Not the least is the way an auto-renewing subscription requires you re-install the app to get it to work.
Other bugs are related to "alter table".
Nonetheless this tool generates excellent DDL and, when it works, exports tables cleanly to JSON and CSV.
However, it's not hard to put this tool into a bad state where it must be restarted or else it will crash.
Data Not Linked to You
The following data may be collected but it is not linked to your identity:
- Usage Data
Privacy practices may vary, for example, based on the features you use or your age. Learn More
- Hankinsoft Development Inc
- 17.7 MB
- Developer Tools
- Requires macOS 10.14.6 or later.
- Age Rating
- © Hankinsoft Development, Inc
- In-App Purchases
- SQLPro Premium $7.99
- SQLPro Premium $59.99
- SQLPro Premium - Lifetime $149.99