Bringing Visual Tools to FairCom c-treeACE

DbSchema gives c-treeACE teams a design-first workflow: import the existing schema as an interactive ER diagram, refine it visually, and ship every change as a reviewed SQL script.

Built for visual modeling, schema documentation, and deployment, with an offline model you can keep in Git, team collaboration, and documentation that developers, analysts, and stakeholders can navigate in minutes.

Download DbSchema See c-treeACE Features Download c-treeACE JDBC Driver · All drivers

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.

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.

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.

Connecting to a c-treeACE Server

Set up the connection in DbSchema as follows:

1. Install DbSchema on your machine — the installer is free and does not require an account.
2. Confirm SQL services are enabled on the c-treeACE server: the navigational ISAM engine alone does not expose a JDBC-accessible catalog, so the SQL layer must be activated in the server configuration file first.
3. Download the c-treeACE JDBC driver from the FairCom developer portal and register it in DbSchema's driver manager.
4. Enter the host and port 6597, the default c-treeACE SQL server port, so the connection matches the URL form jdbc:ctree://host:6597/dbname.
5. Connect — DbSchema reads the SQL catalog and builds the ER diagram from the discovered tables and relationships.

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.

Inheriting a c-treeACE application with no schema documentation? Download DbSchema free and turn the SQL catalog into a browsable diagram in minutes.

Related databases

Teams working with c-treeACE often use these engines too. Explore dedicated guides and JDBC setup for each.

• Access
• Aurora MySql
• Aurora PostgreSQL
• AzureSQL
• Cache
• Cockroach

Browse all 100+ supported databases