Keymaps Reference
Press ? from the Grid, Query Pad, or Sidebar to open contextual help. The help also covers short-lived floats, pickers, trees, and diagrams that do not belong in the configurable primary-surface catalog.
Cataloged actions can be remapped or disabled through setup() without changing the default keys:
require('dadbod-grip').setup({
keymaps = {
palette = '<F1>',
sidebar_close = '<C-c>',
grid_live_sql = false,
},
}) Setting one cataloged action to false disables that mapping. completion = false removes the completion-specific Query Pad mappings. ai = false keeps A and gA available so they can explain that AI is disabled, while :GripFill remains unavailable.
153 primary mappings are cataloged across four surfaces.
Grid (111)
| Key | Action | Description | Mode |
|---|---|---|---|
C-p | palette | Opens the searchable command palette. | Normal |
? | help | Opens the keymap help. | Normal |
gG | er_diagram | Opens the entity-relationship diagram. | Normal |
gC | connections | Opens the connection picker. | Normal |
C-g | connections_alt | Opens the connection picker with its alternate key. | Normal |
gT | table_picker | Opens the table picker. | Normal |
gt | table_picker_alt | Opens the table picker with its alternate key. | Normal |
gh | query_history | Opens the query history. | Normal |
gq | load_saved | Loads a saved query. | Normal |
Q | welcome | Returns to the welcome screen. | Normal |
q | query_pad | Opens or focuses the query pad. | Normal |
A | ai | Generates SQL from the grid with the configured AI provider. | Normal |
gb | schema_browser | Opens, focuses, or closes the schema browser. | Normal |
go | table_picker_go | Opens the table picker with the short key. | Normal |
1 | tab_1 | Opens the first surface-specific view. | Normal |
2 | tab_2 | Opens the second surface-specific view. | Normal |
3 | tab_3 | Opens the third surface-specific view. | Normal |
4 | tab_4 | Opens the entity-relationship view. | Normal |
5 | tab_5 | Opens the column statistics view. | Normal |
6 | tab_6 | Opens the columns view. | Normal |
7 | tab_7 | Opens the foreign-keys view. | Normal |
8 | tab_8 | Opens the indexes view. | Normal |
9 | tab_9 | Opens the constraints view. | Normal |
j | grid_row_down | Moves down within the data rows. | NormalVisual |
k | grid_row_up | Moves up within the data rows. | NormalVisual |
gg | grid_row_first | Moves to the first data row. | NormalVisual |
G | grid_row_last | Moves to the last data row. | NormalVisual |
h | grid_col_left | Moves left with native Vim count and boundary behavior. | Normal |
l | grid_col_right | Moves right with native Vim count and boundary behavior. | Normal |
w | grid_col_next | Moves to the next column. | Normal |
b | grid_col_prev | Moves to the previous column. | Normal |
Tab | grid_col_tab | Moves to the next column with Tab. | Normal |
S-Tab | grid_col_tab_back | Moves to the previous column with Shift-Tab. | Normal |
e | grid_col_end | Moves to the end of the cell and then advances. | Normal |
0 | grid_col_first | Moves to the first column. | Normal |
^ | grid_col_first2 | Moves to the first column with the alternate key. | Normal |
$ | grid_col_last | Moves to the last column. | Normal |
{ | grid_prev_mod | Moves to the previous modified row. | Normal |
} | grid_next_mod | Moves to the next modified row. | Normal |
i | grid_edit | Opens the current cell for editing. | Normal |
CR | grid_edit_enter | Opens the current cell for editing with Enter. | Normal |
gB | grid_cell_buffer | Opens the current cell in a split buffer. | Normal |
x | grid_null | Stages NULL for the current cell. | Normal |
gU | grid_column_set | Stages one value across the visible column. | Normal |
p | grid_paste | Pastes the clipboard into the current cell. | Normal |
P | grid_paste_rows | Pastes lines into consecutive rows. | Normal |
o | grid_insert | Stages a new blank row. | Normal |
c | grid_clone | Clones the current row with primary keys cleared. | Normal |
d | grid_delete | Toggles staged deletion for the current row. | Normal |
a | grid_apply | Applies all staged database changes. | Normal |
u | grid_undo | Undoes the latest staged change. | Normal |
C-r | grid_redo | Redoes the latest undone change. | Normal |
U | grid_undo_all | Clears all staged changes. | Normal |
e | grid_v_edit | Stages one value across the selected cells. | Visual |
d | grid_v_delete | Toggles staged deletion for the selected rows. | Visual |
x | grid_v_null | Stages NULL across the selected cells. | Visual |
y | grid_v_yank | Yanks the selected cells. | Visual |
gd | grid_v_compare | Compares exactly two selected rows. | Visual |
- | grid_hide_col | Hides the current column. | Normal |
g- | grid_restore_cols | Restores all hidden columns. | Normal |
gH | grid_col_vis | Opens the column visibility picker. | Normal |
= | grid_col_width | Cycles the current column width. | Normal |
T | grid_type_row | Toggles the column type row. | Normal |
gl | grid_live_sql | Toggles the live SQL preview. | Normal |
K | grid_row_view | Opens the current row or selection as key-value pairs. | NormalVisual |
s | grid_sort | Cycles sorting for the current column. | Normal |
S | grid_sort_stack | Adds or cycles a stacked sort. | Normal |
f | grid_filter_cell | Filters by the current cell value. | Normal |
gn | grid_filter_null | Filters the current column for NULL values. | Normal |
gF | grid_filter_build | Opens the structured filter builder. | Normal |
C-f | grid_filter_where | Prompts for a free-form WHERE expression. | Normal |
F | grid_filter_clear | Clears user filters while preserving pinned context. | Normal |
gp | grid_preset_load | Loads a saved filter preset. | Normal |
gP | grid_preset_save | Saves the current filters as a preset. | Normal |
X | grid_reset_view | Clears sorting and user filters and returns to page one. | Normal |
L | grid_next_page | Loads the next page. | Normal |
H | grid_prev_page | Loads the previous page. | Normal |
]p | grid_next_page2 | Loads the next page with the bracket alias. | Normal |
[p | grid_prev_page2 | Loads the previous page with the bracket alias. | Normal |
]P | grid_last_page | Loads the last page. | Normal |
[P | grid_first_page | Loads the first page. | Normal |
ge | grid_explain_cell | Explains the current cell. | Normal |
gK | grid_json_tree | Opens the current JSON value as a tree. | Normal |
gs | grid_preview_sql | Previews the staged SQL. | Normal |
gc | grid_copy_sql | Copies the staged SQL. | Normal |
gi | grid_table_info | Opens compact table information. | Normal |
gI | grid_table_props | Opens detailed table properties. | Normal |
gN | grid_rename_col | Renames the displayed column header. | Normal |
gS | grid_col_stats | Opens statistics for the current column. | Normal |
gR | grid_profile | Profiles every column in the current table. | Normal |
gV | grid_show_ddl | Shows the CREATE TABLE statement. | Normal |
gQ | grid_explain | Shows the query plan. | Normal |
gx | grid_url_open | Opens the URL in the current cell. | Normal |
gD | grid_diff | Compares the current table with another table. | Normal |
ga | grid_aggregate | Aggregates the current column or selection. | NormalVisual |
gE | grid_export_clip | Exports the chosen result scope to the clipboard. | Normal |
gX | grid_export_file | Exports the chosen result scope to a file. | Normal |
y | grid_yank_cell | Yanks the current cell. | Normal |
Y | grid_yank_row | Yanks the current row as CSV. | Normal |
gY | grid_yank_table | Yanks the complete result as CSV. | Normal |
gy | grid_yank_md | Yanks the result as a Markdown table. | Normal |
gf | grid_fk_follow | Follows the foreign key in the current cell. | Normal |
gm | grid_fk_referencing | Opens rows that reference the current row. | Normal |
C-o | grid_fk_back | Returns to the previous relationship result. | Normal |
r | grid_refresh | Refreshes the current result. | Normal |
gW | grid_watch | Toggles automatic result refresh. | Normal |
g! | grid_write_mode | Toggles write-back for supported local files. | Normal |
gO | grid_open_edit | Reopens a read-only result as an editable table. | Normal |
gA | grid_fill | Stages rows generated by the configured AI provider. | Normal |
gL | grid_pin | Pins or unpins the current result. | Normal |
gJ | grid_results | Opens the result switcher. | Normal |
Query Pad (35)
| Key | Action | Description | Mode |
|---|---|---|---|
C-p | palette | Opens the searchable command palette. | Normal |
? | help | Opens the keymap help. | Normal |
gG | er_diagram | Opens the entity-relationship diagram. | Normal |
gC | connections | Opens the connection picker. | Normal |
C-g | connections_alt | Opens the connection picker with its alternate key. | Normal |
gT | table_picker | Opens the table picker. | Normal |
gt | table_picker_alt | Opens the table picker with its alternate key. | Normal |
gh | query_history | Opens the query history. | Normal |
gq | load_saved | Loads a saved query. | Normal |
Q | welcome | Returns to the welcome screen. | Normal |
gb | schema_browser | Opens, focuses, or closes the schema browser. | Normal |
gw | goto_grid | Focuses the grid window. | Normal |
gn | open_notebook | Opens a SQL or Markdown notebook in the query pad. | Normal |
go | table_picker_go | Opens the table picker with the short key. | Normal |
1 | tab_1 | Opens the first surface-specific view. | Normal |
2 | tab_2 | Opens the second surface-specific view. | Normal |
3 | tab_3 | Opens the third surface-specific view. | Normal |
4 | tab_4 | Opens the entity-relationship view. | Normal |
5 | tab_5 | Opens the column statistics view. | Normal |
6 | tab_6 | Opens the columns view. | Normal |
7 | tab_7 | Opens the foreign-keys view. | Normal |
8 | tab_8 | Opens the indexes view. | Normal |
9 | tab_9 | Opens the constraints view. | Normal |
C-CR | qpad_execute | Executes the current SQL block or selection. | NormalInsertVisual |
S-CR | qpad_execute_new | Executes SQL in a new result split. | NormalVisual |
C-s | qpad_save | Saves the query. | Normal |
gA | qpad_ai | Generates SQL in the query pad with the configured AI provider. | Normal |
gF | qpad_format | Formats the query pad SQL. | Normal |
q | qpad_close | Closes the query pad and returns to the welcome screen. | Normal |
C-Space | qpad_complete | Triggers SQL completion. | Insert |
Tab | qpad_complete_next | Triggers completion or selects the next item. | Insert |
S-Tab | qpad_complete_prev | Selects the previous completion item or inserts Shift-Tab. | Insert |
Down | qpad_complete_down | Selects the next completion item or moves down. | Insert |
Up | qpad_complete_up | Selects the previous completion item or moves up. | Insert |
CR | qpad_complete_accept | Accepts the selected completion item or inserts a newline. | Insert |
Sidebar (45)
| Key | Action | Description | Mode |
|---|---|---|---|
C-p | palette | Opens the searchable command palette. | Normal |
? | help | Opens the keymap help. | Normal |
gG | er_diagram | Opens the entity-relationship diagram. | Normal |
gC | connections | Opens the connection picker. | Normal |
C-g | connections_alt | Opens the connection picker with its alternate key. | Normal |
gT | table_picker | Opens the table picker. | Normal |
gt | table_picker_alt | Opens the table picker with its alternate key. | Normal |
gh | query_history | Opens the query history. | Normal |
gq | load_saved | Loads a saved query. | Normal |
Q | welcome | Returns to the welcome screen. | Normal |
q | query_pad | Opens or focuses the query pad. | Normal |
gb | schema_browser | Opens, focuses, or closes the schema browser. | Normal |
gw | goto_grid | Focuses the grid window. | Normal |
gn | open_notebook | Opens a SQL or Markdown notebook in the query pad. | Normal |
1 | tab_1 | Opens the first surface-specific view. | Normal |
2 | tab_2 | Opens the second surface-specific view. | Normal |
3 | tab_3 | Opens the third surface-specific view. | Normal |
4 | tab_4 | Opens the entity-relationship view. | Normal |
5 | tab_5 | Opens the column statistics view. | Normal |
6 | tab_6 | Opens the columns view. | Normal |
7 | tab_7 | Opens the foreign-keys view. | Normal |
8 | tab_8 | Opens the indexes view. | Normal |
9 | tab_9 | Opens the constraints view. | Normal |
CR | sidebar_open | Opens the table under the cursor. | Normal |
S-CR | sidebar_open_spl | Opens the table under the cursor in a new split. | Normal |
l | sidebar_expand | Expands the table under the cursor. | Normal |
h | sidebar_collapse | Collapses the table under the cursor. | Normal |
zo | sidebar_expand_z | Expands the table with the fold-style key. | Normal |
zc | sidebar_collap_z | Collapses the table with the fold-style key. | Normal |
L | sidebar_expand_all | Expands every table. | Normal |
H | sidebar_collap_all | Collapses every table. | Normal |
/ | sidebar_filter | Filters tables by name. | Normal |
F | sidebar_filter_c | Clears the sidebar filter. | Normal |
n | sidebar_next | Moves to the next table. | Normal |
N | sidebar_prev | Moves to the previous table. | Normal |
r | sidebar_refresh | Refreshes the schema. | Normal |
R | sidebar_refresh2 | Force-refreshes the schema. | Normal |
y | sidebar_yank | Yanks the current table or column name. | Normal |
go | sidebar_open_s | Opens the current table with newest rows first. | Normal |
Esc | sidebar_close | Closes the schema sidebar. | Normal |
D | sidebar_drop | Drops the current table after confirmation. | Normal |
+ | sidebar_create | Creates a table. | Normal |
ga | sidebar_attach | Attaches a database to the current DuckDB connection. | Normal |
gd | sidebar_detach | Detaches a database from the current DuckDB connection. | Normal |
gc | sidebar_conns | Opens the connection picker from the sidebar. | Normal |
Cell Editor (6)
| Key | Action | Description | Mode |
|---|---|---|---|
CR | editor_save | Saves the edited cell. | NormalInsert |
C-s | editor_save_alt | Saves the edited cell with the alternate key. | NormalInsert |
Esc | editor_cancel | Cancels the cell edit. | Normal |
q | editor_cancel_q | Cancels the cell edit with the normal-mode key. | Normal |
gx | editor_open_url | Opens the edited value when it is a URL. | Normal |
C-c | editor_cancel_insert | Cancels the cell edit from insert mode. | Insert |