The PostgreSQL query console

Run PostgreSQL SQL, inspect visual EXPLAIN plans, compare plans and keep query results beside the editor.

The PostgreSQL query console is an SQL editor beside the result grid. It is intended for statements that need joins, CTEs, functions or a carefully written filter instead of a table-grid operation.

Run SQL deliberately

  1. Write the statement in the SQL editor.
  2. Use Ctrl+Enter to run the current statement.
  3. Use Ctrl+Shift+Enter to run every statement when the script contains more than one.
  4. Keep the result tab open while checking returned columns and values.

The editor also supports Ctrl+F to find text and Ctrl+Shift+F to format SQL. The application keeps these actions separate from the data-grid filter.

Read EXPLAIN as a tree

Run EXPLAIN from the query workflow and inspect the plan as a tree instead of reading one long text block. From the plan view you can ask the AI assistant for advice, on a local model or your own key. Run EXPLAIN again after an index change or a join-order change to check that the plan really improved.

Review writes from the console

A query that changes data still deserves review. Keep destructive statements visible, choose the connection’s safe mode, and verify the target before running. The grid’s optimistic check applies to staged row edits; an arbitrary SQL statement is still your responsibility, so a console run should be treated as a deliberate database operation.

Results can be exported as CSV, JSON, JSON Lines, SQL, Markdown or XLSX where the export surface supports that format. The output is generated from the result or table scope selected in the export dialog.