DbSchema

DbSchema, developed by Wise Coders GmbH, is a database design and management tool that aims to assist users in visually designing, documenting, and managing databases. It is claimed to be suitable for businesses of various sizes, ranging from small enterprises to large corporations. According to the vendor, DbSchema is utilized by professionals from different industries, including Database Administrators, Software Developers, Data Analysts, IT Consultants, and Web Developers, to streamline their database management processes.

Key Features

Connect and Reverse Engineer: DbSchema allows users to connect to various database management systems and reverse engineer the schema structure. Supported databases include MySQL, PostgreSQL, Oracle, SQL Server, MongoDB, and more. Users can retrieve the schema structure, including tables, columns, relationships, and constraints, from the connected database.

Design the Logical Schema: DbSchema enables users to create a high-level representation of the database schema that is independent of any specific database management system. Users can define entities, relationships, and attributes in the logical design. The logical design can be mapped into a specific physical database management system, providing a clear understanding of the design and its relation to the organization or system being modeled.

Interactive Diagrams: DbSchema uses interactive diagrams to visually represent the database schema. Users can edit tables directly in the diagram, add shapes, and change the notation of foreign keys. Layouts can be saved and reopened, allowing users to work on different parts of the schema. Table and column comments are displayed as tooltips when hovering over them in the diagram.

HTML5 Documentation: DbSchema can generate interactive HTML5 documentation for the database schema. The documentation includes vector images of the schema, with table and column comments displayed as tooltips. It aims to help understand the structure of the database, track changes, and communicate the schema to team members. The documentation can be published on the web and automated using scripts.

Schema Synchronization: DbSchema allows users to compare the model schema with other databases and generate SQL scripts or apply the differences directly to the database. Users can synchronize the schema between different databases or generate migration scripts between different versions of the same schema. The design model, which is an internal copy of the schema structure, can be saved to a file and shared with the team using GIT. Schema synchronization aims to ensure consistency and accuracy across multiple databases.

Relational Data Editor: DbSchema provides a relational data editor that allows users to explore and edit data from multiple tables. Users can navigate through related tables using foreign keys or virtual foreign keys. The data editor supports filtering, sorting, and editing of records. BLOB or CLOB files stored in the database can be accessed and viewed in the editor.

Visual Query Builder: DbSchema offers a visual query builder that allows users to build SQL queries visually without extensive knowledge of SQL syntax. Users can select tables, define joins, apply filters, and specify ordering and grouping. The visual query builder generates SQL queries that can be executed within DbSchema or exported for further use. It aims to simplify the process of creating complex SQL queries.

SQL Editor: DbSchema includes an SQL editor that allows users to create, edit, and execute SQL scripts within the application. The editor features syntax highlighting, text auto-completion, and error checking. Users can execute SQL scripts or Java automation scripts with access to DbSchema API. Query results can be saved as CSV or XLSX files.

CSV Editor: DbSchema provides a CSV editor for editing large CSV files. Users can open and edit gigabyte-sized CSV files. The editor supports filtering, sorting, and saving the edited file under different formats. It is a convenient tool for working with large datasets stored in CSV format.

Data Generator: DbSchema allows users to generate test data for databases using configurable patterns and predefined patterns. Users can define data sets, customize the generated data, and export it for testing purposes. The data generator supports reverse regular expressions to create realistic data based on patterns. It is a useful tool for populating databases with sample data.