DbSchema

Additional features

Universal Database Designer & GUI Tool

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

Visualize and Interact with Schema and Data

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

Design ER Diagrams

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

Build Queries (Visual Query Builder)

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

Explore Data (Relational Data Editor)

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

Generate Interactive Documentation (HTML5, PDF, Markdown)

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

Track Schema Changes in Git

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

Support for 70+ SQL, NoSQL, and Cloud Databases

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.

Community Edition (Free)

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

PRO Edition (Enhanced/Paid)

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

SQL Editor

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.

Manage Your Database

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

Generate Migration Scripts

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

Design the Schema in a Team

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

Design Offline

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

Deploy Across Databases

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

SQL Diff Scripts

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

Automate Database Schema Changes

Customizable migration scripts for automating schema updates.

Reverse Engineer the Schema

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

Logical or Conceptual Design

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

Generate Random Data

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

Execute Automation Scripts

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

Cross-Platform Support

Native installers available for Windows, macOS, and Linux.

Data Importer

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

Virtual Foreign Keys

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).

Schema Synchronization

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

User-Defined Data Types Support

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

ISO-27001 Certified

Indicates compliance with an international standard for information security management.

Perpetual Licenses

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

Monthly Subscription Licenses

Offers monthly payment options with included updates and support.

Team Shared Floating Licenses

For multiple concurrent users in a team environment.

Educational Licenses

Special pricing for universities and students.

Customer Portal

Online area for managing licenses and accessing support.

DbSchemaCLI (Command Line Interface)

For scripting and automating tasks.

Support for specific database features

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