PostgreSQL Client50.1 - App Store

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,
SASL (SCRAM-SHA-256 and SCRAM-SHA-256-PLUS)
and OAuth (PostgreSQL 18+)
. 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, Gemini and Claude integration requires api key and is only available in allowed regions.
Ollama and LM Studio integration requires your server to connect.

Tested on PostgreSQL 9.5 to 18.

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

For feedback or suggestions contact info@dbcompass.net

Version History • New and improved SQL Query Plan & Analysis 50.1 5d ago • New and improved SQL Query Plan & Analysis 50.0 6d ago • New integration with Apple Private Cloud Compute 49.0 Sep 17 • Improved "data" chart type with more customizations
• Improved AI assistant, added web-search tool and a compatible OpenAI api provider 48.0 Aug 11 • New customisable Overview, customizable, with embedded charts, scripts rapid execution, and global search shortcuts.
• New AI integration with Gemini, Claude, LM Studio and Apple Intelligence. 47.0 Jul 31 • New app icon and new iOS 26 UI
• New Auto-Commit option
• Add support for PostgreSQL 18+ OAuth authentication
• Drop iOS 15 support 46.0 May 4 • New chart type to display a single text/value
• Improved Global Search completion text search
• SQL script completion hints improvements
• Updated SSH Tunnels key algorithms (ML-KEM and SNTRUP761) 45.0 Jan 25 • New chart features: trendlines, reference lines, data symbols customizations, and dynamic axis titles
• Chart widgets can also be placed on the Lock Screen
• New Import dBase files (DBF)
• New Logical Expression in grid filter and Global Search
• New Light/Dark UI mode selection
• New Customizable colors in HTML Grid Export 44.0 10/07/2025 • Fixed store procedure call panel
• Fixed export tables crash 43.1 07/10/2025 • Added new match types in Global Search
• Added match types in grid filter
• Fixed scripts synchronization 43.0 06/24/2025 • New name for scripts (which can be referenced in Shortcuts)
• New Global Search that allows a text search in the whole database
• New SQL script results available through a faster (configurable) popup
• Record View window can now navigate to multiple foreign key relation levels
• New menu and UI reorganization 42.0 06/16/2025 • Bugs fixed in A.I. integration 41.2 03/03/2025 • Added display of received notifications
• Fixed SASL authentication in case of TLS certificate RSA-PSS 41.1 02/25/2025 • New multi-chat and multi-service A.I. integration
• Additional Charts customizations 41.0 02/21/2025 • New Widgets with user defined charts
• New named parameters for SQL in Shortcuts
• Fix crashes 40.2 01/27/2025 • New Widgets with user defined charts
• New named parameters for SQL in Shortcuts
• Fix crashes 40.1 01/21/2025 • New Widgets with user defined charts
• New named parameters in Shortcuts query execution 40.0 01/18/2025 • Stored procedures and functions call fixed 39.1 12/03/2024 • New OpenAI integration 39.0 12/02/2024 • Fix DDL table viewer
• Fix SQL editor crash 38.1 07/31/2024 • New table DDL generator
• Improved CSV/NDJSON import with auto generated primary key
• Improved SQL editor performance 38.0 07/23/2024 • New Grid Conditional Formatting
• New Column Statistics
• New regular expression search in data grid
• CSV import improvements (with new date pattern conversion) 37.0 05/15/2024 • New JS script (with integrated db connection and charts generator)
• New manual grid data page navigation
• Added support for FIDO Key in SSH tunnel
• Bug fixes 36.0 02/01/2024 • Improved script results with new detailed panel
• New filtering and sorting functionality in entity details
• Accessibility fixes and improvements 35.0 11/28/2023 • New user list view and privileges 34.0 10/09/2023