DbSchema Features

DbSchema Video Presentation

Interactive Diagrams

DbSchema is using layouts (diagrams) to interact with the schema. Tables, columns and foreign keys can be created and edited directly in layouts. For a better understanding large schemes can be represented over multiple layouts, each with the same or different tables. The layouts will be saved to model file and can be later reopen. Read Documentation

  1. 1
    Edit Tables in Diagram

    Double-click any table directly in 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 and the tooltip will show.

  4. 4
    Show/Hide Column Data Type

    One of the menu buttons allows to show or hide the data type.

  5. 5
    Design Schema Offline

    The DbSchema model can be open and edited without database connectivity (offline).

  1. 6
    Draw Foreign Key Lines Pointing to Columns

    Foreign key lines can be drawn from table to table or from column to column.

  2. 7
    Change Foreign Key Notation

    Use different foreign key notation: Idefix, Barker, etc.

  3. 8
    Create Callouts

    Comments can be added as callouts in the diagram.

  4. 9
    Create Groups of Tables

    Tables can be grouped together. 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. Save the schema structure to the model file and you can reopen it without database connection. 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 on our drivers list, upload its JDBC Driver in DbSchema

  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 is using it's own model with a copy of the schema structure. This enables you to open and modify the schema offline, then synchronize it when you connect to the database. Read Documentation

  1. 1
    Control Every Action

    Choose what happens with each difference found in the schema.

  2. 2
    Convert Schemas

    Easily convert your schema to a different database.

  1. 3
    Generate SQL Scripts

    You can generate SQL Scripts for every database modification.

  2. 4
    Update Schema

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

Schema Synchronization

Visual Data Explorer Relational Data Browse

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, you can create virtual foreign keys. The Relational Data Browse can be also used 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

  3. 3
    Pick Up Where You Left Off

    Your data browse editor will be saved in the project file so you can access it next time you start DbSchema.

  1. 4
    Make Your Browsing More Relevant

    Apply filters and data sorting mechanisms to browse 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 from Database

    Easily access BLOB or CLOB files in DbSchema

Relational Data Browse

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

    Tables can be joined using normal or virtual foreign keys.

  2. 2
    Join Clauses

    Can switch between LEFT, OUTER and EXITS 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 highlight, query and script execution, graphical explain plan, save results to CSV or XLSX files. Read Documentation

  1. 1
    Syntax Highlight

    Editor works fine on large and very large files, with syntax highligting active.

  2. 2
    Execute SQL Queries

    Execute SQL Queries and show result as table

  3. 3
    Execute Scripts

    Executing scripts will show the result as one text file

  1. 4
    Save result to CSV or XLSX files

    The query result can be exported to external file

  2. 5
    Graphical Explain 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

    See and organize patterns from pattern repository.

Data Generator

Data Importer

Import data from various files in to the database. Read Documentation

  1. 1
    Support CSV, XML, XLS, XLSX

    Most common CSV and Excel files are supported.

  1. 2
    Use Batch processing

    This speedup the import process.

Data Importer

Database Forms & Reports Designer

DbSchema integrates a very powerful and fully customizable Forms & Reports Engine which can generate web-responsive forms and reports. Read Documentation

  1. 1
    Create Multiple Master Detail

    Create master details table in reports.

  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 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 then this, they show a 'relation' between two columns of two different tables. If your database is missing foreign keys, you can create virtual foreign keys which will be displayed in the diagram. Virtual foreign keys will be saved to model file. Read Documentation

  1. 1
    Virtual Foreign Keys helps to Understand the Schema

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

  2. 2
    Will be saved to model file

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

  1. 3
    Are used in Relational Data Browse

    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 access direct to DbSchema API. This will help to solve different tasks without visual interaction. Read Documentation

  1. 1
    Automate Reverse Engineer of the Database Structure

    Reverse engineer can be started from a Groovy script.

  2. 2
    Generate HTML5 Documentation

    Write scripts which generate HTML5 or PDF documentation.

  1. 3
    Synchronize Schema

    Script schema compare and synchronization

  2. 4
    Deploy Schema

    Automatic deploy schema on different databases.

DbSchema Process Automation

Dark Theme

DbSchema integrates multiple themes so you can personalize your interface.

DbSchema Dark Theme