Design and Manage c-treeACE Databases with DbSchema

Build a clearer workflow for c-treeACE: reverse engineer existing schemas into interactive ER diagrams, model changes visually, and generate reviewed SQL scripts before deployment.

DbSchema is built for visual modeling, schema documentation, and deployment. Keep an offline model in Git, collaborate across teams, and publish documentation that developers, analysts, and stakeholders can navigate in minutes.

DbSchema Database Designer

Download DbSchema See c-treeACE Features Download c-treeACE JDBC Driver

What happens after you download?

Get to your first c-treeACE schema diagram in minutes. No account, no credit card.

1
Install in minutes

Download the installer for Windows, macOS, or Linux and launch DbSchema. No signup required.

2
Connect to c-treeACE or open a sample

Reverse engineer an existing c-treeACE database or open a sample model to explore tables, relationships, and indexes.

3
Design, document, and deploy

Edit schema visually, generate documentation, and prepare reviewed migration scripts for safer releases.

Get Started Free

Visual SQL Tooling for the FairCom c-treeACE Engine

FairCom c-treeACE is a cross-platform database engine that provides both navigational record-level access and a full SQL interface from the same underlying storage. It is deployed in healthcare, finance, and manufacturing applications where its low footprint and high throughput matter. DbSchema connects to c-treeACE via JDBC, reads the SQL catalog, and renders the table schema in an interactive diagram — providing graphical tooling for a database that is typically managed through code or proprietary FairCom utilities.

Download DbSchema Free See c-treeACE Features

Connect and Visualize the c-treeACE Schema

After connecting, DbSchema reads the c-treeACE SQL catalog and displays tables, columns, indexes, and foreign key relationships in the diagram canvas. This is especially useful when inheriting a c-treeACE application whose schema has never been formally documented outside of source code.

Opening a c-treeACE connection in DbSchema and loading the schema diagram

Write and Execute SQL Against c-treeACE

DbSchema's SQL editor lets you write queries using c-treeACE's SQL dialect, execute them against a live server, and inspect results inline. This is useful for debugging application queries, validating data, and running ad-hoc analysis without switching to a separate client tool.

SQL editor running a query against a c-treeACE database in DbSchema

Generate Schema Documentation

DbSchema's documentation generator produces an HTML report covering all tables, columns, data types, and relationships — including navigable diagrams. For c-treeACE databases embedded in long-running applications with limited internal documentation, this provides a shareable reference for development and operations teams.

Auto-generated schema documentation report for a c-treeACE database

Connecting DbSchema to c-treeACE

The JDBC URL format for c-treeACE is jdbc:ctree://host:6597/dbname, where 6597 is the default c-treeACE SQL server port. Download the c-treeACE JDBC driver from the FairCom developer portal and register it in DbSchema's driver manager. Before connecting, ensure the c-treeACE server has SQL services enabled — the navigational ISAM engine alone does not expose a JDBC-accessible catalog, and the SQL layer must be explicitly activated in the server configuration file.

Why DbSchema for c-treeACE

  • Reverse-engineer c-treeACE SQL schemas into visual ER diagrams without FairCom utilities.
  • Run SQL queries and inspect results in a desktop client outside the application process.
  • Generate HTML schema documentation for teams unfamiliar with the c-treeACE catalog format.
  • Compare and synchronize schema versions across c-treeACE environments.
  • Design schema changes visually and apply the generated DDL back to the server.