User:Dprutean/sandbox

DbSchema is a powerful visual database design and data modeling tool developed by Wise Coders GmbH, a German IT software company specialized in database design and visual interfaces.

The tool allows users to create, manage, and document databases. It offers features such as visual schema design using Entity Relationship Diagrams, HTML5 documentation generation, team collaboration, logical-to-physical design mapping, a visual query builder, test data generation, and an integrated SQL editor. DbSchema simplifies database development and enhances productivity for developers and teams.

Visual Design and Management
DbSchema allows you to design and manage databases visually. You can generate HTML5 schema documentation, build SQL queries using a mouse-based interface, and explore data from multiple tables. The tool also supports editing and executing database queries1.

Schema Documentation
DbSchema can document tables, columns, and foreign keys. It generates HTML5 documentation with vector images of the schema, where table and column comments appear as mouse-over tooltips.

Team Collaboration
DbSchema is useful for teams working on database development projects. It supports database synchronization, version control, and sharing design models among team members using GIT.

Logical to Physical Design
Create a high-level representation of the schema independent of any specific database management system. Map the logical design to a specific physical database system.

Visual Query Builder
Build SQL queries visually using filters, ordering, and grouping. No extensive knowledge of SQL syntax required.

Test Data Generation
Generate realistic test data using a graphical interface. Define data sets and export data easily.

SQL Editor
Create, edit, and execute SQL scripts within DbSchema. Features syntax highlighting, auto-completion, and error checking.

Database Support

DbSchema works with:


 * SQL Server
 * Oracle
 * PostgreSQL
 * MySQL
 * MariaDB
 * MongoDB
 * Cassandra
 * Snowflake
 * Sqlite
 * SQL Anywhere
 * Redshift
 * DuckDB
 * Exasol
 * Elasticsearch
 * Firebird
 * Filemaker
 * Frontbase
 * Google Big Query
 * Google Cloud Spanner
 * DB2
 * Access
 * H2
 * HBase
 * Hive
 * HSql
 * Impala
 * Informix
 * Ingres
 * Interbase
 * MonetDB
 * MemSQL
 * NuoDB
 * OrientDB
 * Pervasive
 * SAP ASE
 * SAP Hana
 * SAP MaxDB
 * ScyllaDB
 * SnappyData
 * SqlBase
 * SingleStore
 * Vertica
 * Teradata
 * TimescaleDB
 * ThoughtSpot
 * Transbase