SQL Explorer

SQL Explorer is a practical and reliable application that comes in handy for users who need to manage multiple database connections, create new SQL queries and execute them using a simple and intuitive interface.

Because it supports various plugins for individual databases, be them Oracle, MySQL, SQLite, or PostgreSQL, the application allows you to add multiple connections and manage different databases effortlessly.

When you launch SQL Explorer for the first time, you need to create a new connection, otherwise you won’t be able to perform any task.

The Connections panel displays all the connection profiles that you have set up. Also, in this section you can create new profiles, start new database connections or stop them.

However, before creating a new connection profile, you need to configure all the JDBC drivers you are interested in. This task can be performed by accessing the Preferences window. After the profile has been created, you can open a new connection to the database by double clicking on the entry.

The ‘SQL Editor’ window that will open when you create a new connection profile enables you to write and execute SQL scripts, save them to a new TXT file and view all the generated data in the Console section, which is located at the bottom of the program.

In case you want to view every statement that was successfully executed, you can navigate to the ‘SQL History’ section. You are able to view the statements, the date and the time when they were last executed and which connections were used.

Using the ‘Database Structure’ view you can explore multiple databases simultaneously. When a node is selected, all the corresponding details are expanded and displayed in the database detail view.

All things considered, SQL Explorer is a reliable and effective utility that comes in handy for administrators who need to manage multiple database connections and execute SQL scripts.