SQL Management
Learn about execution history, snippets, and other features for efficient SQL management.
History Search / Re-execute
View previously executed query history in the History tab in the result area.
History List Information
| Item | Description |
|---|---|
| Type badge | Color-coded by execution type: SELECT (blue), UPDATE/INSERT/DELETE (green), DDL (purple), ERROR (red) |
| Execution time | Time taken for query execution (milliseconds) |
| Row count | Rows returned or affected |
| Time | Execution timestamp (HH:mm:ss format) |
| SQL preview | First 200 characters of the executed SQL |
Re-execute
Double-click a history item to insert its SQL into the editor for immediate re-execution.
Search
Enter text in the search field at the top of the History tab to filter history by SQL content.
History is saved the moment a query runs and survives closing the tab or the app. How long it is kept depends on the plan — 7 days on Free and local projects, up to 180 days — and older entries are deleted automatically. The window follows the project owner's plan, not the plan of whoever ran the query. Save SQL you need to keep longer as a snippet.
Snippet Save & Reuse
Save frequently used SQL statements as snippets for reuse.
Save SQL
Press Ctrl+S (macOS: Cmd+S) to save the current editor SQL. Saved SQL appears in the left list panel.
Set Name & Connection Info
Click the settings icon in the left list panel to modify the SQL name, connected DB, and default schema.
Load
Click a saved SQL in the left list to load it into the editor.
Each snippet displays associated DB information (DBMS icon + connection color) so you can easily identify which database the SQL is used with.