RoSQL - SQL Client

4.1
146 reviews
10K+
Downloads
Content rating
Everyone
Screenshot image
Screenshot image
Screenshot image
Screenshot image
Screenshot image
Screenshot image
Screenshot image
Screenshot image
Screenshot image
Screenshot image
Screenshot image
Screenshot image
Screenshot image

About this app

SQL Worksheet and Query Client for Oracle / MySQL and MSSQL Databases

- create sql statements
- unlimited resultset rows
- size of a resultset is only limited by your memory
- save/load sql statements in/from textfiles
- fix columns in a result set
- sort columns in a result set
- use dynamic variables like &input
- syntax highlight
- sql beautifier
- create explain plans
- export data to csv
- export and copy data to clipboard
- manipulation sql's like 'insert' or 'update'

This app was developed as a private tool for accessing databases from Android devices.
Primarily, the development was designed for Oracle databases.
It is provided free of charge and does not claim to compete with professional tools.
No warranty is provided for any damage that may result from the handling of this app.
The use of this app is at your own risk.

RoSQL should be used in a secure network like a vpn network or a local secured network, because the traffic isn't encrypted !

MSSQL is only implemented for Android 5 and higher, not for Android 4.4.

Google has changed security settings for Android 10 and higher. on some devices the rights for storage access are no longer sufficient and you cannot store your sql's in the file system. a samsung s9 with android 10 can save files, a Huwawei P30 with android 10 cannot do this.
in V2.19 i use a new compatibility mode from google so it should be possible now to use external storage again (after you have given the app the permission to do this).

there is a additional "quick and dirty" solution for this if a problem with external storage still exists. you can use the checkbox in settings "use private storage for storing files". then it is possible to save your sql's in the private area of this app.but then some features are not working any longer. this is a "flat" area, that means you cannot create any subdirectories. also exporting results to csv (use copy to clipboard / sharing for this) or exporting and importing your configs is not working with this solution. you should only use this, if external storage doesnt work for you.

There is a problem (ORA-12705) with NLS (Oracle and thin client) for some countries. if your phone or tablet has a language (for example Cyrillic) , that is not supported, you can try to change the locale in the settings-window to "US" (checkbox for a US default connection). it seems to be a oracle express problem, on tests with oracle standard/enterprise databases i do not have this connect errors.

this oracle sql client uses a direct thin v8 connection for Android 4.4 nd lower and a direct thin v11 connection for android 5 and higher to your database !

- Android 5 User and higher no longer have to set compatibilty mode 8 for Oracle
- Android 4.4 User and lower have to set compatibility mode 8 (oracle10 and above) as described below:
for Oracle12c connections please set in sqlnet.ini (Server) SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
for databases equal oracle10g or 11g: SQLNET.ALLOWED_LOGON_VERSION=8

you can download still a version for Android 4.4 and lower, but it will no longer be maintained.

if your db-admin doesn't allow you direct thin connections (v8 or v11) from a Client, this app can't connect to your oracle database !
tested connections: oracle9i, oracle10g, oracle11g, oracle12c, mysql 5.5, mssql server 2016

please rate this app if you like it and also tell me what you don't like :)
Updated on
Nov 9, 2020

Data safety

Safety starts with understanding how developers collect and share your data. Data privacy and security practices may vary based on your use, region, and age. The developer provided this information and may update it over time.
No data shared with third parties
Learn more about how developers declare sharing
No data collected
Learn more about how developers declare collection
4.1
146 reviews
Morgan Williams
April 29, 2020
Simple and effective. My only major complaint is that it doesn't seem like it's possible to have multiple distinct queries on one page. Separating them by semicolon or slash is ignored, and everything on the page is executed, which makes most of my existing SQL files pretty much useless. Maybe I'm just missing something? It would also be great to be able to have multiple tabbed edit pages available to switch between.
3 people found this review helpful
Did you find this helpful?
Robro
May 13, 2020
thank you for your comment! Now you have 3 tabbed edit pages. you can select a area of your edit page to execute only this area. you can do this manually or with button "select area at cursor position". with button you can do a execute also automatically if you mark the corresponding checkbox in settings. hope this helps you a little bit. Regards
Ken Crossen
October 23, 2019
Rough around the edges perhaps, but two key features make this app best in category. First, you can tell it to forget your user and password. Second, and important for professional use, it supports MySQL local variables. Incredibly, the higher-rated pay-by-subscription app, like the other apps in this category, does not support local variables. Other features good to great. Deserves a better rating. Damned good job by a rookie, showing the pros how it's done.
5 people found this review helpful
Did you find this helpful?
Robro
October 23, 2019
Thank you very much for your very honest evaluation. I wrote the application because there was no good Oracle SQL application in the app store. Since I had to acquire the programming knowledge first, it is unfortunately not very nicely designed due to my rudimentary knowledge, but it fulfills its purpose :)
Alad Mocu
September 26, 2018
Well done app, it does what it must, just a little thing , if you can improve the user interface, idk material or something it would be better. The button size and icons can be tricky to understand. Sorry for bad English
3 people found this review helpful
Did you find this helpful?
Robro
September 28, 2018
No Problem. I will take a look at it if i have more time. At the moment i have no time for further development of the application. Sorry..

What's new

V2.18/19
- changing permissions for using external storage on android 10 and higher
- use private Storage for storing files if external Storage doesn't work
V2.17 and before
- reload last used sql files at program start
- 'selecting area at cursor' for helping you to select a area where the cursor is currently located (semicolon separated) and immediately executing this area
- switch off confirm leaving resultset
- changing behaviour of executing stored procs