PostgreSQL Client 4+

Name: PostgreSQL Client
Rating: 4.8 (10 reviews)
Author: Filippo Maguolo

Filippo Maguolo

Designed for iPad

- 4.8 • 10 Ratings

- Free
- Offers In-App Purchases

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

24 Jun 2025

Version 43.0

• Added new match types in Global Search
• Added match types in grid filter
• Fixed scripts synchronization

4.8 out of 5

10 Ratings

I need more info

Beautiful app! I have little wishes:
1. On error handling show not only error message but also HINT. +
2. Editor of procedure must to resize on full screen. +
3. Calling procedure background.
4. Opportunity of show Postgres log.
5. Debug of procedure?
6. Cannot add column in index of materialize view!
7. Change sql of materialize view.
8. Call function with sql:
Select func(params...)
Not informative, not split into columns.
Use instead;
Select * from func(params...)
9. Params of func or procedure did’t save. +
10. I can’t edit table with primary key. Get error -“A Primary key required for this ...” - during table views

Thanks for the feedback!
About the point 6: it's not possible to alter an index by adding a column or rename a column of a materialized view due to PostgreSQL implementation, so in the last update those UI functions are correctly disabled.

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.