DbSchema Interface

DbSchema is an easy to use database designer that allows users to easily manage complex databases. The tool allows users to browse and edit data visually, without having to write 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 Layouts. 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:

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 at schema navigation. This is especially useful in case of complex models.
  2. In the center of the you'll find two main things:
    • Layouts - this is where you can see the schema with all it's 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 Browse, 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

With Interactive Layouts you can edit tables, columns and foreign keys directly in the layout. This feature enables to do everything visually, without having to write SQL Queries.

Relational Data Browse

This powerful data explorer enables you to browse and edit data from multiple tables simultaneously. There is no limit on how many tables you can explore in the same time.

Schema Synchronization

DbSchema stores the schema in its own model file (.dbs). This allows you to open and edit the project offline, without 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 the database you're working with in our driver list, upload it's driver in DbSchema and connect.

Visual Query Builder

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

Schema Documentation

DcSchema can generate interactive schema documentation as:

SQL Editor

Execute queries and generate plans with a powerful SQL editor.

Forms & Reports

Build small applications or create multiple master detail sections using our powerful form engine.