Navigate Complex Cache and IRIS Namespaces Visually

DbSchema gives InterSystems Caché / IRIS 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 InterSystems Caché / IRIS Features Download InterSystems Caché / IRIS JDBC Driver · All drivers

Visual Schema Exploration for InterSystems Caché and IRIS

InterSystems Caché and its successor IRIS Data Platform combine a multi-dimensional data engine with SQL, object, and document interfaces that share the same underlying storage. Caché classes and IRIS persistent classes are projected as SQL tables, but navigating a full namespace — spanning hundreds of system and application classes — requires tooling beyond the built-in Management Portal. DbSchema connects to Caché and IRIS via JDBC to the SQL projection layer and renders the table-class mappings as an interactive entity-relationship diagram.

Download DbSchema Free See InterSystems Caché / IRIS Features

ER Diagrams of IRIS Namespace Table Projections

DbSchema reads the SQL projection catalog in the target IRIS or Caché namespace and displays available tables and their relationships on a visual canvas. This is particularly valuable for healthcare and financial applications built on InterSystems technology, where schema complexity is high and the Management Portal provides limited diagramming support.

SQL Editor for IRIS and Caché Queries

DbSchema's SQL editor connects to the InterSystems JDBC endpoint and supports the SQL dialect used by Caché and IRIS, including class-table queries and system catalog views. Run queries against the SQL projection without relying on the Management Portal query tool or the ObjectScript terminal.

Generate and Populate Test Data for IRIS SQL Tables

DbSchema's data generator creates realistic test data for IRIS SQL tables, populating fields with type-appropriate values based on column definitions. This is useful when developing new InterSystems applications and needing representative data without exposing production datasets.

Connect DbSchema to a Caché or IRIS Namespace

1. Install DbSchema without creating an account; the same installer offers a 15-day trial of Pro tools.
2. Download the InterSystems JDBC driver (intersystems-jdbc-3.x.x.jar) from the InterSystems Developer Community, or reference it as a Maven dependency from the InterSystems Maven repository.
3. Add the JAR via DbSchema's driver manager under Connections > Manage Drivers.
4. Set up a connection targeting jdbc:Cache://host:1972/NAMESPACE, where 1972 is the default JDBC port for both Caché and IRIS.
5. Enter the namespace exactly as configured in the InterSystems Management Portal — it must be uppercase in the URL — then connect to build the first ER diagram from the SQL projection catalog.

Advantages for Teams Running Caché or IRIS

• Navigate complex InterSystems namespace structures through SQL table projections
• Generate test data for IRIS SQL tables without writing ObjectScript loading routines
• Run SQL queries against Caché or IRIS from a desktop GUI without the Management Portal
• Document SQL-projected class structures for integration and API development teams
• Compare SQL schema versions between IRIS development and production namespaces

Staring down a namespace with hundreds of undocumented classes? Download DbSchema for free and turn the IRIS or Caché SQL projection catalog into an ER diagram you can actually navigate.

Related databases

Teams working with InterSystems Caché / IRIS often use these engines too. Explore dedicated guides and JDBC setup for each.

• Access
• Aurora MySql
• Aurora PostgreSQL
• AzureSQL
• Cockroach
• CTreeAce

Browse all 100+ supported databases