sqlclix 0.1.4

A SQL database browser with TUI interface (SQLite & PostgreSQL)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45

# SQLClix

A SQL database browser with TUI interface supporting SQLite and PostgreSQL.

![Query with multiple tabs](https://github.com/user-attachments/assets/fe672c0a-1d28-473e-9d56-defa402180e6)

![JSON view](https://github.com/user-attachments/assets/b9fc49b8-a331-4d85-9081-d340b596735d)

## Install

```bash
make publish  # builds and copies to ~/bin/
```

## Usage

```bash
# SQLite
sqlclix database.db

# PostgreSQL
sqlclix "postgres://user:password@localhost:5432/dbname"
```

## Session State

SQLClix saves your tabs and active tab between sessions. State is stored in a SQLite database at:

- **Linux:** `~/.cache/sqlclix/state.db`
- **macOS:** `~/Library/Caches/sqlclix/state.db`

Database paths are stored as SHA-256 hashes, so connection strings containing credentials are never saved in plaintext.

## Keyboard Shortcuts

| Key | Action |
|-----|--------|
| `Tab` | Switch panels |
| `F5` / `Ctrl+R` | Execute query |
| `F2` | New tab |
| `Ctrl+W` | Close tab |
| `Enter` | Select/expand table, view cell detail |
| `s/c/d` | Generate SELECT/COUNT/DESCRIBE query |
| `?` | Help |
| `q` | Quit |