DbSchema: Db2 Admin GUI Tool & Database Designer

  • DbSchema is a Db2 diagram-oriented database designer with integrated tools for query and data. DbSchema is build for large diagrams and schemes. No Db2 database experience required - the tool is visual.
  • DbSchema is managing its own internal copy of the schema, distinct from the database. This makes possible to design a schema and deploy it on multiple databases, generate migration scripts or share the design project file in a team.
  • Db2 connectivity is described on JDBC driver page.

DbSchema Database Tool

Best Db2 Diagrams

Db2 Diagram Designer DbSchema has the market best Db2 interactive diagrams. The designer can display diagrams with more then 1000+ tables.

  • The layouts (diagrams) will can be saved to project file and reopen next time you access the application
  • HTML5 documentation with interactive vector image can be exported. Sample here.
  • Foreign keys can be drawn using different notations, with lines pointing to tables or to columns.
Read more »

Relational Data Browse

Db2 Data Explorer Relational Data Browse is a visual data explorer from multiple tables at a time. The explorer is using the foreign keys between tables to cascade from table to table and simultaneous explore data. If your project is missing foreign keys you can create virtual foreign keys in the layout.

Using Relational Data Browse you can also edit the database data or insert new records.

The editor will be saved to project file and reopen next time as it is. In this way you can build different perspectives over the data and reuse them whenever you need.

Read more »

Deploy Schema on Multiple Databases

Convert Schema to Db2 DbSchema manages its own image of the schema and saves it to XML project file. This makes possible to design schema in a team and deploy it on multiple databases.

New projects can be started by reverse engineer schema from the database or design offline. In both cases an internal schema, distinct from the database, will be created.

To refresh the internal schema from the database you have to press 'Refresh schema from database' from the menu. At this step you can decide which changes to take over in the internal project or push in the database. The project file can be shared in a team using versioning systems ( GIT, SVN, etc.).

Read more »

Db2 Visual Query Builder, Query Editor and Random Data Generator

Db2 visual query builder and query editor

  • Visually create SQL queries using the query builder. Multiple JOIN clauses can be used, including LEFT OUTER JOIN, EXISTS, etc. or group by clauses. The joins are using the foreign keys or virtual foreign keys.
  • The Query editor with text-autocompletion, script execution and graphical explain plan.
  • Random data generator using reverse regular expressions and predefined patterns.

Read more »

Database Forms and Reports | Database Manager

Db2 Forms and Reports DbSchema Db2 forms and reports can be used to build applications or reports and run them as JavaFx or Web applications. Based on the forms designer we started building Db2 applications for space, permission and activity management.

Read more »

Start using DbSchema right now !

DbSchema can be evaluated 15 days for free.

DbSchema can run on all operating systems: Windows, Linux, MAC.

DbSchema Database Tool
Video Presentation