Keyboard and mouse reference

Press ? in sqview for help. Ctrl-P opens the command palette, which includes commands such as export, copying as CSV or SQL, global search, restoring hidden columns, freezing the first column, reloading schema, and toggling read-only.

Keys depend on focus. For example, i inserts a row in the grid and shows schema in the sidebar. j follows a foreign-key link when one is focused; ↓ always moves down. In the SQL console, Ctrl-P recalls a statement from history.

The tables below share the README’s keymap section, which is checked against the application’s built-in help. Popup footers provide additional controls for individual tasks.

Move

Keys	Action
`↑↓←→ / h j k l`	Move between cells
`Home / End`	First / last column
`Ctrl-Home / Ctrl-End`	First / last cell of the table
`PgUp / PgDn`	Scroll one page
`Ctrl-↑ / Ctrl-↓`	Scroll one page
`Ctrl-G`	Go to row number
`' then a letter`	Jump to letter in a text-sorted column

Select & copy

Keys	Action
`Shift-↑ / Shift-↓`	Extend the row selection
`Space`	Toggle the focused row
`Ctrl-A`	Select all rows
`Esc`	Clear the selection, then focus the sidebar
`y / Ctrl-C`	Copy the focused cell
`Y`	Copy the focused or selected rows as JSON

Edit

Keys	Action
`Enter`	Edit the cell with the matching picker
`e`	Edit the value as text
`n`	Set the cell to NULL
`i / Ins`	Insert a row below
`d / Del`	Delete the focused or selected rows
`Ctrl-Z`	Undo the last write

Inspect

Keys	Action
`v`	Show the focused row as a record
`j`	Follow the link on a foreign-key cell
`r`	Rows in other tables that reference this row
`Backspace`	Go back after following a link
`Ctrl-F`	Find rows in this table
`:`	SQL console

Filter, sort & columns

Keys	Action
`f`	Filter the focused column
`F`	Clear all filters
`s`	Sort by the focused column (asc, desc, off)
`S`	Add the focused column as a further sort key
`< / >`	Narrow / widen the focused column
`-`	Hide the focused column

Tabs & panels

Keys	Action
`Tab / Shift-Tab`	Switch focus between sidebar and table
`Ctrl-B`	Show / hide the sidebar
`1-9 / 0`	Go to tab 1-10
`] / [ / Ctrl-PgDn / Ctrl-PgUp`	Next / previous tab
`Ctrl-W`	Close the current tab

Keys	Action
`↑↓ / j k`	Move
`← → / h l`	Collapse / expand a section
`Enter`	Open a table or view, fold a section
`i`	Show the schema of the selected item
`Esc`	Back to the table

Popups

Keys	Action
`Esc`	Close
`Enter`	Confirm the selection
`↑↓ PgUp PgDn Home End`	Move in lists
`typing`	Filter the list or edit the field
`Ctrl-A / Ctrl-E`	Start / end of the input
`Ctrl-U / Ctrl-W`	Delete to start / previous word
`Alt-Enter`	New line in the editor; save a staged row
`y / n`	Confirm / cancel a deletion

Mouse

Keys	Action
`Wheel`	Scroll the panel or list under the pointer
`Shift-wheel`	Scroll table columns
`Click`	Focus a cell, select a list item
`Click header`	Sort by that column
`Click / Ctrl-click gutter`	Select / toggle rows
`Drag scrollbar`	Scroll
`Click rail letter`	Jump to that letter
`Click / middle-click tab`	Activate / close the tab

App

Keys	Action
`Ctrl-P`	Command palette: export, copy as CSV/SQL, search all tables, columns
`?`	This help
`Ctrl-Q`	Quit

sqview User Guide