Loop Life

Loop SQL IDE

Your SQL IDE works for you!

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!

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.

Results the way teams ship them

Grid, text, JSON, XML, CSV, messages, plan, statistics, problems, and output — plus editable SELECT grids and copy-as-INSERT when you need a fixture.

Git in the same window

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.

One connection list

Default connection can reconnect on startup. The same saved list drives Auto Insert, Data Conversion, and Visual Schema import.

Loop SQL Terminal

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.

Limitless Export Wizard

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.