DbSchema

A single tool to design and manage various types of databases.

Offers a graphical interface for understanding and manipulating database structures and content.

Enables creation of Entity-Relationship diagrams to visually represent database relationships.

Allows users to construct complex SQL queries using a drag-and-drop interface, without manual coding.

Visually browse and edit data from multiple tables simultaneously, using foreign keys to navigate relationships.

Produces interactive HTML5 documentation with vector diagrams, table/column comments as tooltips, and provides export options to PDF and Markdown.

Integrates with Git for version control of the database design model, allowing teams to collaborate securely and manage changes.

Connects to a wide range of database systems using JDBC drivers, including MySQL, PostgreSQL, SQL Server, MongoDB, Cassandra, Oracle, SQLite, and many cloud-specific databases.

Offers a free version with core functionalities like schema reverse engineering, interactive diagrams, visual table creation/editing, and a SQL editor.

Includes advanced features such as schema documentation, Git integration, random data generation, and more.

Provides an intuitive environment for writing and executing SQL queries with features like auto-completion, execution of individual queries or entire scripts, and explain plan support.

Tools to efficiently manage database users, roles, disk usage, session locks, and system load.

Compares different versions of the design model and automatically creates SQL scripts to synchronize schema changes.

Facilitates collaborative database design using a sharable internal model file (.dbs).

Allows designing and modifying the schema without an active database connection.

Enables deploying and maintaining consistent database designs across various platforms and environments.

Compares databases or models and generates SQL scripts to apply differences.

Customizable migration scripts for automating schema updates.

Connects to existing databases (cloud, remote, on-premise) and loads their schema structure into the design model.

Supports creating database-independent designs that can later be transformed into physical models for specific databases.

Populates tables with randomly generated data for testing purposes, with customizable patterns.

Automate tasks like documentation generation, schema synchronization, or migration script creation using Java Groovy scripts.

Native installers available for Windows, macOS, and Linux.

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

Allows creating foreign keys that exist only within DbSchema's model for diagramming purposes, without being implemented in the physical database (useful for databases without native FK support or for conceptual modeling).

Compares the design model with the live database and generates SQL scripts to synchronize changes.

Supports both predefined and user-defined data types in the schema.

Indicates compliance with an international standard for information security management.

Licenses do not expire and include one year of free updates and support.

Offers monthly payment options with included updates and support.

For multiple concurrent users in a team environment.

Special pricing for universities and students.

Online area for managing licenses and accessing support.

For scripting and automating tasks.

Includes support for PostgreSQL partitioned tables, Oracle packages, Databricks STRUCT/ARRAYS/Unity Catalog, MongoDB validation rules, etc.