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.

Visually Manage Databases using DbSchema

DbSchema is a databases client and visual designer. DbSchema has a free Community Edition, which can be downloaded here.
DbSchema main features include:

DbSchema Designer alt >

Interactive Diagrams

Design tables, column and foreign keys directly in diagrams.


Connection Dialog alt >

Simple Connection Dialog

Choose the database location, the user and password, and simply get connected.


Relational Data Explorer alt >

Relational Data Explorer

Explore data from multiple tables simultaneously, using foreign keys or virtual foreign keys.


Query Builder alt >

Query Builder

Create SQL Queries using the mouse.


SQL Query Editor alt >

SQL Query Editor

Edit and execute SQL Queries


Schema Synchronization alt >

Design Schema in Team & Schema Deployment

DbSchema is using the design model, a copy of the schema structure, independent of the database.
The design model can be saved to file and shared in a team.
Connecting to another database you may compare the design model with the database, commit the differences or merge them in the design model.


Dark Theme alt >

Dark Theme

Configurable styles & dark theme.


Many features are available in the free Community edition.
The Pro edition adds capabilities to save the design to the model file, design schema in team and deploy the schema on multiple databases.


DbSchema can be downloaded for free. No registration is required.