SQL Server Mobile Client

SQL Server Mobile Client

By Filippo Maguolo

  • Category: Developer Tools
  • Release Date: 2018-08-06
  • Current Version: 31.1
  • Adult Rating: 4+
  • File Size: 59.39 MB
  • Developer: Filippo Maguolo
  • Compatibility: Requires iOS 13.0 or later.
Score: 4.14583
4.14583
From 48 Ratings
Free On itunes

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.

Screenshots

Reviews

  • Great app for the price

    5
    By ToddChitt
    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.

  • —- Great App —-

    5
    By tomdoyle1948
    This fantastic app is easy to use and full featured. I do have two questions. 1 Login opening screen - is it possible to edit and/or delete entries? 2 Circle with F in the middle at the bottom of table screens. It turns yellow if you tap it. What else does it do ? I was unable to find a support web site with documentation on this wonderful app. Thank you for writing this.

  • Best IOS SQL Server app

    5
    By 08540
    The app deserves 5 stars and the developer at least 6. Not only does the app do most everything you could want in a mobile SQL Server solution, the developer is very responsive and open to adding suggested improvements, sometimes implementing them within days. I have his other SQL apps as well (MySQL and SQLite) and they are equally awesome.

  • Can’t even import sql scripts with upgrade

    1
    By fionalindberg
    Worst sql client ever. Hankinsoft is great on MacOS but pricey on iOS. Azure Data Studio is best of all, but again not yet on iOS. I got the free version but to save a connection I had to upgrade for full features. That was about it. Whenever I try to import.sql from my large library of scripts I could browse the folders in both iCloud and Google Drive but not open the script itself. Standard file extensions .sql. Probably that is another purchase. Don’t waste your money.

  • Still doesn’t work with Azure

    1
    By twesque
    I’ve seen the developer respond to other comments saying Azure access is fixed. It’s not. Still can’t connect to an Azure DB.

  • No Azure Access

    2
    By Redeye51
    I was looking forward to testing and purchasing this app but it doesn’t connect to Azure. Until then I cant use this app. I saw the dev stated Azure would be supported in the next release but that was back in July.

  • Great app but I’m having issues

    5
    By Placing1337
    I 100% vouch to upgrade to pro but I’m having issues editing existing entries it says “primary key not found” and when I try to duplicate an entry it says “invalid syntax where” once these are fixed it’ll be a perfect mobile database editor

  • Does NOT work with Azure SQL

    2
    By pqsk
    Good thing the free version (trial run) is in place to test. This doesn’t work with Azure SQL

  • Very nice App

    5
    By DevInTraining
    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!

  • Best SQL app

    5
    By Jonatious
    I have no clue why this app doesn’t have 5 star reviews. This app has everything I needed for a database client for mobile.

More by Filippo Maguolo

keyboard_arrow_up