SQLTool Pro Database Editor
Connect and manage MySQL, SQL Server, PostgreSQL, Sybase ASE, MariaDB, Derby, and Oracle databases from your Android device.
SQLTool is a database SQL editor with rich features that include:
* Export table row data to a CSV file
* Customize-able SQL queries using the query editor
* Full table listings of each database
* Quickly empty or drop tables from the MariaDB, SQL Server, MySQL, PostgreSQL, Sybase ASE, Derby, or Oracle databases
* Blazing fast select, insert, and update database queries
* Different user interfaces for tablets and phones
* SSH tunneling for accessing protected databases
SQLTool does NOT work with Oracle 10.2 and higher. It will work with Oracle 10.1 and below.
Oracle, MySQL, MariaDB, Sybase ASE, Derby, PostgreSQL, and SQL Server databases can be managed using the query editor or through a limited amount of built in shortcuts.
SQLTool DOES NOT connect to any external web service. All database connections are direct based on the information provided enabling quick SQL queries while keeping your information safe from third party web servers.
SSH Tunneling supports password authentication and public key authentication. Public key authentication requires private keys to be generated in OpenSSH format. Recommended encryption strength on keys is 2048. Private keys must be saved to the SQLTool directory on your devices internal storage and the key must have a .key extension.
If you need help troubleshooting SQLTool, contact me via the product website before leaving a negative review. I would be happy to help anyone having trouble.
To use SQLTool your database and database server must be configured to allow remote connections. If this requirement is not met, SQLTool will fail to connect.
Category : Productivity
Reviews (28)
It's just a viewer really - yes you can write any query you like but I was expecting to be able to tap on a row to change its value via the GUI, and sort by column headings with a tap without having to write queries for these basic operations.
I need to connect to Oracle 10 for supporting a customer, so this was the only reason I bought it and the app cannot connect to this version, so I waste my money :(
This app is great for viewing tables but not running queries. I entered a query, pressed the 'play' button and nothing happened. I had to go to another app to do that
Ad far as db goes, this is perhaps the best choice for a mobile device, but for an actually dba, it lacks some cool features that should be added in the future
Honestly, this app isn't too bad. It does what I need (running basic queries while on the toilet at work), and is simple enough to use on a mobile phone. I wasn't expecting a full fledged db management studio, nor would I really want that on my phone. Great job!
Great app. You have to already know how setup a Db connection and create your own sql script to make full use.
Would not connect to a fresh Oracle database. I suspect the Oracle driver hasn't been updated in a while.
It seems to be a nice app, sadly, I can't test it since it doesn't support hyphens(-) for database names. It also doesn't allow me to just fetch the list of databases instead.
Can't select a schema for PostgreSQL that makes this tool useless for me.
No frills, does the job well.
This. App is not an editor!
Best app..like this
I just saw that it does not connect to Oracle 10.2 and I am receiving the error length=0; index=-1 and the DB that I am trying to connect to is a 10.2 version. Will it be able to connect to the 10.2 version in the future? If not can I refund my paid amount please. Is there any other application for Android that connects to the Oracle? Thanks in advance.
This app is awesome. In combination with Junos Pulse, now I can connect directly from tablet to my database.
Very neat presentation and great for viewing data and running scripts but does not give anything like the tools expected by the Windows user. Hopefully it will develop in time.
I'm a novice at using actual queries to build and fill tables so its been a good learning environment.
What does the error length=0; index=-1 ' when connecting to oracle means? Oh... It doesn't work with Oracle 11g. Estimates on when it will work?
Love the fact I can see my databases on the train
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production I try to connect to my office DB Server, SQLTools showing "length=0; index=-1" error message.
Getting issues connecting to postgres?
This works exactly as you would hope it would. If you need database access from your phone this does just the trick. I had some trouble connecting at first and the developer was extremely responsive. Thanks, Nic. Very highly recommended.
It's not just app you will get, the support by developer is awsome and excellent. If you need to access your database on the go especially via ssh, this is the app you need to purchase now.
This is very useful apps i use it only one time with simple updating of databases via ssh. hope you could include functions and store procedures modification or adding fn and sps.
Took ages to work out that when connecting via ssh the mysql server ip has to be 'localhost' or it refuses to work.
Great tool well worth the money
This Is A Good Product
Just the tool for quick queries to a server. I need to keep on top of some processes on a MySQL server, and the bookmarks in this app make it pretty painless.
Refunded. Refuses to connect to a single DB. Was hoping this would work for my job, but alas, useless.