The Server Navigator allows you to browse connections to the InterSystems Caché & InterSystems IRIS databases, as well as many other databases. Organise all these connections into groups and sub-groups in any way that suits your business needs.
The built-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 as you type. Write complex scripts using variables for dynamic execution in different database contexts
Cross database queries
With the Local Query Cloud feature, you can write SQL statements across multiple servers, namespaces and combine (SQL JOIN!) this data with other data sources such as Microsoft SQL Server; Microsoft Access or simple CSV files. All this with zero installation on the server side!
Share database diagrams
Visualise your database with database diagrams. Database diagrams graphically represent the structure of the database. To visualise a database, you can create one or more diagrams that illustrate some or all of the tables, columns, keys, and relationships in the database.