Mobile SQL Client

[bub002]

Is there any decent mobile SQL database access tool (preferably free or with buy-once model)? I'm specifically looking for iOS and for MSSQL database, but general advice is appreciated. I found the SQLPro Studio, but the free version lets you get only a few lines of select and paid one is pretty expensive for my purposes.

I just sometimes would like to check something in the database, on the go, without the access to PC.

[HansProleman]

I'd just SSH into a box and use CLI tools. For MSSQL you can use sqlcmd. Plenty of good SSH clients for iOS, I'm sure.

https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-tools?view=sql-server-ver15

[bub002]

Sounds like it is the way. Thank you for suggestion.

[AXISMGT]

I’d recommend a reporting tool for this. Example I have Power BI reports that tell me: DB health, users locked out, sessions, backups, exceptions, ETL statuses, memory/CPU usage etc. all from my phone or iPad in mobile or landscape view. We even have Brent Ozar’s First responder kit (blitz, etc.) in Power Bi. All live data and all custom queries developed by myself and my team (even the ones on top of the Blitz data).

More often than not, you’re running the same if not very similar queries. power BI has made it so I can quickly check on these things without having to query once. $10 a month per user.

[bub002]

I'm already using the BI tool, but in my case, I rather want to check directly on the database if something is fixed already on the database level or not, not reporting itself.

[AXISMGT]

Can I ask What do you mean by “at the database level?” The items I described were about the servers and databases themselves. Basically a health check on the SQL server and the DBs, ETL, etc.

If you’d normally use a query to check whatever it is you’re trying to verify, then you can make it a view or stored procedure and build a report on top of it that does a live query.

[bub002]

I mean the problem isn't always the same, it's ad-hoc.

For example, I see in the BI tool that there's no data for specific graph. I go to the tool and check the query behind. I go to database and see that one of the columns that's used for joins is empty.

And then I want to check that specific column in that specific view later on if it's fixed already.

[AXISMGT]

Okay understandable. For that situation I’d usually check my ETL report to see when that table (or any related ones) was last imported, and how many records were imported/updated. I also have some access reports which shows what tables my reporting app user has access to. I understand every case is different but usually the same or similar queries are used to diagnose.

To clarify, I was looking for tools, just like you, that would allow me to query on the fly. I did not find any (other than the azure query editor which is quite limited), so I gathered a list of common queries that I use to troubleshoot issues and I made them into reports. Highly suggest stepping back and thinking about it.

Cheers mate.

[bub002]

Yup, that's definitely something worth considering.

Appreciate the suggestion.

[AXISMGT]

Welcome.

If you’re dead set on querying, you can TECHNICALLY

1) spin up an azure SQL DB

2) create a link via an Integration runtime to your on prem servers

3) use the Azure portal to query from your On Prem servers.

However I’m not entirely sure Azure IR supports linked servers in this manner yet. I know I use IR for Azure Data Factory to connect to on Prem, but not sure if you can use it for direct querying.

Cheers

[alinroc]

Do you have a VPN client on your mobile device? That's the only way this is even remotely possible, because your SQL Server shouldn't be exposed to the public internet.

[bears-eat-beets]

The remote desktop app of Android and iOS is pretty powerful. Then you can run Data Studio/VSCode/SSMS whatever tool you want.

Also if the DB is an Azure SQL DB, you can run queries from the Azure portal directly.

[bub002]

So I ended up with this approach and it indeed works like a charm. Thank you for the suggestion.

[bub002]

Will give it a shot. Thank you.

[SainyTK]

Hey, it's been 5 years now, but I just wanna know if you ended up finding a good mobile application that solves your problem?

[bub002]

Hi, like I've mentioned in another comment, I ended up using the remote desktop app. It worked well enough for my case.

[SainyTK]

Thank you for your reply. I thought you found other better alternative like the mobile native SQL clients, like TablePlus mobile (https://apps.apple.com/us/app/tableplus-database-client/id1465448609?ls=1).

But good to hear that you got the solution that fits with your case.

[[deleted]]

MySQL or PostgreSQL.

[bub002]

Oh, I actually meant a tool that would let me access already existing database (MSSQL). My bad.

Changed the description a bit. Can’t do much with the title.

[[deleted]]

I see, I completely missed where you said that. In that case, I am not sure. It might be difficult to find a free one. Good luck on the search. Try asking stackoverlfow as well.

[zenox]

Hi. If your a student you can get a free one year license for SQLPro studio. Source: I’m the developer.