Simplify database design & management. Edit, document and browse complex databases with a friendly GUI tool.
Download DbSchema
Simplify database design with layouts. Gain a better understanding of complex databases by focusing on a specific part of the database schema. Learn More
With our intuitive UI, it's very easy to create database design for complex schemas. The interface enables you to execute complex actions simply by drag&drop or double-click. Learn More
Easy explore data from multiple tables simultaneously. Learn More
No need to be an SQL expert! DbSchema will help you write SQL queries. Learn More
Powerful editor with text-autocompletion. Learn More
DbSchema works in a unique way by creating its own local copy of the schema saved to a project file. The local project file, makes it possible to:
Generate comprehensible documentations for complex databases. Insert comments, select the details you want to see and export the documentation in PDF or interactive HTML5 format.
DbSchema can compare schemas between different databases or different project files, show them and generate migration scripts. Work on the schema without being connected to the database (offline) and synchronize later.
Streamline your work! Use Groovy scripts to automate schema deployment & migration, HTML5 documentation export, the reverse engineering of the schema, and many more.
If the database lacks foreign keys, you can create Virtual Foreign Keys that will be saved only in DbSchema.
They will help you gain a better understanding of the database.
These foreign keys are marked with green.
Use configurable, random and reverse regular expression to generate meaningful data. Choose data patterns from the repository or create your own.
DbSchema can connect to any SQL or NoSQL database via JDBC driver, reverse engineer the schema and show it as ER diagrams.
Take advantage of the powerful SQL editor with text-autocompletion, Groovy scripting support, scripts, and query execution.
DbSchema can load data in the database from various formats, such as: CSV, XML, TXT, etc.
Build reports for your database with a powerful forms & reports builder. Use text inputs, buttons and charts to create complex forms.
