Write and run queries

Write, run and inspect

1. Open a query tab for the connection you want to use. Check the connection and database before running a statement.
2. Write a query using autocomplete and formatting. Use the editor’s Run control to execute it.
3. Inspect the results grid. For large results, data can arrive in chunks; allow the query to finish before assuming you have every row.

SELECT *
FROM customers
LIMIT 20;

Keep useful queries

Save queries you want to reuse, and use query history to return to statements you have run. Templates and snippets can help with repeated SQL patterns.

Understand the query plan

Run EXPLAIN from the query editor and open the Plan view. The presentation depends on the engine: a structured tree, tabular output or text can be used.

Use the plan to identify scans and expensive operations. A plan is a diagnostic aid; it does not guarantee a particular execution time.

Statements that change data

Meja warns before destructive statements. Read the statement and confirmation carefully. A confirmation prompt does not replace a backup or a safe database workflow.