Db2 Database Designer & Query Tool

Build visual schemas & diagrams for Db2.
Interact with the diagram to browse & edit complex databases.

Download DbSchema

Better Database Design

Db2 Diagram

Diagrams in Db2

DbSchema can create a virtual schema just by connecting to Db2. This will help you to:

  • Visualize your Db2 databases using diagrams;
  • Document the schema and generate HTML5 interactive documentation;
  • Keep track of the schema changes;
  • Open the schema design without database connectivity (offline).

Documentation & Layouts

Split complex databases to multiple layouts (groups of tables).

Layouts can be exported to an interactive HTML5 documentation where you can include comments to tables or columns.

Just try it on the image on the right.

Db2 Layouts

Browse Multiple Tables Simultaneously

Build Multiple Queries Visually

Text Editor

Db2 Relational Data Browse
Db2 Visual Query Builder
Db2 SQL Editor

Use Relational Data Browse to view & edit data from multiple tables at the same time. Learn More

Visual Query Builder enables you to build complex queries without having to write SQL Syntax. Learn More

Use the powerful Text Editor with autocompletion. Learn More

Improve Your Workflow

Work Together With Your Team

DbSchema saves a local copy of the schema to a project file.
This approach makes it possible to:

  • Design schema without database connectivity;
  • Use GIT or any other versioning system to work on the project file with your team;
  • Open the project file with any text editor as XML;
  • Deploy one schema on multiple servers
  • Migrate one schema between different versions of the project file and generate migration scripts
Learn More
Db2 Schema Synchronization

Export layouts to HTML5 documentation

A layout is a group of tables focused on a specific part of the database. With DbSchema, you can export layouts to interactive HTML5 documentation, add comments, and share them with your team. Learn More

Refresh, Compare & Synchronize

DbSchema uses project files to store the local image of the schema so you can work offline and synchronize it with the database later. Learn More

Db2 Schema Synchronization

Db2 Reverse Engineer the Schema

Reverse Engineer the Schema

Use DbSchema to reverse engineer the schema from your Db2 database.

Start designing now and benefit from:

All Databases Included

DbSchema licenses are valid for all supported databases.

Technical Support

Registered and unregistered users may benefit from technical support.

Full Compatibility

DbSchema works on Windows, Mac, and Linux