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.
- 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.
From an created project you can connect to another database and synchronize the schemes.
Like you would synchronize a development schema with the schema on a production 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.
The data can be explored from multiple tables in the same time, based on the foreign keys between tables.
Virtual foreign keys can be created.
New records can be inserted, existing records can be edited.
- 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
Graphically compose SQL queries. You can make use of different join clauses like left outer join
filters or generate group by
Tables can be added by drag and drop or by pressing the foreign key icon.
- 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 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.
- 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.
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 ).
- 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.
Import data from delimited text, XML or Excel files into the database.
Very easy to use, with data pre-validation.
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.
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.
Using the feature of generating HTML documentation including SVG image of the layout you can post
an interactive HTML documentation in your project or on the Web.
- 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.
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.