Keybindings

By default vi-sql uses the normal keybinding profile: arrow-key navigation and familiar terminal shortcuts. Switch to vim in the options page, or set ui.vimMode in your config.yaml:

yaml

ui:
  vimMode: false # false = normal, true = vim

tip

Prefer vim? See the Vim Mode page for hjkl navigation and sequence motions.

Key	Action
`↑`	Move up
`↓`	Move down
`←`	Move left
`→`	Move right
`Ctrl+Home`	Go to first item
`Ctrl+End`	Go to last item
`Alt+↑`	Focus panel up
`Alt+↓`	Focus panel down
`Alt+←`	Focus panel left
`Alt+→`	Focus panel right

Common actions

Key	Action
`Ctrl+d`	Delete
`c`	Copy
`Ctrl+v`	Paste
`Ctrl+s`	Confirm
`/`	Filter
`Ctrl+r`	Refresh
`Enter` / `Space`	Select
`a`	Add
`e`	Edit
`Ctrl+u`	Clear input
`Esc`	Close / cancel

Global

Key	Action
`Ctrl+c`	Quit
`F1`	Full-screen help
`Ctrl+o`	Open connection dialog
`Alt+t`	Change theme
`Alt+f`	Expand / collapse footer

Main view

Key	Action
`Ctrl+Space`	Actions palette
`Ctrl+g`	Go to table
`Alt+v`	Go to view
`Ctrl+t`	New tab
`Ctrl+x`	Close tab
`F2`	Rename tab
`\|`	Hide / show schema panel
`Alt+s`	Server info
`Alt+i`	Import CSV
`Ctrl+/`	Focus schema tree

Schema tree

Key	Action
`e`	Expand table
`E`	Expand all
`W`	Collapse all
`s`	Open structure
`i`	Open indexes
`R`	Rename table

Data view

Key	Action
`o` / `Enter`	Peek row
`O`	Full-page peek
`E`	Edit row
`D`	Duplicate row
`c`	Copy cell
`C`	Copy row
`Alt+j`	Copy row as JSON
`Alt+c`	Copy row as CSV
`V`	Multi-select
`Esc`	Clear selection
`s`	Toggle sort bar
`S`	Sort by column
`H`	Hide column
`r`	Reset hidden columns
`Alt+e`	Explain query
`Alt+m`	Export data
`Ctrl+b`	Follow foreign key
`Alt+r`	Find references

Row viewer (peeker)

Key	Action
`Enter`	Expand field
`v`	Open value viewer
`f`	Toggle full screen
`C`	Copy highlighted text

Structure view

Key	Action
`R`	Rename column
`p`	Toggle DDL pane

Explain viewer

Key	Action
`t`	Toggle ANALYZE mode

History

Key	Action
`c`	Copy query
`Alt+d`	Purge history

Index form

Key	Action
`Ctrl+e`	Toggle SQL editor
`Ctrl+a`	Add column

SQL editor

Key	Action
`Alt+z`	Toggle fullscreen editor
`Alt+r`	Query history
`Ctrl+e`	Open query in `$EDITOR`
`Ctrl+f`	Format SQL
`↓`	Autocomplete: next
`↑`	Autocomplete: previous
`Enter`	Autocomplete: accept

Customizing keybindings

Edit keybindings-normal.yaml in your config directory (run vi-sql --paths to find it) to remap any action. The file is created with defaults on first launch.