SQL Editor

SQL Editor

LakeDB uses Monaco Editor and supports multiple independent SQL tabs per connection.

Execution

• Run selected text, the statement under the cursor, or the entire script.
• Cancel an active server query with KILL QUERY.
• Multi-statement scripts are split and run sequentially without enabling the driver's unsafe multipleStatements option.

Results

Every result set gets its own tab. Copy cells or rows, generate INSERT/UPDATE snippets, and export CSV, JSON or Excel-compatible .xls. Large results are limited and kept temporarily in memory rather than persisted in the session.

Files, history and favorites

Open, save and save-as .sql files. LakeDB restores unsaved documents, cursor position and scroll state. Production connections are restored disconnected. History stores result, duration and row count according to your retention preferences; potentially sensitive statements can be excluded. Favorites support names, descriptions, connections, databases and tags.