PostgreSQL Client 4+

Filippo Maguolo

    • Free
    • Offers In-App Purchases

Screenshots

Description

DB Compass for PostgreSQL allows you to access your PostgreSQL database directly and without any server setup. You can manage your data with a clean and simple iOS user interface.

FEATURES:
• Connection over TLS encryption and/or SSH tunnel
• Database authentication supported: plain, MD5 and SASL (SCRAM-SHA-256 and SCRAM-SHA-256-PLUS)
• SSH authentication support Secure Enclave Key and U2F/FIDO NFC Key
• Assisted table creation and alter structure
• Explore, filter, sort, and quick search table data
• Query script with A.I. assisted composition and plan analysis
• Database objects (tables, views, procedures, etc.)
• Database statistics, sessions manager, server status graphs
• ER Diagram Viewer
• Advanced data grid for browse, edit, conditional formatting
• Blob field preview, import and export
• Job Activity Monitor
• User list and Privileges
• Import and Export in multiple formats
• iCloud Sync for SQL and JS scripts
• SQL plan analysis
• Execute queries with Shortcuts App
• Charts & Widgets

OpenAI integration requires your key and is only available in allowed regions.
Ollama integration requires your server to connect to.

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

-- This is a Premium app and some features may require an in-app lifetime unlock --

For feedback or suggestions contact info@dbcompass.net

What’s New

Version 41.1

• Added display of received notifications
• Fixed SASL authentication in case of TLS certificate RSA-PSS

Ratings and Reviews

4.6 out of 5
122 Ratings

122 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
NetOps: SNMP & SSH Terminal
Developer Tools
Node.js Lab
Developer Tools
SQLPro Studio database client
Developer Tools
Rest – HTTP API Client
Developer Tools