sqlclix 0.1.1

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

# SQLClix

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

<img width="3840" height="2160" alt="Query with multiple tabs" src="https://github.com/user-attachments/assets/fe672c0a-1d28-473e-9d56-defa402180e6" />

<img width="3840" height="2160" alt="JSON view" src="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"
```

## 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 |