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 - MongoDB - ClickHouse - Redis - SQLite and DuckDB files on your device - TiDB and OceanBase - Amazon Redshift connections synced from the Mac - Cloudflare D1, with the database picked from your account's list 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 - Show rows and query results as cards or as a grid with a pinned header and key column - Tap a foreign key to preview the row it points to, then open it - See the columns, indexes and foreign keys of any table - On iPad, the table list sits beside the open table EDIT - Open a row full screen, change values, set NULL and save - View and edit JSON values - Insert and delete rows, truncate or drop a table - Every save, insert and delete runs in a transaction - An open transaction shows on every tab, with Commit and Roll Back - Safe mode for each connection: Off, Confirm Writes or Read-Only QUERY - SQL editor with syntax highlighting - Suggestions for tables, columns and keywords as you type - Run the statement at the cursor or the whole script, and stop it while it runs - Saved queries, synced with your Mac - 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, a private key or keyboard-interactive sign-in, with host key checks - SSH jump hosts and two-factor codes - SSL with CA and client certificates - Sign in with AWS IAM or Google Cloud IAM instead of a stored password - 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, tags and saved queries 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 - Custom icons for connections and groups - 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.