ER Diagrams using DbSchema
Magnifier
DbSchema Integrated Database Tool
DbSchema is an integrated tool for relational databases featuring :
ER diagrams, SQL editor, Data Explorer and editor, Query Builder, Random Data Generator, Schema Synchronization, HTML5 documentation and more.

DbSchema is different from the other tools.
Give it a try !
HTML5 Database Documentation and Diagram
Best Diagrams, Top Documentation
Enjoy the interactive diagrams as well HTML5 image documentation. Try the DbSchema diagrams and you will get a different perspective over the database.

"The project team I am reporting to really like the html5 documentation I can send them. Thank you again for this brilliant software. I am recommending it to all my colleagues."
Ben Burke, Software Developer, Sydney, Australia
Database Data Explorer and Editor
Database Explorer for Multiple Tables
Explore data from multiple tables using the mouse. No SQL knowledge required.

"Using Relational Data Editor i can see table data from multiple tables without writing any sql queries, it's like a child's play."
Ariovaldo Chrysostomo, Database Developer Ricoh Europe
Schema & Diagrams in XML File
Database Tool For Postgres Oracle SqlServer MySql
Schema and diagrams are stored in XML file. Schema can be created and synchronized over different databases. Suitable for SVN or GIT repositories.

"It's very intuitive, and the compare/sync wizard is all I expected."
Bert Scalzo, author of Oracle and SqlServer books

Video Presentation

Video tutorial for DbSchema

DbSchema ER Diagram Designer & SQL Tool

DbSchema database tool with interactive diagrams, HTML documentation, Relational Data Browse and Editor, SQL Editor, Query Builder, Random Data Generator, Schema Compare and Synchronization and more.

Powerful, yet easy-to-use, DbSchema helps you design, document and manage databases without having to be a SQL pro. Easily design new tables, generate HTML5 documentation, explore and edit the database data, compare and synchronize the schema over multiple databases, edit and execute SQL, generate random data.

DbSchema is compatible with all relational databases. It works on all major operating systems, including Windows, Linux and Mac.

You can download and evaluate DbSchema free for 15 days.

DbSchema DiagramsInteractive Diagrams

Interact with the schema direct in the diagram layouts. Multiple layouts can be created. The layouts will be saved together with the schema to XML 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

DbSchema Reverse EngineerReverse Engineer Schema From Database

Connect via JDBC to any relational database and get the schema in DbSchema. Schema can be saved to project file and repopened without connecting to the database.
  • 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

Relational Data BrowseRelational Data Browse

An amazingly simple 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. Read 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

Query BuilderQuery Builder

Graphically SQL query editor, with different joins, exists, where clauses and group by. The query is represented as a diagram, simple and intuitive to use. 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

SQL EditorSQL Editor

Sql editor with syntax highlighting and code completion can execute simple queries, SQL scripts and Groovy scripts. The output can be displayed on screen or spooled directly to a file. Graphical explain plan feature included. Read more...
  • Edit queries using autocomplete
  • Highlight of SQL keywords
  • Execute single queries as well as scripts
  • Explain query execution plan

Data LoaderData Loader

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

Generate Schema ScriptsGenerate 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.

Compare Database SchemaCompare and Synchronize Database Schema

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

Convert Database SchemaConvert 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.

Print Database DiagramSmart 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

DbSchema Explain PlanGraphical 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 GeneratorRandom Data Generator

Generate random data in the database based on regexp patterns. A predefined repository of patterns will help in finding the best pattern for each column.

DbSchema DocumentationDocumentation

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

DbSchema Project FileFlexible Application Interface & DbSchema Project File

DbSchema uses layouts to let you structure your work. Inside the layout you can have Data Browse Panes, SQL Editors and Query Builders. Saving the DbSchema project to file all of them will be saved. Opening the application next time will also open this editors.
  • Save one central project file including schema structure, layouts and editors for SQL and data browse
  • Open the DbSchema project from different computers
  • The DbSchema project file is in XML format and can be edited using an text editor
  • Multiple layouts and multiple editors for SQL, queries and data inside each of layouts
  • Reopen saved layouts or editors at any time