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
- Open the query console for the connection.
- Write SQL in the editor.
- Run the current statement with Ctrl+Enter.
- 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.