PostgreSQL Client 4+

Filippo Maguolo

    • 4.6 • 119 Ratings
    • Free
    • Offers In-App Purchases

Screenshots

Description

PostgreSQL Client allow you to access your PostgreSQL database directly and without any server setup. You can manage your data with a very clean and simple iOS user interface.

BASIC FEATURES:
• Connection over SSL/TLS encryption with support for X.509 Certificate authentication
• SSH tunnel build-in with password or key authentication (DSA, RSA, ECDSA, Ed25519, Secure Enclave Key)
• Database authentication supported: plain, MD5 and SASL (SCRAM-SHA-256 and SCRAM-SHA-256-PLUS)
• Table data: browse, filter, sort
• Table structure: rename and drop for tables and columns
• Browse of Standard View, Materialized Views, Functions and Procedures (v11)
• View and edit Functions and Procedures
• Free query with assisted composition and plan analysis
• View database and table statistics
• View and manage sessions
• View server status graphs
• View ER Diagram (interactive and with PNG/PDF export)
• Server log file browser

PRO FEATURES (with in-app purchase):
• Login information stored in (local or iCloud) Keychain
• Table structure: new table, add column, alter or drop
• Table data: add, edit and delete record
• Blob preview and export
• Blob update (from iOS Photos or Files)
• Geometry/geography data viewer (with PostGIS extension)
• Export data grid to CSV, HTML, Json, NDJson, Excel and MSAccess(XML) format
• Export table to CSV, NDJson and SQLite format
• Import of CSV, NDJson or MSAccess(MDB/ACCDB) tables
• Browsing of DB structure within a query or a record editor
• iCloud Sync for saved query statements
• Shortcuts support
• Table/View updates in grid
• JS script (with db access)



Tested on PostgreSQL 9.5, 9.6, 10, 11 and 12.


For feedback or suggestions write to maguolo.ios@outlook.com

What’s New

Version 38.1

• Fix DDL table viewer
• Fix SQL editor crash

Ratings and Reviews

4.6 out of 5
119 Ratings

119 Ratings

hallach ,

Yup

It works, as others have mentioned it’s not “perfect” but it gets the job done when you need to access your databases on the go. Displays a form entry for your stored proc’s arguments too which is nifty!

It’s all better than trying to manipulate psql through a terminal app on iOS thats for sure. And for a good price too.

Tcabeen ,

Many imperfections; unbeatable price

Look, for the price, you’re not going to do better. The competition have enterprise-level subscription rates. This app has a fantastic hobbyist-level price. And that’s what I am, so it’s the only viable option for iPad as far as I can see.

It works. It runs queries. It connects and reconnects beautifully. I’ve been creating tables, inserting data, parsing tens of thousands of records without trouble.

It crashes sometimes (but brings all your saved queries right back up). The interface can’t run an individual query, only everything that’s in the current window. The query and the results are in different “tabs” but you can’t switch from the query tab to the results tab without exiting the tab because of the keyboard-helper bar along the bottom (the one that’s still there even when you’re on a hardware keyboard).

So it lacks polish, sure, but it’s WAY faster and easier than typing out the queries from the CLI. And again, check out that outstanding price!

Developer Response ,

Thanks a lot for the feedback and feel free to contact me for more.
I can add the you can select the text on the query windows to run only that part of sql.

Missing my tabs ,

Very good. Redshift mostly works too

Very good postgresql support. But I bought because it is one of the few solutions able to work with Redshift. Seems to support about 90%. Which is good enough for emergency support on the go. Hopefully this helps others.

App Privacy

The developer, Filippo Maguolo, indicated that the app’s privacy practices may include handling of data as described below. For more information, see the developer’s privacy policy.

Data Not Collected

The developer does not collect any data from this app.

Privacy practices may vary, for example, based on the features you use or your age. Learn More

More By This Developer

Make a List!
Utilities
MySQL Mobile Client
Developer Tools
Secure Terminal
Developer Tools
Zip Opener
Utilities
SQLite Mobile Client
Developer Tools
P7M Viewer
Business

You Might Also Like

TablePlus - Database Client
Developer Tools
SQLiteFlow - SQLite Editor
Developer Tools
SQLPro Studio database client
Developer Tools
MySQL Client by SQLPro
Developer Tools
Rest – HTTP API Client
Developer Tools
Power JSON Editor Mobile
Developer Tools