DbSchema

DbSchema is a desktop application that combines visual database design, schema documentation, and SQL client capabilities for a wide range of relational and NoSQL systems. Users can reverse‑engineer existing databases, create and edit ER diagrams, and generate interactive documentation that can be browsed in any web browser. The tool also supports building SQL queries with drag‑and‑drop components, inline data editing, and test‑data generation.

The software targets teams that need to manage the full lifecycle of a database—from design and documentation to deployment and ongoing maintenance—without switching between multiple applications. It offers features such as schema comparison, synchronization with live databases, version‑controlled design models stored in Git, and Groovy‑based automation for repetitive tasks. Logical and conceptual design modes let users start with a database‑agnostic model and then generate physical schemas for specific platforms.

DbSchema runs on macOS and supports over seventy database products, providing a unified environment for developers, DBAs, and analysts to collaborate on schema changes, explore related data, and monitor database operations.