Database Workbench is a complete database development environment offering you many features and tools. For the differences between the editions, see the feature matrix.

The following sections is are available here:

  1. Why use Database Workbench?
  2. Feature Highlights: design, implement, debug and maintain
  3. Detailed demo-videos of functionality in Database Workbench
If you have questions, feel free to ask via our contact page.

Why use Database Workbench?

Unicode Enabled

Database Workbench is fully Unicode enabled, it can create, display and edit Unicode data and even meta data.

Exporting Unicode data, importing Unicode text files or transferring Unicode data between database systems: it's all available in Database Workbench.

Consistency across different DBMS versions

If you use multiple database systems or multiple versions of those systems, you know that the vendor tools often differ between versions, are incompatible with each other and differ a lot between vendors.

Database Workbench offers a consistent user interface across database system versions and across the different database systems from vendors.

Using a single familiar tool to do your work saves time and money and increases your working pleasure.

Well documented, free support and updates!

Database Workbench comes with comprehensive documentation, free support and free updates for a year!

Feature Highlights

Database Design

Database Workbench comes with database specific and database agnostic visual design tools.

With these tools, you can create a new database, even for multiple database systems from a single source, or generate a visual diagram from an existing database.

Alternatively, you can design the database elsewhere and implement it using the visual editors or database script.

Implementation

With it's visual editors and visual management tools and SQL and Script tools, you can easily implement your database design.

Via drag and drop editing, using SQL Insight, the Describe Companion and easy-to-use source code editors, you'll be able to do your work in an efficient manner.

Viewing object dependencies is easy and can be done in any object editor, as well as the database navigator.

Testing and Debugging

A built-in Test Data Generator allows for volume testing.

The SQL Editor comes with a visual query plan analysis tool, query statistics and visual query builder, as well as an execution timer. All the tools you need to profile your database queries.

And even debugging a stored procedure, function, trigger or package is easy to do with the built in debugging tool.

Maintenance

There are several simple monitoring tools in Database Workbench, suitable for database administrators.

And of course, you can always modify your existing database: the Database Compare tool can generate a change script, or you can use the Script Recorder to track your changes.

You can extract scripts for existing objects, or simply copy the change script from each object editor.

Demo Videos

SQL Insight and Join Completion

This video shows in detail how SQL Insight works in Database Workbench.

This includes filtering and Join Completion, a feature that uses existing foreign key constraints to help you to write your SQL statements.

Visual Query Builder

The Two-Way Visual Query Builder is a helpful tool when building complex queries.

You can easily create JOINs, UNIONs, grouping, use derived tables, sub-queries and much more.

Stored Routine Debugging

When you write stored routines, no doubt you make mistakes. The Stored Routine Debugger can help to get to the bottom of that.

This video shows how to step through routines, use the "trace into" feature, open objects for debugging and evaluate and modify variable values during debugging.

Looking for an easy-to-use stored code debugging tool?

Take a look at Hopper, our stand alone stored code debugger, available for MySQL, InterBase and Firebird.