The MySQL query console

Run MySQL and MariaDB SQL, inspect text or JSON EXPLAIN output and export query results without a visual plan.

The MySQL query console is an SQL editor with a result grid. Use it for joins, aggregates, DDL and statements that do not fit the table-grid workflow.

Run a statement

  1. Open the query console for the connection.
  2. Write SQL in the editor.
  3. Run the current statement with Ctrl+Enter.
  4. Check the returned columns and values in the result grid before using them elsewhere.

The editor keeps the query and its result together. A result can be exported through the same data-movement surface used by the MySQL grid. Shift+Enter opens a selected result cell, while Ctrl+F searches the current editor or grid surface.

Read EXPLAIN honestly

MySQL EXPLAIN is exposed as text or JSON, not as a visual plan tree. Run the statement, inspect the returned plan columns and compare a second run after changing an index or predicate. The result is useful for checking access type, chosen key and estimated rows.

Write with review

A DDL or data-changing statement should be visible before it runs. The connection’s safe mode can require confirmation for writes or all runs. A grid edit has the additional row-token check described in safe mode and review, but arbitrary SQL from the console is not converted into a staged grid edit.

Use Ctrl+S for staged grid changes. MySQL query results are read-only in this query console; grid editing remains a separate workflow.