Vim Mode

Vim mode is one of vi-sql's two keybinding profiles. It uses hjkl navigation, sequence motions like gg, and vim-style copy/delete. Enable it in the options page, or set ui.vimMode in your config.yaml:

yaml

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

tip

Not a vim user? See the Keybindings page for the default key map.

Key	Action
`k`	Move up
`j`	Move down
`h`	Move left
`l`	Move right
`gg`	Go to first item
`G`	Go to last item
`Ctrl+k`	Focus panel up
`Ctrl+j`	Focus panel down
`Ctrl+h`	Focus panel left
`Ctrl+l`	Focus panel right

Common actions

Key	Action
`dd`	Delete
`yy`	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
`:`	Actions palette
`gt`	Go to table
`gv`	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
`ge`	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
`yc`	Copy cell
`yy`	Copy row
`yrj`	Copy row as JSON
`yrc`	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
`gd`	Follow foreign key
`gr`	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`
`gf`	Format SQL
`Ctrl+n` / `↓`	Autocomplete: next
`Ctrl+p` / `↑`	Autocomplete: previous
`Ctrl+y` / `Enter`	Autocomplete: accept

Customizing keybindings

Edit keybindings-vim.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.