SQL Server Mobile Client allow you to access your MS SQL Server database directly and without any server setup. You can manage your data with a very clean and simple iOS user interface.
FEATURES:
• Connection with the SSH tunnel build-in with password or key authentication (DSA, RSA, ECDSA, Ed25519, Secure Enclave)
• Table data: browse, filter, sort
• Table structure: rename and drop for tables and columns
• Pick FK value for foreign key field
• Free query with assisted composition and plan analysis
• View and Call Functions and Store Procedures
• View database and table information
• View and manage sessions
• View ER Diagram (interactive and with PNG/PDF export)
• View User list and Privileges
• Login information stored in (local or iCloud) KeyChain
• Table data: add, edit and delete record
• Blob preview and export
• Blob update (from iOS Photos or Files)
• Geometry/geography data viewer (only from table)
• Export data grid to CSV, JSON, HTML, SQLite, Excel and MSAccess(XML) format
• Export table to CSV, NDJson and SQLite format
• Import of CSV, SQLite and 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
• Job Activity Monitor
• JS script (with db access)
Tested on SQL Server 2012, 2017 and Azure SQL Database.
Does not support dynamic TCP port in conjunction with SSH tunnel.