SoftTree SQL Assistant

SoftTree SQL Assistant is an application that integrates with popular database editors, managers and development environments and allows you to enhance the quality of the databases you create.

The utility provides you with support for Microsoft SQL server, PostgreSQL, Oracle, IBM DB2 and Sybase ASE. As an assistant, the application helps you with code navigation and syntax checking functions, as well as code performance analysis and real-time suggestions.

For both SQL and non-SQL editors, SoftTree SQL Assistant offers a set of editing, data viewing and scheduling functions that can greatly increase your coding rhythm.

To connect to a database, you can use either the ODBC or ADO.NET interface, as well as native interfaces such as those for MySQL Connect and Oracle OCI.

Once installed, SoftTree SQL Assistant starts immediately after you login to your Windows account and resides patiently in the system tray. It’s from there you can suspend its activity and access settings. And speaking of, the utility provides you with a large amount of detailed settings that you can change to match your work style. The application also comes through if you need help with code formatting, refactoring, snippets unit tests.

A feature that SoftTree SQL Assistant poses and is sure to enhance your productivity is code Intellisense. It automatically offers you suggestions for code matching and auto-completion as you type into your editor. Intellisense uses various prompting methods and tooltips to display these suggestions along with information about statement syntax, columns, parameters and reference objects.

Because your database editors have different interfaces and vary in the way they are structured, it’s only expected that the assistant window differs from one editor to the other. SoftTree SQL Assistant can be displayed as a docked window, which appears on one side of the workspace, or as a popup that you can freely move around.

With the above to consider and much more to discover, SoftTree SQL Assistant is definitely a practical and indispensable tool for your database development.