The Aginity Workbench is a Microsoft Windows-based tool which provides basic database querying along with advanced features that help server administrators and developers harness the power of their data warehouse.  It has an intuitive interface for creating, managing and tracking both individual SQL queries and entire databases.

The application can be installed on any platform that supports .NET Framework 3.5 service pack 1, for example the following platforms:

We have added New Beta Features to the Workbench:

• More powerful grid for the Query Analyzer;
• Aggregated values for selected cells are displayed in the status bar of query analyzer;
• Additional  support for Data Bars for numerical columns in results grid;
• Functionality for highlighting the db selector and query editor for selected databases;
• Frequency distribution and Pareto charts for numeric columns in results grid;
• Frequency distribution chart for numeric table/view columns;
• Functionality for filtering entity lists by schema/name;
• Menus for generating UPDATE and DELETE statements;
• Menus for generating scripts to new query window;
• Options for customizing display format for integral/numeric columns in results grid;
• Reverse engineering of Oracle and MySql databases;
• Added an option for grouping database entities by schema it object tree;
• Added terminal component for connecting to the host OS over SSH;
• Query Sets and SQL files can be opened without connecting to a database now;
• Added an option for enabling drag and drop in SQL editor;

And we have implemented:

• Initial version of code auto-completion;
• Query parameters ($param_name style);
• Code snippets (customizable through Tools / Options);
• Support for bookmarks in Query Analyzer;
• Options for switching off/on obtaining DB sizes in object tree;
• Options for switching off/on obtaining entity counts in object tree;
• Options for double-click actions in object tree;
• Integration with external file diff software;
• Closing the result tabs;
• Reordering query tabs using drag and drop;
• Pin for the result data tabs;