Live catalog, not a stub tree
The explorer reads schemas, tables, views, routines, triggers, sequences, types, synonyms, security, Extensions, and Jobs from the engine you are actually on.
Loop SQL IDE
Loop SQL IDE is a full featured enterprise SQL workspace inside Loop Life - not a bolted-on query box. Multi-tab scripts, a live data explorer, results in the format you need, and Git version control when the work belongs in a repo!
The explorer reads schemas, tables, views, routines, triggers, sequences, types, synonyms, security, Extensions, and Jobs from the engine you are actually on.
Grid, text, JSON, XML, CSV, messages, plan, statistics, problems, and output — plus editable SELECT grids and copy-as-INSERT when you need a fixture.
Status, diff, log, pull, and push sit next to the editor so a migration script does not have to leave the product to get reviewed.
Default connection can reconnect on startup. The same saved list drives Auto Insert, Data Conversion, and Visual Schema import.
A psql-style command line under the editor. Type a statement ending in ; and press Enter to run it. Lines that start with \ are commands — \dt lists tables, \d describes one, \copy exports or imports CSV through the live connection, and \? prints help. Up and Down walk history. The prompt follows the catalog you are on, so LoopDemoData=# is the connection you actually opened.
One window to write query results to a file. Pick CSV, Parquet, Fixed Width, Tab, JSON, XML, and more, preview 10 rows, then customize extraction, format, and output. Confirm writes every matching row from the database, not only the page on screen. Open it from Loop SQL IDE with Ctrl+Shift+E or Export on a format tab. The Export Utility is used by all of our windows to export your data for you.