DbSchema Diagram Designer and Query Tool

DbSchema is complete solution for managing SQL and No-SQL databases using visual design, data and query tools, documentation and reports.

DbSchema can design the schema with or without database and save the design to file. The design file can be shared in a team. Schema can be deployed or synchronized on different databases, migration scripts can be generated. Interactive HTML5 or PDF documentation with diagram vector image can be created.

Productivity tools allow to create virtual foreign keys and relational explore the data, build queries, generate random data, create reports and more.

Free Download Purchase Video

Dark Theme
DbSchema Database Tool

Manage Complex Databases

DbSchema is made for large schemes and complex databases. We help to better understand them by creating multiple layouts with the same or different tables. Document the tables and generate HTML5 or PDF documentation with interactive diagram vector images. The layouts will be saved as project file and can be open from any computer, without database connectivity.

Database Diagram

Key Features

Interactive Layouts

Database diagram

Create multiple layouts (diagrams) with the same or different tables. Edit tables and columns directly in the layout. The layouts will be saved to project file.

Video 01:42 Read more »

Visual Query Builder

Query Builder

Visual query editor features different join types (inner, left, exits), 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

Schema can be designed without database connectivity and saved to project file. Later it can be deployed on different databases, migration scripts can be generated or different versions of the same schema can be compared one with another.

Video 01:18 Read more »

Reports Designer

Database Forms and Reports

Web reports using bootstrap and multiple master-detail sections, charts and even text fields and buttons.

Read more »

Open Source Database Managers

Open Source Database Managers

For few databases DbSchema contains open-source database space and activity build using the forms designer.

Read more »

Relational Data Browse

Relational Data Browse

An amazingly simple data explorer that offers simultaneous views of data from multiple tables and features numerous filters and data sorting. Data can be edited directly in the editor.

Video 01:51 Read more »

SQL Editor

SQL Editor

SQL editor with syntax highlighting and text auto-completion, query and script execution, Groovy support, graphical execution plan.

Read more »

Schema Synchronization

Database Schema Synchronization

DbSchema local image of the schema is independent from the database and can be synchronized with any other database or other version of the same schema. For each difference you can choose an action: merge in the local project, commit in the database, generate the SQL scripts or ignore.

Video 01:54 Read more »

Random Data Generator

Random Data Generator

Fill tables with random data defined using reverse regular expressions, numeric expressions, lists or Java Groovy scripts.

Video 02:19 Read more »

Virtual Foreign Keys

Virtual Foreign Keys

Virtual foreign keys will help to figure out the relations between tables and do a better design. They are used in relational data browse for simultaneous exploring data from multiple tables and in visual query builder for creating joins between tables.

Read more »

PDF/HTML5 Documentation

HTML5 Documentation

Generate documentation with interactive diagram vector image: moving the mouse over table or columns can read the comments as tooltips. Check the online example

Video 00:52 Read more »

Schema Reverse Engineer

Schema Synchronization

Connect to any SQL or NoSQL database and reverse engineer the schema, show it as diagrams and save it as project file.

Video 01:18 Read more »

Share Design in a Team using GIT

Schema Versions

DbSchema project file containing the schema design is in XML format and can be shared in a team using GIT or any versioning system. Different projects can be compared and migration scripts can be generated.

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. Schema is presented as diagrams. MongoDb users can also enjoy the visual query builder which generates native MongoDb queries, relational data browse to explore data from multiple collections, random data generator, data loader and query editor.

Read more »

Good Design = Good Documentation = Fast Databases
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.
Cascade as deep as you like.
No foreign keys ? Just create Virtual foreign keys.

Relational Data Browse

Purchase one license and use DbSchema with ALL databases

There is no restriction for the databases you are connecting. Is your database not in our list ? You can still upload the JDBC driver and get connected ! Please let us also know about this.

You can run DbSchema 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.