To sum things up, Portable Database Browser is a practical and effective software solution that comes in handy for users who need to connect to multiple database and manage various tables, execute SQL statements and export the entire data with ease. What’s more, you are able to view all the available SQL statements, system tables and connections, as well as create new SQL queries. This way, each time you want to run a script, you can easily preview if it works or if it requires special attention. However, you can also customize your own SQL queries, then select the ‘Execute’ menu and access one of the four listed options.Īt the bottom of the application you can view the ‘Execution Log’ console that displays information about each table status and executed SQL queries. This is the only SQL client which is supported and developed by MySQL, so you can be sure that it will contain all recent features to match the updates for MySQLs server. The ‘SQL’ panel contains a simple SQL query that displays all the existing data in the current database. Cross platform - versions available for Windows, Linux and Mac OS. You can also secure the connection between these apps by specifying the SSL key and the SSL certificate.

Select the connection type, specify the host name and the port number, then choose the database you want to display in the main window of the application. Simply navigate to the left panel of the utility and create a new connection. The application sports the exact same functionality as the standalone edition, although we dare say it is even more advantageous than the latter, since it does not affect your computer’s registry and you can carry it around on a removable drive. Irrespective of which databases you want to connect to, be them MySQL, PostgreSQL, Oracle, SQL Server or SQLite, Portable Database Browser is geared towards users who need to run SQL scripts, create views (known also as virtual tables) and generate procedures using an intuitive environment. Portable Database Browser is a reliable and useful utility that allows you to connect to multiple databases and manage various tables effortlessly.

Mysql query browser download