The highlights:

• Encrypted connections without the ceremony. The TLS Assistant fetches the server certificate, validates it, writes the trust store, and tests the connection. No properties file, no keytool, no restart.
• Server-side source code search across a whole namespace — plain text or regex, including "Where is this used?" from any table or global. Nothing gets downloaded to be searched.
• "Why is this slow?" — answered while the query runs. IRIS execution statistics sit right in the SQL editor: global references, disk reads with latency, and the stream columns that make a fast query take minutes.
• Dev, Test, Production — with a real guard. A [PROD] badge on every tab, plus a read-only mode that the editor, grid and Data Pumper actually enforce.
• Export, Import, Compile and Delete in the Classes context menu work on IRIS again.
• And beyond IRIS: connect to Azure SQL, Fabric Warehouse and Fabric SQL database with the same sign-in methods SSMS offers — run az login once, no token to paste. When Azure refuses a connection, you get the actual reason instead of "Login failed".

more details: https://sqldatalens.com/whats-new/4-01/

Initial Release

Initial Release

readme updated

Initial Release

Addressed reported issue on Nov 3, 2025.
Plase see https://github.com/IRISMeister/iris-c-language/issues/2 for details.

video youtube

rename

Initial Release

some readme updates

Initial Release

Initial Release

Initial Release

Initial Release

SQL Data Lens 4.00 is out.
The goal of this release was straightforward: make day-to-day work with InterSystems IRIS and Caché a little easier.
Here are the five biggest changes.
→ Query Cloud can now join multiple databases in a single query
SQL Data Lens uses Apache Calcite to federate queries across different sources while pushing filters, joins and aggregations down to each system whenever possible.
IRIS + PostgreSQL + a folder full of CSV files.
One SQL statement.
→ SQL History is now searchable
The old day-by-day tree is gone.
History entries can be sorted, filtered, pinned and exported. Failed and cancelled statements are now included as well, which makes troubleshooting much easier.
→ The SQL Scanner catches even more issues
Foreign key analysis now works for IRIS and Caché.
A new statistics check helps identify stale optimizer statistics, and index recommendations take actual column cardinality into account.
Every finding includes an explanation and a suggested SQL statement.
→ One-click navigation from tables to classes and globals
Class names and global names are hyperlinks now.
Small change. Surprisingly useful.
→ Execution plans are finally readable
Plain text. Selectable. Searchable. Copyable.
DuckDB, PostgreSQL and SQL Server are supported, and Query Cloud can explain its own federated execution strategy through Show Federation Plan.
I also reworked the website and added a transparent comparison with the Management Portal, DBeaver and DataGrip, highlighting the strengths and focus areas of each tool.
SQL & data tooling built for InterSystems IRIS and Caché.
Free download for Windows. No signup required.
Link in the first comment.
If you're working with IRIS, or running a Caché system that's older than some of your colleagues, give it a try and tell me what's missing.
Several features in this release came directly from user feedback.

SQL Data Lens 4.00 is out.
The goal of this release was straightforward: make day-to-day work with InterSystems IRIS and Caché a little easier.
Here are the five biggest changes.
→ Query Cloud can now join multiple databases in a single query
SQL Data Lens uses Apache Calcite to federate queries across different sources while pushing filters, joins and aggregations down to each system whenever possible.
IRIS + PostgreSQL + a folder full of CSV files.
One SQL statement.
→ SQL History is now searchable
The old day-by-day tree is gone.
History entries can be sorted, filtered, pinned and exported. Failed and cancelled statements are now included as well, which makes troubleshooting much easier.
→ The SQL Scanner catches even more issues
Foreign key analysis now works for IRIS and Caché.
A new statistics check helps identify stale optimizer statistics, and index recommendations take actual column cardinality into account.
Every finding includes an explanation and a suggested SQL statement.
→ One-click navigation from tables to classes and globals
Class names and global names are hyperlinks now.
Small change. Surprisingly useful.
→ Execution plans are finally readable
Plain text. Selectable. Searchable. Copyable.
DuckDB, PostgreSQL and SQL Server are supported, and Query Cloud can explain its own federated execution strategy through Show Federation Plan.
I also reworked the website and added a transparent comparison with the Management Portal, DBeaver and DataGrip, highlighting the strengths and focus areas of each tool.
SQL & data tooling built for InterSystems IRIS and Caché.
Free download for Windows. No signup required.
Link in the first comment.
If you're working with IRIS, or running a Caché system that's older than some of your colleagues, give it a try and tell me what's missing.
Several features in this release came directly from user feedback.

Initial Release

[2.17.1] - 2026-08-18

Fixed

• Fixed corruption of non-ASCII characters when importing lookup tables and other custom Studio documents (#990)
• Fixed a bug where interop deployment manager would in some cases fail because it tried to load unrelated items from the repo (#977)
• Improved reporting of <NOTOPEN> errors on the git executable, with an actionable message and diagnostics pointing to likely causes (#462)
• Fixed bugs causing compilation errors when first adding an IRIS Interoperability BPL or BR (#984)

. fix docker-compose.yml

Initial Release

Initial Release

Initial Release

Initial Release

3.24 released on 2026-08-10
ENH : New InterSystems IRIS driver 3.10.5 added (from IRIS 2026.1)
FIXED: GlobalViewer: Invalid global value format is show to the user (e.g. $LB selected, but is not in this format)
FIXED: GlobalViewer: Mixed data types in global keys on the the same subscript level handled now correctly
ENH : DuckDb driver upgraded to 1.5.5.1
ENH : H2 driver upgraded to 2.4.240
ENH : Trino driver upgraded to 483
ENH : MariaDB driver upgraded to 3.5.10

Initial Release

• ENH : New InterSystems IRIS driver 3.10.5 added (from IRIS 2026.1)
• FIXED: GlobalViewer: Invalid global value format is show to the user (e.g. $LB selected, but is not in this format)
• FIXED: GlobalViewer: Mixed data types in global keys on the the same subscript level handled now correctly
• ENH : DuckDb driver upgraded to 1.5.5.1
• ENH : H2 driver upgraded to 2.4.240
• ENH : Trino driver upgraded to 483
• ENH : MariaDB driver upgraded to 3.5.10

Upgraded Python library versions to the latest compatible releases.

Multi-server and Governance Added

Upgraded Python library versions to the latest compatible releases.

-WorkList use case: now uses ScheduleProcedure date, better test data