PostgreSQL Client vs TablePro

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

TablePro is a native database client for iPhone and iPad. Browse tables, run queries and edit rows, using the same connections you use in TablePro on the Mac. DATABASES - MySQL and MariaDB - PostgreSQL - Microsoft SQL Server - Oracle - Redis - SQLite and DuckDB files on your device - TiDB and OceanBase - Amazon Redshift connections synced from the Mac BROWSE - Search tables and page through rows, 50 to 500 at a time - Sort by any column, search text columns, and stack filters with AND or OR - Tap a foreign key to preview the row it points to - See the columns, indexes and foreign keys of any table EDIT - Open a row full screen, change values, set NULL and save - Insert and delete rows, truncate or drop a table - Every save, insert and delete runs in a transaction - Safe mode for each connection: Off, Confirm Writes or Read-Only QUERY - SQL editor with syntax highlighting - Stop a query while it runs - Copy or export results as JSON, CSV or SQL INSERT statements - Query history for each connection - Follow a running query in a Live Activity on the Lock Screen and in the Dynamic Island CONNECT SECURELY - SSH tunnels with a password or a private key, with host key checks - SSL with CA and client certificates - Passwords and private keys kept in the Keychain - Lock the app with Face ID, Touch ID or Optic ID WORKS WITH YOUR MAC - iCloud sync of connections, groups and tags with TablePro for Mac, off until you turn it on - Password sync through iCloud Keychain, off by default - Continue an open connection on another device with Handoff - Import connections from a .tablepro file through Files or AirDrop ORGANIZE - Favorites, recent connections, groups and tags - A Quick Connect widget for your Home Screen - Shortcuts and Siri actions to open a connection or add rows to a table TRY IT FIRST Open the built-in Chinook sample database to browse, query and edit without setting up a server. PRIVACY Usage data is off unless you turn it on, and it never includes hostnames, usernames, passwords, queries or data.