DbSchema Diagram Designer and Query Tool

Visual manage databases, compare and deploy the schema over multiple databases, generate random data, create interactive PDF/HTML5 documentation, explore data from multiple tables using the mouse, edit and execute SQL, create forms and reports.

DbSchema is compatible with all SQL and the major No-SQL databases and works on all operating systems.

Video Free Evaluation Buy

DbSchema Database Tool

Build for Complex Databases

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, interactive PDF documentation and many other features.
Database Diagram

Key Features

Interactive Diagrams

Database diagram

Edit tables and columns directly in the diagram. 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

Visual query editor support inner, left, exits joins, data filters and group by. The editor is persisted to project file and can be reopen.

Video 01:16 Read more »

Design Schema Offline

Design Schema Offline

Design the schema without connecting to the database and later deploy it on one or multiple databases. The schema can be compared and synchronized with any other database.

Video 01:18 Read more »

Forms & Reports Designer

Database Forms and Reports

Create web reports or small forms applications, with tables, charts, input fields and more. Reports can use master-detail data blocks.

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

Explore and edit data from multiple tables simultaneously, without writing complicated SQL queries. The views are persisted and can be later reopen. You can cascade in as many tables as you want.

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 use its own images of the schema, distinct from the database, which is saved as project file. The DbSchema project can be compared with any database, you can decide and action for each difference or you can generate SQL scripts.

Video 01:54 Read more »

Random Data Generator

Random Data Generator

A bunch of predefined reverse regular expressions as well numbers, date, JSON and groovy script generators will help you to fill tables with random data.

Video 02:19 Read more »

Virtual Foreign Keys

Virtual Foreign Keys

... will help you to mark relations between database fields without implementing the foreign key in the database. They are used in Relational Data Browse and Visual Query Builder.

Read more »

PDF/HTML5 Documentation

HTML5 Documentation

The documentation is interactive: read the schema comments by moving the mouse over table and column names. See online example

Video 00:52 Read more »

Schema Reverse Engineer

Schema Synchronization

Schema will be reversed engineer into DbSchema project file, which is independent from the database and will be saved to file. Schema can be then compared with other databases.

Video 01:18 Read more »

Design Schema in a Team and Schema Versioning

Schema Versions

DbSchema project file containing the schema definition is saved as XML project file. This file can be shared in a team using versioning system like GIT. Comparing two versions of the same project file you can generate database migration scripts.

Video 01:48 Read more »

Data Loader

Data Loader

Load data into the database from Excel, XML or CSV files.

Read more »

Diagrams for MongoDB

MongoDB Designer

DbSchema discovers the MongoDb schema by reading data samples and shows it as diagrams. The Visual Query Builder generates native MongoDb queries. Available are also Query Editor, Relational Data Browse, Random Data Generator and Data Loader.

Read more »

Database performance = visual design + good documentation.
The image below is an interactive HTML5 diagram, generated using DbSchema. Move the mouse over table and columns to read the schema comments.

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
Simultaneously explore data from multiple tables at a time.
Intuitive. Visual. No SQL knowledge required.

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.