Built-in SQL editor
The IOMETE SQL Editor allows you to effectively write and execute queries against your data using modern features and a clean, customizable UI.
Auto-complete
The advanced Autocomplete function removes the need to remember the SQL syntax. It makes proactive suggestions while you type, using the built-in data catalog.
Schema explorer
The Schema Explorer allows you to explore the schema of your databases while writing your query. Make use of the metadata for entities. Get shortcuts for the standard queries with the context menu and insert them into the current worksheet with a click. Copy the names of entities with a keyboard combination.
Worksheets
Save your queries and return back to them whenever you want and with the autosave feature you don’t have to worry about losing any progress.
Query history
Navigate through previous steps, check the metadata of the query, and reuse the query by opening it in the current worksheet.
Query variables
Create Query Variables and use them throughout your worksheets. Safely change the value of a variable from one place without the necessity to edit the query.
Customizable UI
Hide sections or make them full screen if you need to concentrate on something particular. Place your results at the right or go with the default placement at the bottom. With a clean and intuitive UI there is no need to worry about getting uncomfortable with a lot of elements on the screen. Everything is scrollable and manageable.