SQL Server Mobile Client 4+
Filippo Maguolo
-
- Free
- Offers In-App Purchases
Screenshots
Description
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.
What’s New
Version 34.0
• New table DDL generator
• Improved CSV/NDJSON import with auto generated primary key
• Improved SQL editor performance
Ratings and Reviews
Great app for the price
I sprang for the Pro version for $9 or $10. It allows saving of connection strings.
Keep in mind that this is NOT an iOS ‘replacement’ for Microsoft SSMS, which BTW has a 2 GB install footprint (larger than SQL itself). But it does have good access to tables, views, procedures, etc. and is Data Type aware when entering or editing data.
Works fine with Azure SQL Db. If you can’t make it work, it’s probably an IP rule blocking you on your Azure SQL Server and NOT a limitation of the app.
I signed up for the Beta program to help the developer fix some minor issues and test early releases. He was very responsive and helpful.
Very nice App
I agree with Jonatious this is great app so not sure why either the low rating unless the ratings are from the competition. Easy to use and does everything I have tried in it so far. I’m practicing for a MS SQL cert so the app lets me do this on the go. Contacted the developer with a list of questions before I purchased the app and within 24 hours they had responded with very detailed answers. Awesome app and support!
Works great with Azure SQL
Does everything I need, let’s me stop being preoccupied with data imaginings since I can get in and work with real queries when pulled away from my computer. Really fantastic app in terms of capabilities. Responsive, and despite older reviews saying otherwise, it’s connecting just fine to Azure SQL.
App Privacy
The developer, Filippo Maguolo, indicated that the app’s privacy practices may include handling of data as described below. For more information, see the developer’s privacy policy.
Data Not Collected
The developer does not collect any data from this app.
Privacy practices may vary, for example, based on the features you use or your age. Learn More
Information
- Seller
- Filippo Maguolo
- Size
- 76.3 MB
- Category
- Developer Tools
- Compatibility
-
- iPhone
- Requires iOS 13.0 or later.
- iPad
- Requires iPadOS 13.0 or later.
- iPod touch
- Requires iOS 13.0 or later.
- Apple Vision
- Requires visionOS 1.0 or later.
- Languages
-
English
- Age Rating
- 4+
- Copyright
- © Filippo Maguolo
- Price
- Free
- In-App Purchases
-
- PRO FEATURES $8.99