Running SQL in the Query Tool

Open the Query Tool

Right-click a database > Query Tool, or press the SQL icon. A large editor opens with tabs and an execution toolbar.

Write and Run

SELECT u.username, COUNT(o.id) AS orders
FROM users u
LEFT JOIN orders o ON o.user_id = u.id
GROUP BY u.username
ORDER BY orders DESC;

F5 (or the Play button) executes; results appear in the Data Output grid below, with copy-to-clipboard and export buttons.

Explain Plans

The Explain buttons run EXPLAIN, and the Analyze button additionally runs EXPLAIN ANALYZE. The plans view shows the cost tree - the primary tool for slow-query investigation.

Query History and Tabs

Every execution lands in the query history; multiple tabs hold different investigations without losing context.

Key Points

• F5 runs your SQL and shows the result grid.
• EXPLAIN ANALYZE exposes query costs.
• History and tabs support multi-step analysis.
• Results export to CSV or copy as INSERTs.