SQLTool allows you to connect to any MySQL, MariaDB, Derby, Microsoft SQL Server, PostgreSQL, Sybase, or Oracle database.
Connections happen without a web service so you can have peace of mind that the only place your information is going is to the location you specify. Many mobile database management applications contact someones web server to process SQL information and in these scenarios you must trust that person with your sensitive information while relying on the quality of their web server. SQLTool does a direct connection so you don't have to worry about trust or server quality.
SQLTool supports most SQL queries for your specified database. For example: select, insert, update, delete, create, alter, and drop queries are all supported. You can use SQLTool's custom statements like desc and export to perform various tasks as well.
The only major limitation SQLTool may run into is the quality of network connection. Large queries require a stronger network connection such as wifi rather than 3G because of how much data is being transmitted. To respect everyones network connection SQLTool, by default, does thirty row queries unless using the query editor. If you use the query editor feature of SQLTool you can query for as many rows as you want. However, it is recommended to always limit your results because certain devices may not be powerful enough to process huge amounts of data.
SQLTool supports SSH tunneling with password authentication as well as key pair authentication. When connecting with password authentication, use the SSH server username and password as your credentials. When connecting with key pair authentication, use the private key password as your password.
SSH key pairs must be generated using OpenSSH format. The recommended key strength is 2048.
Oracle databases higher than version 10.1 do not play nice with Android. Because of this, we have determined it was in everyones best interest that we exclude support for Oracle 10.2+. We would rather everything perform appropriately and give all our users a perfect experience.
We know your pain. Typing queries on a mobile device is difficult, but this is why we created SQLTool's query builder. The query builder contains buttons representing common SQL keywords. Tapping a button will result in the keyword being inserted into the editor. Being able to freely enter text and make use of the hot-keys makes designing queries a breeze.
We encourage you to use SQLTool on both local and remote databases. Just make sure that your remote databases allow for remote connections. If your databases don't allow for remote connections see if SSH tunneling is a valid solution for you.
SQLTool supports any Android device running 2.3 and higher. This includes tablets, mobile phones, and even the Amazon Kindle Fire.