DbSchema Database Designer

DbSchema | How to Automate Database Tasks



DbSchema is a desktop application for database design and management.
It offers a visual interface for designing the schema, generating documentation, running queries, etc.
But how about automating these operations, and executing them without human interaction?

First, let’s have a closer look at the SQL Editor.
We can open it from the SQL menu.

Open SQL Editor

In the SQL Editor toolbar, we can choose between SQL and Java Groovy.
Groovy is pure Java with closures.
Anybody how knows Java or JavaScript can write Groovy Code.

Groovy

Let’s practice first a simple command: print line.

Println

The Groovy code will get the sql variable as the database connection and project as the DbSchema model object.

Groovy Variables

Then let’s have a look at the DbSchema Help / Code Samples.
Here we can see a link to the DbSchema API, as well as different code samples.

Code Samples

What can be the automation scripts used for?

  1. Schema reverse engineer
  2. Generate HTML5 documentation
  3. Generate migration scripts
  4. Load the model from a custom format, like CSV, XML, etc.
  5. Save the model to another format
  6. Execute database queries.

DbSchema → Your Trusted Partner in Database Design

Simplify complex database workflows and improve productivity with DbSchema's advanced design and management tools

Visual Design & Modeling
Visual Design & Schema Layout

➤ Create and manage your database schema visually through a user-friendly graphical interface.

➤ Easily arrange tables, columns, and foreign keys to simplify complex database structures, ensuring clarity and accessibility.

GIT & Collaboration
Version Control & Collaboration

➤ Manage schema changes through version control with built-in Git integration, ensuring every update is tracked and backed up.

➤ Collaborate efficiently with your team to maintain data integrity and streamline your workflow for accurate, consistent results.

Data Explorer & Query Builder
Relational Data & Query Builder

➤ Seamlessly navigate and visually explore your database, inspecting tables and their relationships.

➤ Build complex SQL queries using an intuitive drag-and-drop interface, providing instant results for quick, actionable insights.

Interactive Documentation & Reporting
HTML5 Documentation & Reporting

➤ Generate HTML5 documentation that provides an interactive view of your database schema.

➤ Include comments for columns, use tags for better organization, and create visually reports.