DbSchema Features

DbSchema Video Presentation

Interactive Diagrams

DbSchema uses layouts (diagrams) to interact with the schema. You can create and edit the tables, columns, and foreign keys directly in layouts. For a better understanding, create multiple layouts, each with the same or different tables. Saving the DbSchema model will also save the layouts, so they can be reopened later. Read Documentation

  1. 1
    Edit Tables in Diagram

    Double-click tables directly in a diagram to edit.

  2. 2
    Create Foreign Keys by Drag & Drop

    Drag&drop one column over a primary key column.

  3. 3
    Read Column Type and Comments as Tooltip

    Hover the mouse over columns for the tooltip to show.

  4. 4
    Show/Hide Column Data Type

    Menu buttons allow hiding column data type for a more concise representation.

  5. 5
    Design Schema Offline

    You can edit the DbSchema model without being connected to the database (offline mode).

  1. 6
    Draw Foreign Key Lines Pointing to Columns

    Choose to draw the foreign key lines from table to table or from column.

  2. 7
    Change Foreign Key Notation

    Represent the foreign key using different notations: Idefix, Barker, etc.

  3. 8
    Create Callouts

    You can add layout comments as callouts.

  4. 9
    Create Groups of Tables

    Tables can be grouped. The group color is customizable.

Connect to any Database & Reverse Engineer the Schema

Start a new model by reverse-engineering the schema from the database. Saving the DbSchema model to file allows us to reopen the schema design from any computer, without database connectivity. Read Documentation

  1. 1
    JDBC Drivers

    Connect to any relational database using JDBC Drivers.

  2. 2
    Add Your Database

    If the database you're working with is not listed on our driver list, you can upload its JDBC Driver directly in DbSchema and connect it to the database.

  1. 3
    Edit Schema Offline

    Open and edit your schema without being connected to the database.

  2. 4
    SSH Connections

    Work on your database through secured connections.

Reverse Engineer the Schema

Choose the Preferred Connection Method

Connection Type

Schema Synchronization

DbSchema relies on its own model containing a copy of the schema structure. You can open and modify the schema offline, then connect to the database and synchronize the schema. Read Documentation

  1. 1
    Control Every Action

    Choose an action for each difference between DbSchema model and the database.

  2. 2
    Convert Schemas

    Easily convert your schema to a different database.

  3. 3
    Generate SQL Scripts

    You can generate SQL Scripts for every database modification.

  1. 4
    Update Schema

    Use DbSchema to update the database to the latest schema version.

  2. 5
    Schema Migration

    Compare two different versions of the model file and generate migration scripts.

Schema Synchronization

Visual Relational Data Explorer

Visually explore data from multiple tables simultaneously, based on foreign keys. There is no limit to how many tables can be opened at once. If the database is missing foreign keys, create virtual foreign keys in DbSchema. Use the Relational Data Explorer also to edit the data from the database. Read Documentation

  1. 1
    Cascade Into Multiple Tables

    View data from multiple tables simultaneously based on normal or foreign key relationships.

  2. 2
    Edit Records with One Click

    Double click any cell to edit its value.

  3. 3
    Pick Up Where You Left Off

    Your data explorer will be saved in the model file so you can access it next time you start DbSchema.

  1. 4
    Make Your View More Relevant

    Apply filters and data sorting mechanisms to explore data more efficiently.

  2. 5
    Create Virtual Foreign Keys

    If your schema is missing foreign keys, create virtual foreign keys. They also can be used in relational data browsing.

  3. 6
    View Images stored in the Database

    Easily access BLOB or CLOB files in DbSchema.

Relational Data Explorer

Visual Query Builder

Build SQL Queries visually without having to write any line of code. Add and edit tables with a simple click. Read Documentation

  1. 1
    Use Virtual Foreign Keys

    Join tables using foreign key constraints or virtual foreign key constraints.

  2. 2
    Join Clauses

    Choose between LEFT, OUTER and EXISTS joins

  1. 3
    Group By Conditions

    Make use of COUNT(*), AVG(), SUM()

  2. 4
    Where Filters

    Set filters on columns

Visual Query Builder

SQL Editor

Editor features syntax highlighting, query and script execution, graphical query explanation plan, and the option to save results as CSV or XLSX files. Read Documentation

  1. 1
    Syntax Highlight

    The editor works fine on large and very large files, with syntax high-lighting active.

  2. 2
    Execute SQL Queries

    Execute SQL Queries and show the result as a table.

  3. 3
    Execute Scripts

    Executing scripts will show the result as a text file.

  1. 4
    Save result to CSV or XLSX files

    The query result can be exported to external files.

  2. 5
    Graphical Query Execution Plan

    Active for many databases, will show the query execution plan.

SQL Editor

Data Generator

Generate test data in your database using configurable, random, and reverse regular expression patterns. A predefined repository of patterns will help you find the best data pattern for each column. Read Documentation

  1. 1
    Predefined Patterns

    DbSchema offers a wide variety of predefined patterns.

  2. 2
    Auto-Fill Patterns

    DbSchema analyzes the column name and anticipates the data type.

  1. 3
    Edit Table Patterns

    Add a new pattern or edit existing ones.

  2. 4
    Access Pattern Repository

    View and organize patterns from the pattern repository.

Data Generator

Data Importer

Import data from various files into the database. Read Documentation

  1. 1
    Support CSV, XML, XLS, XLSX

    The most common CSV and Excel files are supported.

  1. 2
    Use Batch processing

    Batch processing speeds up the import process.

Data Importer

Database Forms & Reports Designer

DbSchema integrates a powerful and fully customizable Engine that can generate responsive forms and reports for the web. Read Documentation

  1. 1
    Create Multiple Master-Detail

    Designer panels and tables can be embedded in one another.

  2. 2
    Build small applications

    The applications can make use of input fields, buttons, charts, and more

  1. 3
    Deploy on Tomcat Server

    The forms or reports can be deployed as a stand-alone server application.

  2. 4
    Run the forms and reports in web

    The forms and reports are responsive web applications using Bootstrap.

Database Forms & Reports Designer

Virtual Foreign Keys

Foreign keys are used to ensure data accuracy and consistency in the database. More than this, they show a 'relation' between two columns of two different tables. If the database is missing foreign keys, create virtual foreign keys that will be displayed in the diagram. Virtual foreign keys will be saved to the model file. Read Documentation

  1. 1
    Virtual Foreign Keys help to understand the Schema

    They are a good representation of the relationship between data fields.

  2. 2
    Will be saved to model file

    Virtual foreign keys don't get lost! They will be saved to the model file.

  1. 3
    Are used in Relational Data Explorer

    Use virtual foreign keys to explore data from multiple tables simultaneously

  2. 4
    Are used in Visual Query Builder

    You can join tables in the Query Builder using virtual foreign keys.

Virtual Foreign Keys helps to understand the database structure

Automate Schema Deployment & Tasks

DbSchema can execute Groovy or Java Scripts with direct access to the DbSchema API. This will help to solve different tasks without visual interaction. Read Documentation

  1. 1
    Automate Reverse Engineering of the Database Structure

    Reverse engineering can be started from a Groovy script.

  2. 2
    Generate HTML5 Documentation

    Write scripts that generate HTML5 or PDF documentation.

  1. 3
    Synchronize Schema

    Script schema compare and synchronization

  2. 4
    Deploy Schema

    Automatically deploy a schema on different databases.

DbSchema Process Automation

Dark Theme

DbSchema integrates multiple themes so you can personalize your interface.

DbSchema Dark Theme