七麦数据

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

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.

BASIC FEATURES:
• Connection over SSL/TLS encryption with support for X.509 Certificate authentication
• SSH tunnel build-in with password or key authentication (DSA, RSA, ECDSA, Ed25519, Secure Enclave Key)
• Database authentication supported: plain, MD5 and SASL (SCRAM-SHA-256 and SCRAM-SHA-256-PLUS)
• Table data: browse, filter, sort
• Table structure: rename and drop for tables and columns
• Browse of Standard View, Materialized Views, Functions and Procedures (v11)
• View and edit Functions and Procedures
• Free query with assisted composition and plan analysis
• View database and table statistics
• View and manage sessions
• View server status graphs
• View ER Diagram (interactive and with PNG/PDF export)
• Server log file browser

PRO FEATURES (with in-app purchase):
• Login information stored in (local or iCloud) Keychain
• Table structure: new table, add column, alter or drop
• Table data: add, edit and delete record
• Blob preview and export
• Blob update (from iOS Photos or Files)
• Geometry/geography data viewer (with PostGIS extension)
• Export data grid to CSV, HTML, Json, NDJson, Excel and MSAccess(XML) format
• Export table to CSV, NDJson and SQLite format
• Import of CSV, NDJson or MSAccess(MDB/ACCDB) tables
• Browsing of DB structure within a query or a record editor
• iCloud Sync for saved query statements
• Shortcuts support
• Table/View updates in grid
• JS script (with db access)
• Charts & Widgets

OpenAI integration requires your key and is only available in allowed regions.

Tested on PostgreSQL 9.5, 9.6, 10, 11 and 12.

For feedback or suggestions contact info@dbcompass.net

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.

BASIC FEATURES:
• Connection over SSL/TLS encryption with support for X.509 Certificate authentication
• SSH tunnel build-in with password or key authentication (DSA, RSA, ECDSA, Ed25519, Secure Enclave Key)
• Database authentication supported: plain, MD5 and SASL (SCRAM-SHA-256 and SCRAM-SHA-256-PLUS)
• Table data: browse, filter, sort
• Table structure: rename and drop for tables and columns
• Browse of Standard View, Materialized Views, Functions and Procedures (v11)
• View and edit Functions and Procedures
• Free query with assisted composition and plan analysis
• View database and table statistics
• View and manage sessions
• View server status graphs
• View ER Diagram (interactive and with PNG/PDF export)
• Server log file browser

PRO FEATURES (with in-app purchase):
• Login information stored in (local or iCloud) Keychain
• Table structure: new table, add column, alter or drop
• Table data: add, edit and delete record
• Blob preview and export
• Blob update (from iOS Photos or Files)
• Geometry/geography data viewer (with PostGIS extension)
• Export data grid to CSV, HTML, Json, NDJson, Excel and MSAccess(XML) format
• Export table to CSV, NDJson and SQLite format
• Import of CSV, NDJson or MSAccess(MDB/ACCDB) tables
• Browsing of DB structure within a query or a record editor
• iCloud Sync for saved query statements
• Shortcuts support
• Table/View updates in grid
• JS script (with db access)
• Charts & Widgets

OpenAI integration requires your key and is only available in allowed regions.

Tested on PostgreSQL 9.5, 9.6, 10, 11 and 12.

For feedback or suggestions contact info@dbcompass.net

PostgreSQL Client allow you to access your PostgreSQL database directly and without any server setup. You can manage your data with a very clean and simple iOS user interface.

BASIC FEATURES:
• Connection over SSL/TLS encryption with support for X.509 Certificate authentication
• SSH tunnel build-in with password or key authentication (DSA, RSA, ECDSA, Ed25519, Secure Enclave Key)
• Database authentication supported: plain, MD5 and SASL (SCRAM-SHA-256 and SCRAM-SHA-256-PLUS)
• Table data: browse, filter, sort
• Table structure: rename and drop for tables and columns
• Browse of Standard View, Materialized Views, Functions and Procedures (v11)
• View and edit Functions and Procedures
• Free query with assisted composition and plan analysis
• View database and table statistics
• View and manage sessions
• View server status graphs
• View ER Diagram (interactive and with PNG/PDF export)
• Server log file browser

PRO FEATURES (with in-app purchase):
• Login information stored in (local or iCloud) Keychain
• Table structure: new table, add column, alter or drop
• Table data: add, edit and delete record
• Blob preview and export
• Blob update (from iOS Photos or Files)
• Geometry/geography data viewer (with PostGIS extension)
• Export data grid to CSV, HTML, Json, NDJson, Excel and MSAccess(XML) format
• Export table to CSV, NDJson and SQLite format
• Import of CSV, NDJson or MSAccess(MDB/ACCDB) tables
• Browsing of DB structure within a query or a record editor
• iCloud Sync for saved query statements
• Shortcuts support
• Table/View updates in grid
• JS script (with db access)



Tested on PostgreSQL 9.5, 9.6, 10, 11 and 12.


For feedback or suggestions write to maguolo.ios@outlook.com

PostgreSQL Client allow you to access your PostgreSQL database directly and without any server setup. You can manage your data with a very clean and simple iOS user interface.

BASIC FEATURES:
• Connection over SSL/TLS encryption with support for X.509 Certificate authentication
• SSH tunnel build-in with password or key authentication (DSA, RSA, ECDSA, Ed25519, Secure Enclave Key)
• Database authentication supported: plain, MD5 and SASL (SCRAM-SHA-256 and SCRAM-SHA-256-PLUS)
• Table data: browse, filter, sort
• Table structure: rename and drop for tables and columns
• Browse of Standard View, Materialized Views, Functions and Procedures (v11)
• View and edit Functions and Procedures
• Free query with assisted composition and plan analysis
• View database and table statistics
• View and manage sessions
• View server status graphs
• View ER Diagram (interactive and with PNG/PDF export)
• Server log file browser

PRO FEATURES (with in-app purchase):
• Login information stored in (local or iCloud) Keychain
• Table structure: new table, add column, alter or drop
• Table data: add, edit and delete record
• Blob preview and export
• Blob update (from iOS Photos or Files)
• Geometry/geography data viewer (with PostGIS extension)
• Export data grid to CSV, HTML, Json, NDJson, Excel and MSAccess(XML) format
• Export table to CSV, NDJson and SQLite format
• Import of CSV, NDJson or MSAccess(MDB/ACCDB) tables
• Browsing of DB structure within a query or a record editor
• iCloud Sync for saved query statements
• Shortcuts support
• Table/View updates in grid
• JS script (with db access)



Tested on PostgreSQL 9.5, 9.6, 10, 11 and 12.


For feedback or suggestions write to maguolo.ios@outlook.com

PostgreSQL Client allow you to access your PostgreSQL database directly and without any server setup. You can manage your data with a very clean and simple iOS user interface.

BASIC FEATURES:
• Connection over SSL/TLS encryption with support for X.509 Certificate authentication
• SSH tunnel build-in with password or key authentication (DSA, RSA, ECDSA, Ed25519, Secure Enclave Key)
• Database authentication supported: plain, MD5 and SASL (SCRAM-SHA-256 and SCRAM-SHA-256-PLUS)
• Table data: browse, filter, sort
• Table structure: rename and drop for tables and columns
• Browse of Standard View, Materialized Views, Functions and Procedures (v11)
• View and edit Functions and Procedures
• Free query with assisted composition and plan analysis
• View database and table statistics
• View and manage sessions
• View server status graphs
• View ER Diagram (interactive and with PNG/PDF export)
• Server log file browser

PRO FEATURES (with in-app purchase):
• Login information stored in (local or iCloud) Keychain
• Table structure: new table, add column, alter or drop
• Table data: add, edit and delete record
• Blob preview and export
• Blob update (from iOS Photos or Files)
• Geometry/geography data viewer (with PostGIS extension)
• Export data grid to CSV, HTML, Json, NDJson, Excel and MSAccess(XML) format
• Export table to CSV, NDJson and SQLite format
• Import of CSV, NDJson or MSAccess(MDB/ACCDB) tables
• Browsing of DB structure within a query or a record editor
• iCloud Sync for saved query statements
• Shortcuts support
• Table/View updates in grid
• JS script (with db access)



Tested on PostgreSQL 9.5, 9.6, 10, 11 and 12.


For feedback or suggestions write to maguolo.ios@outlook.com

PostgreSQL Client allow you to access your PostgreSQL database directly and without any server setup. You can manage your data with a very clean and simple iOS user interface.

BASIC FEATURES:
• Connection over SSL/TLS encryption with support for X.509 Certificate authentication
• SSH tunnel build-in with password or key authentication (DSA, RSA, ECDSA, Ed25519, Secure Enclave Key)
• Database authentication supported: plain, MD5 and SASL (SCRAM-SHA-256 and SCRAM-SHA-256-PLUS)
• Table data: browse, filter, sort
• Table structure: rename and drop for tables and columns
• Browse of Standard View, Materialized Views, Functions and Procedures (v11)
• View and edit Functions and Procedures
• Free query with assisted composition and plan analysis
• View database and table statistics
• View and manage sessions
• View server status graphs
• View ER Diagram (interactive and with PNG/PDF export)
• Server log file browser

PRO FEATURES (with in-app purchase):
• Login information stored in (local or iCloud) Keychain
• Table structure: new table, add column, alter or drop
• Table data: add, edit and delete record
• Blob preview and export
• Blob update (from iOS Photos or Files)
• Geometry/geography data viewer (with PostGIS extension)
• Export data grid to CSV, HTML, Json, NDJson, Excel and MSAccess(XML) format
• Export table to CSV, NDJson and SQLite format
• Import of CSV, NDJson or MSAccess(MDB/ACCDB) tables
• Browsing of DB structure within a query or a record editor
• iCloud Sync for saved query statements
• Shortcuts support
• Table/View updates in grid
• JS script (with db access)



Tested on PostgreSQL 9.5, 9.6, 10, 11 and 12.


For feedback or suggestions write to maguolo.ios@outlook.com