Bringing Visual Tools to FairCom c-treeACE

DbSchema connects to FairCom c-treeACE over JDBC, reads the SQL catalog, and supplies what the platform's own utilities leave out: interactive ER diagrams, a desktop SQL editor, and HTML documentation for the applications built on it.

Turn the SQL catalog into a navigable ER diagram
Query the live server from a desktop editor, outside the app
Generate documentation for schemas that never had any
Compare schema versions across environments before releasing

available for

ISO-27001 certified

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

Free Download

DbSchema visualizing a FairCom c-treeACE SQL catalog as an ER diagram

Trusted by teams at

The Application Knows the Schema
Your New Developers Don't

c-treeACE engines power healthcare, finance, and manufacturing systems that often outlive the teams who embedded them. The schema exists — in the catalog, in the code, in a retired developer's memory — everywhere except on paper.

DbSchema reads the SQL catalog and produces the diagrams and documentation the original team never drew, so the current one stops reverse engineering by hand.

Reverse Engineer, Query & Document
c-treeACE Beyond FairCom Utilities

Desktop tooling for an engine usually managed through code.

Reverse engineer a c-treeACE SQL catalog into an ER diagram

Decode an Inherited Catalog

DbSchema reads tables, columns, indexes, and foreign keys from the c-treeACE SQL catalog and lays them out as a diagram — the map the source code never provided.

Run SQL against a c-treeACE server in the DbSchema editor

Ad-Hoc Queries, Outside the App

Execute SQL against the live server and inspect results inline — debug application queries and validate data without touching the application process.

Generate HTML documentation for a c-treeACE database

A Shareable Schema Reference

Produce an HTML report of tables, types, and relationships with navigable diagrams — for operations, auditors, and the next developer to join.

A Paper Trail for Every
c-treeACE Schema Change

The model is a file in your repository, so schema work follows the workflow your code already uses: branch, diff, pull request. After the review, DbSchema generates the DDL and applies it to each c-treeACE environment in turn.

c-treeACE schema synchronization between a Git-tracked model and server environments

Read Git Workflow Docs

c-treeACE Connection Checklist

Enable SQL services on the server first — the navigational ISAM engine alone exposes no JDBC-accessible catalog, so the SQL layer must be activated in the server configuration. Then download the JDBC driver from the FairCom developer portal, register it in DbSchema's driver manager, and connect with a URL of the form jdbc:ctree://host:6597/dbname, where 6597 is the default c-treeACE SQL port. More detail is on the c-treeACE JDBC driver page.