Design and Manage c-treeACE Databases Visually with DbSchema

DbSchema lets you design, manage, and document c-treeACE databases. Create ER diagrams, define tables and columns, and generate SQL scripts - with or without a live database connection.

Use Git to share the design, compare it with the c-treeACE database, and deploy changes. DbSchema also includes a data editor, query builder, and HTML5 documentation - everything you need in one tool.

DbSchema Database Designer

Download DbSchema Download c-treeACE JDBC Driver

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.

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.