# TUI Table Navigation

When viewing query results in the TUI, you have full Vim-style navigation and editing capabilities.

## Basic Navigation

| Key | Action |
|-----|--------|
| `h`, `←` | Move left |
| `j`, `↓` | Move down |
| `k`, `↑` | Move up |
| `l`, `→` | Move right |
| `g` | Jump to first row |
| `G` | Jump to last row |
| `0`, `_`, `Home` | Jump to first column |
| `$`, `End` | Jump to last column |
| `Ctrl+u`, `PgUp` | Page up |
| `Ctrl+d`, `PgDown` | Page down |

## Data Operations

| Key | Action |
|-----|--------|
| `v` | Enter visual selection mode |
| `y` | Copy selected cell(s) to clipboard |
| `x` | Export selected cell(s) as csv, tsv, json, sql insert statement, markdown or html to clipboard |
| `Enter` | Show cell value in detail view (with JSON formatting) |
| `u` | Update current cell |
| `D` | Delete current row |
| `e` | Edit and re-run query |
| `s` | Save current query |
| `H` | Show keyboard shortcuts overlay |
| `?` | Toggle keybindings help in footer |
| `q`, `Ctrl+c`, `Esc` | Quit table view |

## Search

| Key | Action |
|-----|--------|
| `/` | Search cell content |
| `n` | Jump to next cell match |
| `N` | Jump to previous cell match |
| `f` | Search column names |
| `;` | Jump to next column match |
| `,` | Jump to previous column match |

## Detail View Mode

Press `Enter` on any cell to open a detailed view that shows the full cell content. If the content is valid JSON, it will be automatically formatted with proper indentation.

**In Detail View:**

| Key | Action |
|-----|--------|
| `↑`, `↓`, `j`, `k` | Scroll through content |
| `u` | Update cell content (opens editor with formatted JSON) |
| `o` | Open value in `$EDITOR` (read-only) |
| `y` | Copy value to clipboard |
| `q`, `Esc`, `Enter` | Close detail view |

## Help Overlay

Press `H` to open a categorized keyboard shortcuts reference. The overlay is context-aware — it adjusts the "Actions" section based on the current view (tables list, query without primary key, etc.). Press `H`, `q`, or `Esc` to close.

## Configurable Keybindings

All keybindings can be customized in `~/.config/squix/config.yaml` under the `keybindings` key. Each action accepts a single key or a list of keys.

```yaml
keybindings:
  quit: ["q", "ctrl+c"]
  move_up: k
  move_down: j
  search: "/"
  help: H
```

Keybindings are resolved per **mode** — different views can bind the same key to different actions:

| Mode | Context |
|------|---------|
| `normal` | Main table view |
| `detail` | Cell detail view (opened with `Enter`) |
| `help` | Help overlay |

Unknown action names print a warning at startup. Conflicting keys within the same mode also print a warning.

### Action Reference

| Action | Default | Description |
|--------|---------|-------------|
| `move_up` | `k`, `up` | Move selection up |
| `move_down` | `j`, `down` | Move selection down |
| `move_left` | `h`, `left` | Move selection left |
| `move_right` | `l`, `right` | Move selection right |
| `jump_first_row` | `g` | Jump to first row |
| `jump_last_row` | `G` | Jump to last row |
| `jump_first_col` | `0`, `home`, `_` | Jump to first column |
| `jump_last_col` | `$`, `end` | Jump to last column |
| `page_up` | `ctrl+u`, `pgup` | Page up |
| `page_down` | `ctrl+d`, `pgdown` | Page down |
| `visual_mode` | `v` | Visual (characterwise) selection |
| `visual_line_mode` | `V` | Visual line selection |
| `yank` | `y` | Copy selection to clipboard |
| `export` | `x` | Export selected cells |
| `export_all` | `X` | Export all rows |
| `enter` | `enter` | Open detail view / select table |
| `update` | `u` | Update current cell |
| `delete_row` | `D` | Delete current row |
| `edit_sql` | `e` | Edit and re-run SQL |
| `save_query` | `s` | Save current query |
| `search` | `/` | Search cell content |
| `search_col` | `f` | Search column names |
| `next_match` | `n` | Next search match |
| `prev_match` | `N` | Previous search match |
| `prev_col_match` | `,` | Previous column match |
| `next_col_match` | `;` | Next column match |
| `help` | `H` | Show help overlay |
| `toggle_footer` | `?` | Toggle footer keybinds display |
| `quit` | `q`, `ctrl+c` | Quit table view |
| `detail_close` | `q`, `esc`, `enter` | Close detail view |
| `detail_edit` | `u` | Update cell from detail view |
| `detail_yank` | `y` | Copy from detail view |
| `detail_scroll_up` | `k`, `up` | Scroll detail view up |
| `detail_scroll_down` | `j`, `down` | Scroll detail view down |
| `detail_open` | `o` | Open value in editor (detail view) |
| `help_close` | `H`, `q`, `esc` | Close help overlay |