What is SQL DATA LENS?

SQL DATA LENS is a Windows desktop application for working with data in InterSystems IRIS and InterSystems Caché. It combines a SQL editor, data grids, a browser for the globals underneath your tables, SQL performance analysis, and the operational views you would otherwise open the Management Portal for — in one window, with no server-side installation and every InterSystems driver already included.

It also connects to other database systems over JDBC — SQL Server, PostgreSQL, DuckDB, SQLite and more — which is useful, but not the point. The point is depth in one platform.

The problem it solves

IRIS is not a relational database with a few extra features. Data is stored in multidimensional globals; a table is also a class; a namespace is a unit of both code and data; and prepared statements are cached as queryable objects. Tools that treat IRIS as “just another JDBC source” show you a thin projection of all this and no way to look behind it.

So the everyday questions get hard. What is actually stored in this global? Why was this query fast last week? Which index is redundant? How do I join data that lives in three namespaces on two servers? SQL DATA LENS exists because answering those with the standard tooling means switching between the Management Portal, a generic SQL client, an SSH session and guesswork.

What makes it different

Global Browser

Walk the multidimensional globals under your SQL schema, drill into subscript levels and resolve $LISTBUILD values into readable fields.

Query Cloud

Join data from several IRIS namespaces, several servers, and even SQL Server, Access or CSV files — client-side, with nothing installed on any server.

SQL performance

Scan for redundant indexes and unindexed foreign keys, hunt down expensive cached queries, read execution plans and profile with PTools.

Administration

The daily operational view of an IRIS or Caché instance, next to the SQL you are already writing.

Where it fits in your toolchain

Alongside the tools you already use, not instead of them:

VS Code with the InterSystems extensions is where you write and debug ObjectScript. SQL DATA LENS does not compete with that.
The Management Portal is where you administer the instance — users, roles, mirroring, gateways, backups. Keep it.
SQL DATA LENS is where you look at data, run SQL, and work out why something is slow or wrong.

The comparison page goes into this properly, including the cases where another tool is the better answer.

The practical facts

Platform: Windows 10, 11 and Windows Server (64-bit) · ~140 MB · private Java runtime included
Current version: 3.24, released 10 August 2026 — release notes
Installation: Installer or portable ZIP · no administrator rights · nothing installed on the server
InterSystems drivers: 8 bundled — 7 IRIS versions (3.3 to 3.10.5) plus Caché 2018.1, usable simultaneously
Other databases: SQL Server, PostgreSQL, MariaDB, DuckDB, SQLite, H2, Trino, Derby, Access, Excel, CSV, Parquet, JSON
Privacy: No telemetry · no data leaves your machine · outbound only for updates and licence activation
Trial: 30 days, full Pro feature set, no credit card, no registration
Licensing: Free Edition for free databases · from $299 per user/year (≈ $25 / month) for production — pricing

Common questions

Who is it for?

Developers, database administrators and data analysts who work with InterSystems IRIS or Caché — very often in healthcare, financial services and long-lived industrial systems, where the database has been in production for a decade or more and nobody can afford to guess.

Is anything installed on the database server?

No. It is a desktop application that connects over JDBC like any other client. No agent, no stored procedures deployed, no schema changes. See security and privacy.

Which platforms does it run on?

Windows 10, 11 and Windows Server (64-bit). A macOS build is on the roadmap; there is no Linux or macOS version today.

Is it free?

There is a permanently free edition for databases that are themselves free — IRIS Community Edition, SQL Server Developer, PostgreSQL, DuckDB and others. Connecting to a licensed production database requires a paid licence, from $299 per user per year. Every edition has the full feature set. Pricing.

What was Caché Monitor?

The same product under its previous name. It was renamed SQL DATA LENS with version 3.0 in 2021, when full InterSystems IRIS support arrived. The full story.