DbSchema Database Client

Manage Complexity in an Intuitive Way

DbSchema is build for large schemas and complex databases. We help you to understand the data, build meaningful relations between tables and document the schema. Discover DbSchema layouts, virtual foreign keys, Relational Data Browse, HTML5 documentation and many other features.
Database Diagram

Key Features

Interactive Diagrams

Database diagram

Edit tables and columns directly in the diagram. For a better understanding of the schema create multiple layouts (diagrams), with the same or different tables. The layouts will be saved to project file.

Video 01:42 Read more »

Visual Query Builder

Query Builder

Graphic query editor can use different join types ( inner, left or right join, exits ), filters and group by. All query conditions are represented graphically. The editor is saved to project file.

Video 01:16 Read more »

Design Schema Offline

Design Schema Offline

There is no need to be connected to the database to be able to design the schema. Later you may connect to the database and deploy or synchronize the schema. Connecting to a new database you are allowed to simply refresh the project schema from the database or selective choose for each difference to be applied in the project schema or in the database.

Video 01:18 Read more »

Forms & Reports Designer

Database Forms and Reports

Create applications or reports which can be executed as JavaFx or Web HTML. The applications may include buttons, input fields and charts. Scripting logic and multiple master-details can be used.

Read more »

Open Source Database Managers

Open Source Database Managers

We started building permission, space and activity database managers for all databases using the forms designer. Currently available for MySql and PostgreSql. Active supported by DbSchema community.

Read more »

Relational Data Browse

Relational Data Browse

Visual data explorer and editor, the tool offers simultaneous views of the data from multiple tables bind by foreign keys or virtual foreign keys. The number of explored tables is unlimited. Data can be edited directly here, filters and sorting can be applied. The editor will be saved to project file and can be reopen.

Video 01:51 Read more »

SQL Editor

SQL Editor

SQL editor with syntax highlighting and code completion can execute queries, SQL or Groovy scripts. Graphical explain query execution plan included.

Read more »

Schema Synchronization

Database Schema Synchronization

DbSchema stores the schema structure in its own project. The project can be compared and synchronized with any database or with other project file. You may work on a development schema and later deploy it on the production databases. SQL scripts can be generated. The project file is in XML format and can be shared in the team via GIT.

Video 01:54 Read more »

Random Data Generator

Random Data Generator

For test purposes you may need to generate random data. Reverse regular expressions, lists and many other configurable generators can be used.

Video 02:19 Read more »

Virtual Foreign Keys

Virtual Foreign Keys

Foreign keys are crucial for a good database design. If your schema misses foreign keys you can create virtual foreign keys. They will be saved to project file and will be used in Relational Data Browse and Visual Query Builder.

Read more »

HTML 5 Documentation

HTML5 Documentation

Export the diagram as interactive HTML5 vector image. Moving the mouse over columns and tables in the web browser may read the schema comments. The generated files have a small size and can be open using any browser. See online example

Video 00:52 Read more »

Schema Reverse Engineer

Schema Synchronization

Connect to any relational database or one of the supported NoSql databases, reverse engineer the schema and view it as ER diagrams. Schema will be saved together with the diagrams to project file.

Video 01:18 Read more »

Design Schema in a Team and Schema Versioning

Schema Versions

Schema and diagrams are saved as XML project file. The project file can be shared in a team using GIT or SVN. Different versions of the files can be compared one with another and database migration scripts can be generated.

Video 01:48 Read more »

Data Loader

Data Loader

Load Excel, text, XML or comma separated files into the database.

Read more »

Diagrams for MongoDB

MongoDB Designer

DbSchema 'discovers' MongoDb structure by reading random documents. The structure is shown as diagrams. DbSchema included tools for MongoDb: Visual query builder, Query editor, Relational data browse, Random data generator and Data loader.

Read more »

For a better design you may need good documentation and visual interaction with the schema. The image below is a HTML5 diagram, generated using DbSchema. Column and table comments are available as mouse-over tooltips.

Free Trial

Download DbSchema and try it 15 days for free.

Technical Support

Registered and unregistered users may benefit from technical support.

1 Year Renewals Included

Purchase DbSchema and you will get 1 year free updates to new developed features and fixes.

Money Back Guarantee

Not happy with DbSchema ? 30 days after purchase you can claim your money back.

Video Presentation

Relational Data Browse is a visual data explorer from multiple tables at a time, an intuitive alternative to complicate SQL queries.

Relational Data Browse

One License for All Databases & All Operating Systems

DbSchema can connect via JDBC drivers to all SQL databases + MongoDB.

DbSchema can run on all operating systems: Windows, Linux, MAC.

Get Started for Free   Buy Now
DbSchema Database Tool

What Customers Says

  • "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
  • "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
  • Many compliments! It is one of the best software I've ever seen

    Gianluca Fioletti
  • I've had some time to play with and get acquainted with DbSchema. I am impressed. It never crashed once, it's very intuitive, and the compare/sync wizard is all I expected. I especially like the relationship option to map to its target columns - you'd be surprised at the tools which don't offer this. I could list numerous positive comments on things I liked - the engineering is quite good and it shows.