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

What's new

Multi-instance connection pool

Every execution tool now accepts an optional server parameter. Pass a server name and
the call routes to that instance without touching the default connection:

{ "tool": "iris_execute", "server": "prod", "code": "Write $ZV" }

iad maintains its own server registry at ~/.config/iris-agentic-dev/servers.json.
Passwords go to the OS keychain — never to the config file — using the same service name
as VS Code Server Manager, so both tools share credentials automatically.
Five new tools manage the pool: iris_servers, iris_add_server, iris_remove_server,
iris_test_server, and iris_import_servers.

Persistent WebSocket terminal sessions

Three new tools give Claude a persistent ObjectScript terminal over WebSocket:
iris_ws_open, iris_ws_exec, iris_ws_close. Variables and process state persist
between calls. Before this, every iris_execute call was a fresh context — a sequence
like "set X, do some work, read X back" had to be one call or use a global to carry
state. Now each step can be separate. Requires IRIS 2023.2+ (Atelier V7 API).

Administration and cross-instance comparison

Twenty-two new tools across global management, namespace/database admin, observability,
and cross-instance comparison. Most of this section is ported from Pierre Abdelsayed's
Server Manager MCP work — the global confirmation pattern, namespace/database admin,
observability tools, HL7 schema tools, Mermaid diagrams, and resolve_storage all
originate from his design. The data safety gates (PHI policy, system globals blocklist,
environment template) are also his, ported to Rust in an earlier release.

• Global management: global_preview + global_kill. Preview returns a confirmation
  
  
  token; kill requires it. The token is bound to the specific global and server, expires
  after 5 minutes.
• Namespace/database: iris_namespace_list, iris_namespace_create,
  
  
  iris_database_list, iris_database_stats.
• Observability: journal_search, query_audit_log, stream_inspect, my_access,
  
  
  capability_matrix.
• HL7 schema: hl7_schema_list, hl7_schema_inspect. Return HL7_NOT_AVAILABLE
  
  
  cleanly on IRIS builds without EnsLib.HL7.Schema (requires HealthShare or IRIS for Health).
• Visualization: mermaid_class, mermaid_production, resolve_storage.
• Cross-instance comparison: compare_document (unified diff of a single document
  
  
  across two servers), compare_namespace (full namespace diff).

MCP ToolAnnotations

All 64 tools now carry MCP ToolAnnotations. 57 are tagged read_only_hint = true
(queries, introspection, list tools). The 7 destructive tools — global_kill,
iris_admin, iris_credential_manage, iris_lookup_manage, iris_namespace_create,
iris_remove_server, skill_forget — are tagged destructive_hint = true. Claude Code
and other MCP clients that read these hints can show a confirmation step before
destructive calls and run read-only tools without prompting.

Notable fixes

Production management and skill tools broken on Atelier REST connections

iris_production, iris_production_item, and all skill tools returned errors or empty
results on connections without IRIS_CONTAINER set: VS Code extension, remote servers,
anything not running in a named local container. These tools have working Atelier REST
paths; the docker-exec fallback was routing around them. All affected tools now use
Atelier REST.

Breaking changes

None. All existing tool calls work identically. The server parameter defaults to
omitted, so hot-reload and active-connection behavior are unchanged.
iris_select_container still works.

Publish in Package Manager

Initial Release

Fixed the versioning issues.

• reorganize for Caché / Ensemble use only
• make it independent of other packages
• there's no ZPM on Caché >> all extras removed
• tie demo to Caché in Docker
• simplify container build
• include and run demo code in Docker build

Python Package Updated

Initial Release

Fixed timeout for the end-2-end run with model training. Ceiling corrected to 60s from 45s, updated to accommodate GaiaQualityScored's INSERT...SELECT with two PREDICT() calls over 74,998 rows was added. No code or model changes.

Today

Whoop and bundles support

Fix last week

make date filtering work with the FHIR server