Native macOS Schema Design for FrontBase Databases

DbSchema runs natively on macOS — and on Windows and Linux — and connects to FrontBase over JDBC, turning the SQL catalog into interactive ER diagrams, a capable SQL editor, and documentation you can share.

Read tables, keys, and constraints straight from the SQL catalog
Put several schemas of one database on the same canvas
Run queries in an editor aware of FrontBase's type system
Share HTML reports with teammates who lack client access

available for

ISO-27001 certified

Free Community Edition No signup required 15-day Architect trial included

Free Download

DbSchema rendering a FrontBase SQL catalog as an ER diagram

Trusted by teams at

A Standards-True SQL Engine,
Explored Through Catalog Queries

FrontBase gives macOS and Unix teams ACID compliance and a standards-conformant SQL implementation — yet day-to-day schema insight often comes down to querying system catalogs by hand, and cross-schema dependencies surface only when something breaks.

DbSchema draws the catalog as interactive diagrams and surrounds the database with the desktop tooling it never had.

Diagram, Query & Reconcile
FrontBase Schemas

Everything between the first connection and the reviewed change.

Reverse engineer a FrontBase SQL catalog into an ER diagram

The Catalog, Drawn

After connecting, DbSchema displays tables, columns, primary keys, and foreign key constraints on the canvas — with several schemas side by side in larger deployments.

Run SQL against FrontBase in the DbSchema editor

An Editor Fluent in FrontBase

Write and run statements against FrontBase's dialect — sessions, transaction isolation levels, its type system — and inspect result sets without leaving the tool.

Compare FrontBase instances and generate reconciling DDL

Instances Compared, Drift Caught

Compare schema versions across FrontBase instances, review each difference, and generate the DDL that reconciles them — read before it is applied.

Schema Versions in Git,
Not in Folder Names

The design model is a file, so FrontBase schema changes branch, diff, and pull-request with the rest of the project. Once the review is green, DbSchema generates the DDL and applies it to the server you choose.

Synchronizing a Git-versioned model with FrontBase servers

Read Git Workflow Docs

FrontBase Connection Setup

The FrontBase server must be running first — on macOS, start it through the FrontBase Manager application or the FrontBase command-line tool included with the installation package. Download the JDBC driver from frontbase.com and register the JAR in DbSchema's driver manager.

Connections use the default port 4242 and a URL of the form jdbc:FrontBase://host/dbname. DbSchema then reads the SQL catalog and lays the schema out on the canvas. Details are on the FrontBase JDBC driver page.