Navigate Complex Cache and IRIS Namespaces Visually

Caché and IRIS project their persistent classes as SQL tables. DbSchema connects to that SQL projection over JDBC and turns a whole namespace into ER diagrams and documentation — a readable view of systems that have grown for decades.

Reverse engineer the projection catalog: tables and relationships on one canvas

Query Caché or IRIS from a desktop SQL editor with autocomplete

Split hundreds of projected classes into focused diagrams per application area

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

Two Decades of Classes
and Nobody Drew the Map

The hospital system, the trading platform, the registry — InterSystems estates run critical workloads on classes written by people who have long moved on. The Management Portal lists the projected tables, but offers little help seeing how they relate.

DbSchema reads the SQL projection and gives the namespace what it never had: diagrams, a searchable reference, and a way in for the next engineer.

Explore, Query & Untangle
the IRIS SQL Projection

Modern desktop tooling for a platform older than most of its documentation.

Reverse engineer an InterSystems IRIS namespace into an ER diagram

Turn a Namespace Into a Diagram

DbSchema reads the projection catalog of the target namespace and shows the tables and their relationships visually — especially valuable in healthcare and financial systems where the class model runs deep.

Run SQL against InterSystems Caché or IRIS from DbSchema

SQL Access Without the Portal

Run queries against the InterSystems JDBC endpoint — class-table queries, system catalog views — from an editor with autocomplete, instead of the Portal query tool or an ObjectScript terminal.

Organize InterSystems IRIS tables into focused diagrams

Break the Estate Into Readable Views

Hundreds of projected classes become manageable as focused diagrams per application module — each one exportable for the teams integrating against the system.

Hand Integrators the Schema
Not a Portal Login

Export the namespace as interactive HTML5 documentation — diagrams to zoom, table definitions, column comments. API and integration teams learn the class structure from a browser, with no InterSystems tooling installed and no production credentials handed out.

Caché / IRIS Connection Setup

The InterSystems JDBC driver is the one manual step: download intersystems-jdbc-3.x.x.jar from the InterSystems Developer Community (or pull it from their Maven repository) and register it in DbSchema under Connections > Manage Drivers.

Both Caché and IRIS listen on port 1972 by default, with a URL of the form jdbc:Cache://host:1972/NAMESPACE. Write the namespace in uppercase, exactly as the Management Portal shows it, then connect to build the first diagram from the projection catalog.

Cookie preferences

Navigate Complex Cache and IRIS Namespaces Visually

Two Decades of Classesand Nobody Drew the Map

Explore, Query & Untanglethe IRIS SQL Projection