PostgreSQL Client vs PostgreSQL Visual Manager

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

Built by developers, for developers. We created this app because we faced a common problem: receiving an urgent alert while out of the office—on vacation or at dinner—without a laptop nearby. We needed a way to quickly check the database, run a diagnostic query, or fix a record using just a phone. We built this tool for our own use, but realized other developers might need it too. This isn't a bloated enterprise suite. It is a straightforward, secure, and comfortable tool to manage your PostgreSQL databases when you are away from your workstation. Core Functionality: * Emergency Access: Connect to your database from anywhere (supports SSL). * CRUD Operations: Select, Insert, Update, and Delete rows via a visual interface. * Custom SQL: Write and execute complex queries. * Data Export: Export your query results to CSV or JSON to share or analyze. * Table Inspector: Browse schemas, views, and tables with pagination. Security & Privacy: * 100% Local: We do not have a backend. Your data never touches our servers. * Encrypted Credentials: All passwords are stored using the device’s native secure storage (Keychain on iOS). * Direct Connection: The app connects directly from your device to your PostgreSQL server.