Interactive commands

Browse the session and metadata without sending shell commands to the SQL parser.

Context and metadata

text

.catalogs                 list granted catalogs
.schemas OpenSource       list schemas in a catalog
.tables                   list tables in the active schema
.use OpenSource.public    switch catalog and schema
.settings                 show session settings
.queries                  inspect recent queries

Control work

text

.kill <query-id>          cancel a running query
.watch <query-id>         follow state and counters
.explain                  show the last execution plan
.help                     show command help
.exit                     leave the shell

Use Ctrl-C once to cancel the running statement and again to return to the editor. The prompt shows the active catalog and schema; output includes elapsed time, rows, columns, workers, and the query id.

Shell behaviour

Persistent history, reverse search, tab completion, and Emacs or Vi editing.
Paged results arrive while a streaming query runs; Space or Enter advances pages and q stops paging.
Dot commands stay client-side; SQL statements are sent to the Engine.