DbSchema Diagram Designer and Query Tool

  • Features interactive diagrams, relational data browse, schema compare and synchronization, query builder, query editor, HTML5 documentation, random data generator, forms and reports and more.
  • Manages its own image of the schema and saves it as XML file - this makes possible to deploy schema on multiple databases and share the design project in a team using GIT.
  • DbSchema performs well with large schemes and databases. No database experience required - the tool is visual.
  • For ALL SQL databases: SqlServer, Postgresql, MySql, MariaDb, Oracle, Db2, Sybase, Sqlite, etc. and
  • NoSQL: MongoDB, Cassandra, HBase, Hive.

DbSchema can be evaluated 15 days for free.

Video Download & Evaluate Buy

DbSchema Database Tool

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), one for each module of the schema, with the same or different tables.
Online example


Read more »

Schema Synchronization

Database Schema Synchronization

DbSchema holds its own image of the schema which can be compared and synchronized against any database. You may work on a development schema and later deploy it on the production databases. Migration scripts can be generated. The project design file is in XML format and can be stored in GIT or SVN.


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.
Online example


Read more »

Forms & Reports Designer

Database Forms and Reports

Create small applications or multiple master-details reports and execute them under JavaFx or Web. Fast development through wizards and the intuitive interface.


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 alternative to SQL language, the editor offers simultaneous views of the data from multiple tables. Start exploring data from one table and cascade into further tables based on foreign keys. The editor is persisted and will be reopen next time when you start the application. Data can be edited directly here, filters and sorting can be applied.


Read more »

Virtual Foreign Keys

Virtual Foreign Keys

If your schema misses foreign keys, create virtual foreign keys: they will be saved to DbSchema project file and can be used in Relational Data Browse, Query Builder or for documentation purposes.


Read more »

Visual Query Builder

Query Builder

Graphic query editor with different join types, filters and group by. All query conditions are represented graphically.


Read more »

Design Schema Without Database

Design Schema Offline

There is no need to be connected to the database to open the project file and design the schema. You may connect later to any database and deploy or synchronize the schema.


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.


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.


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 »

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 from few documents and shows it as diagrams. DbSchema supports MongoDB with visual query builder, native query editor, relational data browse, random data generator and data loader.


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.


Read more »
Video Presentation

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.

DbSchema Database Tool

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.

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.

Navigation