# Configuration

Squix stores its configuration at `~/.config/squix/config.yaml`.

## Row Limit `default_row_limit: 1000`
All queries are automatically limited to prevent fetching massive result sets. Configure via `default_row_limit` in config or use explicit `LIMIT` in your SQL queries.

Setting `default_row_limit: 0` **disables** automatic limiting — no row-limit clause is appended to your SQL. This matters on databases where the generated limit syntax is unsupported: e.g. Oracle before 12c rejects `FETCH FIRST ... ROWS ONLY` with `ORA-00933: SQL command not properly ended`.

Defaults:
- **Newly created** config files get `default_row_limit: 1000` written on first run.
- An **existing** file missing the key falls back to `0` (no limit).

## Column Width `default_column_width: 15`
The width for all columns in the table TUI is fixed to a constant size, which can be configured through `default_column_width` in the config file. There are plans to make the column widths flexible in future versions.

## Color Schemes `color_scheme: "default"`
Customize the terminal UI colors with built-in schemes:

**Available schemes:**
`default`, `dracula`, `gruvbox`, `solarized`, `nord`, `monokai`
`black-metal`, `black-metal-gorgoroth`, `vesper`, `catppuccin-mocha`, `tokyo-night`, `rose-pine`, `terracotta`

Each scheme uses a 7-color palette: Primary (titles, headers), Success (success messages), Error (errors), Normal (table data), Muted (borders, help text), Highlight (selected backgrounds), Accent (keywords, strings).

## UI Visibility `ui_visibility`

Control which UI components are displayed in the table view:

```yaml
ui_visibility:
  query_name: true          # Show query name header
  query_sql: true           # Show SQL query display
  type_display: true        # Show column type indicators
  key_icons: true           # Show primary key (⚿) and foreign key (⚭) icons
  footer_cell_content: true # Show current cell preview in footer
  footer_stats: true        # Show row/col count and position in footer
  footer_keymaps: true      # Show keybindings help in footer
```

**Tip:** Press `?` in the table view to toggle the keymaps help on/off.

## Keybindings `keybindings`

Customize keyboard shortcuts in the table view. Each action accepts a single key or a list of keys:

```yaml
keybindings:
  move_up: "up"
  move_down: "down"
  move_left: "left"
  move_right: "right"
  search: "ctrl+f"
  help: "tab"
  export: ["ctrl+e", "ctrl+x"]
```

Overrides only the actions you specify — everything else keeps its default binding. See [Keybindings](keybindings.md) for the full action reference and details on modes.