DbSchema Interface

DbSchema is an easy to use database designer that allows users to design and manage databases. The tool allows users to visually browse and edit the data, without writing complex SQL Queries.
Here, we will go through some basic characteristics of the interface. Also, we will present some of the important features of DbSchema.

DbSchema offers a functionality called Interactive Layout. It allows you to divide the schema into multiple groups of tables (layouts) for a better representation of the database. The advantages of using Interactive Layouts are:
  • Create multiple layouts, each focused on a different part of the schema;
  • Edit table, columns, and foreign keys, directly into the layout with a simple click;
  • Layouts are saved to a model file (.dbs), that can be reopened and edited in offline mode.

The interface has a very simple structure:

  1. On the left side of the screen:
    • Tree Pane - offers an overview of the model and schema, tables, etc..
    • SQL History - shows the SQL Queries generated by every visual action executed in the layout or data tools.
    • Diagram Perspective - Helps to navigate the diagram, especially when the diagrams are large.
  2. In the center of you'll see:
    • Layouts - this is where you can see the schema tables and columns. You can create multiple layouts of the database to focus on different parts of the project.
    • Data Tools - this section is at the bottom of the screen. From here you can use different features of DbSchema like Relational Data Editor, Visual Query Editor, SQL Editor, and more.

DbSchema Database Designer Interface

Key Features

DbSchema has some key features that will help you easily manage complex models.

Interactive Layouts

Edit tables, columns, and foreign keys directly in the layout. You can do everything visually, without having to write SQL Queries.

Relational Data Editor

This powerful data editor enables you to visualize and edit data from multiple tables simultaneously. There is no limit on how many tables you can explore simultaneously.

Schema Synchronization

DbSchema stores the schema in its own model file (.dbs). This allows you to open and edit the project offline, without a database connection. When reconnecting to the database, you can synchronize the schema by comparing the schema definition and merging the differences. You can also connect to multiple databases and synchronize the schema with any of them.

Full Compatibility with Relational Databases

DbSchema can connect to any relational database using JDBC drivers. If you can't find your database in our driver list, upload the JDBC driver in DbSchema and connect.

Visual Query Builder

With DbSchema, you can visually execute complex queries using INNER, OUTER and EXISTS joins, filters, and group by.

Schema Documentation

DcSchema can generate interactive schema documentation as:

  • PDF Document
  • HTML5 Web Interactive Graphic Image
  • Printed Paper

SQL Editor

Execute queries and generate plans with a powerful SQL editor.