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.
+ Query output now displays NOTICES.
Ratings and Reviews
Fast, no feature glut
Does exactly what I need it to do and not bogged down by useless or slow features.
- Connection management
- Syntax highlighting, typeahead suggestions
- Handles relatively large datasets BLAZING FAST
- Bookmarks/Favorite queries
- Search for table/column
- Multiple SQL editor tabs
- Keyboard shortcuts for executing queries
- Export to CSV/JSON
Wish there was an export to XLS(X) but otherwise, keep this lean and perfect at everything it does!
Good tool, but bad at managing subscriptions
The tool works fairly well and is definately an improvement over command line. Being a paid app, you expect it to perform fairly well. Every couple of weeks it will claim I'm not paying for it (even though I am). If you click the Restore subscriptions it prompts you to enter your apple password but then does nothing and it doesn't give you access to the tools you are paying for. It took me a while to figure out you have to restore the subscriptions and then restart the application. Very annoying.
Developer Response ,
Hi! Unfortunately the subscription management/renewal is handled by Apple. macOS apps SHOULD download the renewal information automatically which is then picked up by SQLPro, but for some reasons some users don't get new renewal information without hitting restore, or even uninstalling/reinstalling the app. Very sorry about the issue.
Necessary tool for development with Postgres on Mac
I'm not a command-line sql kind of guy. I like visual tools (UI apps), and I am happy to pay for this.
With Family Sharing set up, up to six family members can use this app.