DbSchema Diagram Designer and Query Tool

DbSchema is a diagram-oriented database tool compatible with all relational and many No-SQL databases, like MySql, Cassandra, PostgreSql, MongoDb, Redshift, SqlServer, Azure, Oracle, Teradata and more.

Using DbSchema you can design the schema with or without database, save the design as project file, deploy schema on multiple databases and share the design in a team. Build-in tools allows to visually explore the database data, build and execute queries, generate random data, build forms applications or reports and more.

DbSchema can be evaluated 15 days for free, no registration required. DbSchema can work on all operating systems.

Video Free Evaluation Buy

DbSchema Database Tool

Manage 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

Create multiple layouts (diagrams) with the same or different tables. Edit tables and columns directly in the diagram. 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

Design the schema without connecting to the database and save the design to project file. Later deploy it on one or multiple databases, compare different versions of the same schema, generate migration scripts, etc.

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

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 and editor that offers simultaneous views of data from multiple tables and features numerous filters, data sorting mechanisms, and much more.

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 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. For each difference found you can decide to merge in the local project, apply it in the database or generate the 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

Use Virtual foreign keys to show the relations between tables without physiacally implementing the foreign key in the database. Virtual foreign keys are used in Relational Data Browse and Visual Query Builder.

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 »

Design Schema in a Team and Schema Versioning

Schema Versions

DbSchema project file contains the schema definition and is saved to project file. This project file is in XML format and can be shared in a team using versioning system like GIT. Comparing two versions of the same schema may generate 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.