SQLRunner

SQLRunner is a lightweight application designed in Java to help you effortlessly work with databases without having to install complicated software. It comes bundled with many useful options to help you integrate code with existing Java classes, such as CSV importing and exporting abilities, predefined queries, data model options, and regex tester.

It might be necessary to configure Java settings and add the developer's website to the exception list to be able to launch SQLRunner. It has a user-friendly interface based on a standard window with a simple layout, where you can get started by opening an .sql file.

Alternatively, databases can be imported from Oracle, MySQL or via an ODBC driver. Syntax highlighting is supported. You can review history, insert new lines in the table, use a search function to quickly browse numerous lines of code, as well as import and export data in CSV and XML format.

Predefined SQLs can be added to the table while database metadata can be edited. You can configure data model settings, convert SQL to Java strings or StringBuffer variables, jump to lines, trim the source, or create new configuration files.

Extra tools are available for creating new GUIDs, transcoding Base64 code, testing regular expressions, as well as for converting text files, Talend schemas and dates. When it comes to program preferences, you can change the UI style, file encoding mode, line separator, window positioning, debugger, table settings (column width, row height) and editor options (font, anti-aliasing mode, highlighting the current line).

We haven't come across any compatibility issues with the latest Windows or Java edition during our evaluation. The software program had low impact on the overall performance of the PC and executed queries swiftly.

All aspects considered, SQLRunner is a simple and straightforward database manager for users who are avoiding complicated software.