SQL Editor

SQL Editor

Multiple connections, independent tabs

Open as many connection workspaces as your workflow needs. Each connection owns an independent set of SQL and table tabs, its selected database and its active tab. Moving between servers restores that connection's exact context, which makes parallel local, staging and production work much safer and faster.

Tabs preserve unsaved SQL, cursor and scroll position. They return after a normal restart and from the most recent safe session after an unexpected shutdown; query results and credentials are intentionally excluded.

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.