Query Editor and Results Docs

Query Editor and Results

Open a database profile to connect and load its metadata. The workspace shows connection status in the top bar, database metadata on the left, the editor and results in the center, and the optional AI assistant on the right.

Query Tabs

Click the plus button to open another query tab.
Use Save Query to name the current SQL and keep it with the encrypted profile.
Open Saved Queries to reopen, rename, or delete a saved query.
A dot beside a query-tab name indicates unsaved editor changes.

Run Queries

Select SQL and click Run to execute the selection. With no selection, SSH Bridge runs the statement at the cursor. Use the arrow beside Run to execute every statement in the editor. Engine-aware splitting supports MySQL delimiters, SQL Server GO batches, Oracle slash separators, Redis commands, and the SQL dialects used by the other supported engines.

Run current statement — Command+Enter on macOS or Ctrl+Enter on Windows and Linux.
Run all statements — Add Shift to the Run shortcut.
Save query — Command+S on macOS or Ctrl+S on Windows and Linux.

Statements that may change or delete data require confirmation. A running query can be cancelled when the selected driver supports cancellation.

Row Limits and Result Tabs

The row-limit control defaults to 1,000 rows and offers 100, 500, 1,000, 5,000, 10,000, or Unlimited. Use Unlimited carefully. Each executed statement creates its own numbered result tab, so previous results and errors remain available while you continue working.

Resizable Layout

Drag the vertical dividers to resize Metadata and AI Assistant. Drag the horizontal divider between the editor and Results to give more room to either area. Double-click a divider to return it to its default size.

Result Tools

Copy results as TSV, JSON, or Markdown.
Export the current query directly to a CSV file.
Use result paging and filter or sort controls when browsing a table.
Review returned rows, affected rows, elapsed time, and errors in the workspace status and result tabs.

Transactions and Query Plans

Use the transaction menu to begin, commit, or roll back a transaction where supported. Explain Query shows the engine's query plan; Redis does not provide this tool. SQL Server and Oracle use their required multi-step plan workflows automatically.