RoSQL - SQL Client

4.1
151 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

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.

- 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'

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.

On Android 11 or higher you have give the app file read and write permissions in your android phone settings. see special app rights on your phone. it seems to be different to set for different phones/android versions.

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
Aug 21, 2023

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

Ratings and reviews

4.1
128 reviews
A Google user
August 11, 2019
I have yet to test this app. I use most of my installed explorer Apps as File Viewers with settings, now if I can use RoSQL (Like Ro in Android lol mann the places... droid) as a default system editor, Ill want a lockscreen app for notifications. I proposed good apps to start this on are ones that can Analyze and Boost Performance, a Caller ID App, a Launcher, Theres also the draw over apps feature, such as storage to sense if the device is powered on or not :) Google Find, Play Protect EXPERT.
2 people found this review helpful
Did you find this helpful?
Dhaval Bhalara
August 19, 2020
First of all thank you very much for this app. Thank you for multiple tabs...now life is even more easy. Request: 'set as default' option in all tabs for queries. So everytime I connect all tabs will be loaded with queries which I use most frequently.
5 people found this review helpful
Did you find this helpful?
Robro
September 2, 2020
thanks :) good idea ! i will take a look at it. but i don't know if i can map the content of the tabs to different connects. edit: i have uploaded a new version with the possibilty to activate in settings a reload of the last used sql files at program start. it is a general on/off option. hope this helps a little bit...
A Google user
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
4 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.52
- new android requirements minimum target >= 33
- bug fixes
V2.51 and before
- changing permissions for using external storage on android 10 and higher
- 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