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.
BASIC 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
• 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 Job Activity Monitor
• View User list and Privileges
PRO FEATURES (with in-app purchase):
• Login information stored in (local or iCloud) KeyChain
• Table data: add, edit and delete record
• Pick FK value for foreign key field
• Blob preview and export
• Blob update (from iOS Photos or Files)
• Geometry/geography data viewer (only from table)
• Export data grid to CSV, JSON, SQLite, HTML, 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
• 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.
If you need to monitor sql servers on your iPhone, then this app is almost perfect. Have been looking for the best ms sql server iOS app for a while due to limitations with our rmm (pulseway) You can completely view and edit your database as if it was running from in ssms. You can also run stored procedures and terminate blocks. It would be nice to view agent jobs and history but can’t complain for the price.