The Server Navigator allows to browse connections to InterSystems Caché & InterSystems IRIS and to many other databases as well. Organize all this connections into groups and sub groups in any way you like to fit your business needs.
The build-in SQL query tool is a sophisticated editor with many powerful editing features for editing and writing complex SQL queries: see table columns, primary and foreign keys while typing. Write complex scripts with variables.
With the feature called Local Query Cloud you can write SQL Statements across multiple Servers, Namespace and combine (SQL JOIN!) this data with other datasources like Microsoft SQL Server; Microsoft Access or simple CSV files. All this with zero installation on server side!
Visualize your database with Database diagrams. Database diagrams graphically show the structure of the database. To visualize a database, you can create one or more diagrams illustrating some or all of the tables, columns, keys, and relationships in it.