ER Diagrams

Schema is represented in diagrammed layouts. Get a better understanding of the schema by creating multiple layouts, each focused on a specific part of the schema. The layouts and the schema structure will be saved in the DbSchema project file. Read more...

• Edit tables or columns directly in the layout, by double-clicking them.
• Create new foreign keys by drag&drop of one table column.
• View database data by clicking the table header with SHIFT+CONTROL pressed.
• Design schema offline and create it later in database
• Different diagram look and feels
• Draw foreign key line in table to table mode or pointing to each column
• Use different foreign key notation: Idefix, Barker, etc.
• Use for each table a different color, place comment callouts.

Reverse Engineer Schema From Database

New projects can be started by reverse engineering the schema from the database. The schema structure will be saved to project file and can be later reopened without connecting to the database.

• Connect to any relational database using JDBC drivers.
• Upload any JDBC driver in DbSchema
• Add a new database to the list of supported databases
• SSH connections
• Customize of queries to reverse engineer triggers, functions, procedures, constraints
• Save of reverse engineered database schema to project file
• Reopen saved project file without connecting to the database

Relational Data Browse

An amazingly simple and efficient relational data explorer that offers simultaneous views of data from multiple tables and features numerous filters, data sorting mechanisms, and much more.

• Unlimited size of browse tree
• Filter table data
• Insert data in the browse table
• Save browse tree in project file and reopen it later
• Optimized memory usage
• View Blob or Clob data from database
• Easy way of searching data in the database
• Printing

Query Builder

Graphically compose SQL queries. You can make use of different join clauses like left outer join, use where filters or generate group by queries. Tables can be added by drag and drop or by pressing the foreign key icon. Read more...

• Edit complex queries using the mouse
• Select the query columns
• Dynamically add new tables to the query
• Use Group By conditions into the query
• Set query Where conditions
• Execute the query
• Preview the query SQL

SQL Editor

Sql editor with syntax highlighting and code completion may help you to edit and execute SQL. It can execute simple queries as well as scripts. The output can be displayed on screen or spooled directly to a file. It can do graphical explain plan. Read more...

• Edit queries using autocomplete
• Highlight of SQL keywords
• Execute single queries as well as scripts
• Explain query execution plan
• Use multiple result panes
• Spool result to file as CVS, Excel, Tab delimited, etc

Generate Schema Scripts

In DbSchema you can generate the schema scripts and optimal export the data into script. Using the generated script you can recreate the schema on any database.

Schema Synchronization

DbSchema is using its own image of the schema stored in the project file. Schema can be edited without connecting to database saved to file. Than connect to database ( can be a different database ) and synchronize the schema. Decide for each table, column, etc. which is missing on database or local project to create it or drop it on one side ( from database or from local project ). Read more...

• Reverse engineer the database schema from database
• Synchronize the database schema with the database
• Choose for each difference found an action : 'Merge into local project', 'Change the database' or 'No action'
• Generate a SQL script for the database modifications
• Compare schemes from two DbSchema project files
• Use DbSchema to update the database to the latest schema version
• Have one central project and multiple databases
• Convert the schema to a different database

Convert Schema to a Different Database

Since the DbSchema project is independent from database you can change the project Rdbms in Project Properties. Than you can create or synchronize your schema with a different database. Changing the schema Rdbms will apply a new data type mapping for all columns, based also on the standard java SQL data types.

Data Loader

Import data from delimited text, XML or Excel files into the database. Very easy to use, with data pre-validation.

Smart Printing

DbSchema can print the best layout images. You can also print the layouts as images or generate HTML documentation including small-size vector images.

• Preview the printed pages
• Choose a print zoom as well as the printed pages
• Best print quality

Graphical Explain Plan

The explain plan shows beside the original text returned by the database for the explain plan function a chart with the timeline distribution of the events. In the diagram are shown tips for each table or index access. This allows to easy identify the most consuming time events in the query and easy recognize the events which are accessing data.

Random Data Generator

Generate test data in the database. Configurable patterns including integer, random and reverse regular expression patterns can be used. A predefined repository of patterns will help in finding the best pattern for each column.

Documentation

You can enter comments or call-outs for any of the schema tables, columns, etc. Moving the mouse over the layouts you will see this comments as tooltips. This may help you easy understand the tables and columns definition.

• Two documentation formats: HTML5 or HTML4
• Layout image included
• Small size images through use of SVG
• Interactive image. Move the mouse over columns in the image and read schema comments

Design Schema in a Team; Store Project File in GIT or SVN

DbSchema holds its own image of the schema, beside the schema in the database. This image is saved together with the layouts and tools ( SQL Editor, Query Builder, Relational Data Editor ) to project file. The project file is a text file in XML format. It can be opened with any text editor. This file can be shared in a Subversion repository ( Git, Svn, Mercurial, etc. ). This way you can control different versions of the schema at different point in time.

Automation Scripts

DbSchema can be started in non-interactive mode and automatically execute Groovy scripts. The script have full control over the DbSchema logic, so it can reverse engineer the schema, generate documentation, etc. This way different operations an be automatized.

Forms and Reports

Using DbSchema you can build small applications or create reports with multiple master-detail sections. The Forms engine is pretty powerful and simply to use. Internal scripts can be used to model the form or report logic, with JavaScript or Groovy.