QueryAnalyzerPlus

QueryAnalyzerPlus is an easy-to-use application that provides a graphical interface for establishing connections to databases. It offers support for Microsoft Access (MDB format), SQL Server Compact (SDF format), SQLClient (SQF format), and SQLite files.

Requires .NET Framework to work properly

Installing the program isn't necessary because you can directly run the .exe from the downloaded package. However, make sure your PC is equipped with .NET Framework or it won't work properly. It's also possible to save QueryAnalyzerPlus to a USB flash drive to seamlessly launch it on any PC.

Set the database connection details

The main app window has a simple look and neatly structured layout, where you can begin by configuring database connection settings. Depending on the database type, you can specify the connection display name, indicate the file path, and enter the password. If you don't want to make any modifications, make sure to check the "read-only" box.

View tables, procedures and views

Once linked, you can explore the existing tables, procedure and views, enter and execute SQL statements, as well as export the code to C#, Visual Basic .NET or Visual Basic 6 format. In SQL server mode, the INSERT, UPDATE and SELECT procedures are automatically generated so you just have to fill out the missing data.

Write and run SQL statements, create and enable plugins

Moreover, you are welcomed to create your own plugins using .NET, then enable them from the tree view of QueryAnalyzerPlus. Several samples are available in the downloaded package to give you an idea of how this works (e.g. for copying field names to the Clipboard).
Last but not least, the developer provides direct access to various websites containing instructions on writing SQL code for Access, SQLite, SQL Server Compact, and the others.

Simple and practical query analyzer

It worked smoothly on Windows 10 in our tests and we haven't come across any errors. Thanks to its straightforward approach, QueryAnalyzerPlus should please many users looking for a simple way to connect to database files and make adjustments.