Features

Everything IRIS gives you — made visible

Thirteen areas, grouped by how much difference they actually make. The first four are the reason the product exists; the rest is the everyday work, done properly.

Unique to SQL DATA LENS

These capabilities are designed specifically for IRIS and Caché and complement what the Management Portal and general-purpose SQL clients provide. If you work with IRIS or Caché every day, this is where the time savings come from.

Global Browser

See what is actually stored beneath your tables

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

Query Cloud

One SQL statement across namespaces, servers and databases

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

Find the queries and indexes that cost you time

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

Administration

Processes, locks, tasks, logs and CPF — without the Management Portal

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

A clear step up

Things other tools can do in some form, but not with this much knowledge of InterSystems specifics.

Server Navigator

Group your connections however your organisation works, and see all namespaces without configuring a single JDBC URL.

SQL editor

IRIS-aware code completion, syntax highlighting built for IRIS SQL, formatting, parameterised queries, execution plans and eight export formats.

Class Viewer

Browse class and routine source (including INT code) and copy a class to another namespace or another server from the context menu.

Database diagrams

Turn a twenty-year-old Caché namespace into a diagram you can actually hand to a colleague.

Beyond IRIS

SQL Server, PostgreSQL, MariaDB, SQLite, Trino and more over JDBC — plus DuckDB with drag-and-drop analysis of CSV, Parquet and JSON files.

Everyday essentials

The parts you stop noticing because they simply work.

Table Viewer

Open a table, filter it, sort it, edit cells in place and see IRIS-specific details other tools never show you.

Data Inspector

Open any cell as text, HTML, XML, JSON, an image or raw binary — useful the moment a column holds more than a number.

Script Manager

Organise hundreds of SQL scripts, preview them without opening them, and run them against the right connection.

Security & privacy

Runs entirely on your desktop, no telemetry, no admin rights required, signed binaries and a bundled private Java runtime.

What it connects to

Native

InterSystems IRIS
InterSystems Caché

8 drivers bundled: 7 IRIS versions from 3.3 to 3.10.5, plus Caché 2018.1 — loaded side by side so old and new servers work in the same session.

Over JDBC

Microsoft SQL Server
PostgreSQL
MariaDB / MySQL
DuckDB
SQLite
H2
Trino
Apache Derby
Microsoft Access
Microsoft Excel

Files as tables

CSV (single file, folder or ZIP)
Parquet
JSON

Drag a file onto a DuckDB connection, or point a CSV connection at a folder or ZIP archive. See Beyond IRIS.

Not sure it is the right tool? The comparison page sets SQL DATA LENS against the InterSystems Management Portal, DBeaver and DataGrip — including the cases where one of those is the better answer.

Explore your IRIS data from SQL down to globals

Download, unzip, connect. Your first namespace is on screen in about three minutes.

Download for Windows — free, no signup Compare Free and Pro

Windows 10, 11 and Windows Server (64-bit) · ~155 MB · version 4.00 · full 30-day Pro trial included