Design and Manage InterSystems Caché / IRIS Databases with DbSchema
Build a clearer workflow for InterSystems Caché / IRIS: reverse engineer existing schemas into interactive ER diagrams, model changes visually, and generate reviewed SQL scripts before deployment.
DbSchema is built for visual modeling, schema documentation, and deployment. Keep an offline model in Git, collaborate across teams, and publish documentation that developers, analysts, and stakeholders can navigate in minutes.
Download DbSchema See InterSystems Caché / IRIS Features Download InterSystems Caché / IRIS JDBC Driver
What happens after you download?
Get to your first InterSystems Caché / IRIS schema diagram in minutes. No account, no credit card.
Install in minutes
Download the installer for Windows, macOS, or Linux and launch DbSchema. No signup required.
Connect to InterSystems Caché / IRIS or open a sample
Reverse engineer an existing InterSystems Caché / IRIS database or open a sample model to explore tables, relationships, and indexes.
Design, document, and deploy
Edit schema visually, generate documentation, and prepare reviewed migration scripts for safer releases.
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.
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