Projects / Caché Monitor

Caché Monitor

Caché Monitor is an SQL development tool for InterSystems database Caché. It features an advanced SQL query editor with SQL syntax highlighting, SQL code completion with context sensitive information about database objects (also known as Intellisense), an SQL history buffer for executed SQL commands, SQL code formatting, parallel queries, graphical SQL execution plan with index and selectivity information, SQL abbreviations, and much more. Database diagrams graphically show the structure of the database.

Operating Systems

Last announcement

Caché Monitor forum online! 09 Oct 2009 08:40

Please use the forum for questions and tips at:

Recent releases

  •  14 May 2014 18:38

    Release Notes: This version contains some minor improvements including much better CLOB\BLOB Handling in Table and in Viewer. A problem where the record dialog couldn't be opened was fixed. The "SELECT first 1000 rows" menu entry now executes the query immediately.

    •  15 Apr 2014 20:28

      Release Notes: For the namespaces list, no access to the "%SYS" namespace is required. The source code in Class Browser shows the same code as in Studio. The Global Browser visualizes different node types with icons. The new Record dialog is available, and shows columns in rows. Each grid in Caché Monitor can open this Record dialog via context menu. In the table viewer, the new storage tab lists the storage information about a table, like global name and global size. All workspace settings are saved on exit and reloaded on startup, so Caché Monitor remembers the window position and state (docked\undocked).

      •  06 Apr 2014 10:04

        Release Notes: This version supports Java 8. To improve performance\minimize user waiting, prefetching of meta data is implemented. The Tables\Views are grouped by schema, and empty schema will not be displayed by default. CodeCompletion works now on all schema by default. The Source-, Class-, and GlobalViewer show the item count on registertitle and in a tree.

        •  01 Apr 2014 20:27

          Release Notes: This release opens the current class in Caché Studio, adds some code completion improvements to show more Caché keywords in completion and coloring, adds some code completion display additional information for keywords and functions, and makes icons visualize the completion type (e.g., Table, Column, Schema, Index, etc.). The Type column shows the primary key, datatype, and nullable property. Optimizer hints are listed with additional information Disconnecting a server no longer closes all subpanels. License management has improved.

          •  22 Jan 2014 19:50

            Release Notes: A new Bulk Export Dialog allows the user to save the current and load the previous selections of Tables. The server version number can now be viewed in the Server Navigator tree, toggled via the Menu "Show version". A new context popup menu in the tables entry allows fast data access via generated SQL: "SELECT first 1000 rows".


            Project Spotlight


            A Fluent OpenStack client API for Java.


            Project Spotlight

            TurnKey TWiki Appliance

            A TWiki appliance that is easy to use and lightweight.