Documentation

The query editor is a full-featured SQL editor with syntax highlighting, autocomplete, and multi-statement execution.

Running queries

Press ⌘ Enter (or Ctrl+Enter on Windows/Linux) to execute the current query. If you have text selected, only the selected text runs. Use ⌘ ⇧ Enter to run all statements at once.

Multi-statement execution

Write multiple SQL statements separated by semicolons. Keisen splits them and runs each one sequentially, producing a separate result set per statement.

SELECT * FROM users;
SELECT * FROM orders WHERE status = 'pending';

Autocomplete

The editor autocompletes table names, column names, and SQL keywords as you type. Suggestions are schema-aware — they reflect the actual tables and columns in your connected database.

Commenting

Toggle line comments with ⌘ /. The comment style matches your SQL dialect (-- for most engines).

Search and replace

Use ⌘ F to search within your query. The search panel supports regex matching and replace.

Multiple tabs

Open multiple editor tabs per project to work on different queries. Each tab preserves its own query text and results.

Command palette

Press ⌘ K to open the command palette for quick access to actions like running queries, formatting SQL, opening tables, switching themes, and more.