Design and Manage InterSystems Caché / IRIS Databases Visually with DbSchema

DbSchema lets you design, manage, and document InterSystems Caché / IRIS 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 InterSystems Caché / IRIS 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 InterSystems Caché / IRIS JDBC Driver

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.

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.

Visualizing InterSystems IRIS / Caché SQL table projections as an ER diagram in DbSchema

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.

Running SQL queries against InterSystems IRIS or Caché in DbSchema's SQL editor

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.

Generating test data for InterSystems IRIS SQL tables in DbSchema

Connecting DbSchema to InterSystems Caché / IRIS

The default JDBC port for InterSystems Caché and IRIS is 1972. The JDBC URL format is: jdbc:Cache://host:1972/NAMESPACE. Download the InterSystems JDBC driver (intersystems-jdbc-3.x.x.jar) from the InterSystems Developer Community or include it as a Maven dependency from the InterSystems Maven repository. Add the JAR via DbSchema's driver manager under Connections > Manage Drivers. The namespace name in the JDBC URL must be uppercase and match exactly the namespace configured in the InterSystems Management Portal.

Why DbSchema for InterSystems Caché / 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