TL;DR: echo '.mode box' > ~/.sqliterc


SQLite is a great database (although often overlooked) with a bit of annoying CLI defaults.

For instance:

sqlite> select * from Album limit 10;
1|For Those About To Rock We Salute You|1
2|Balls to the Wall|2
3|Restless and Wild|2
4|Let There Be Rock|1
5|Big Ones|3
6|Jagged Little Pill|4
7|Facelift|5
8|Warner 25 Anos|6
9|Plays Metallica By Four Cellos|7
10|Audioslave|8

Three columns, two of them are numbers, and yet things are hard to read. Write .mode box in your ~/.sqliterc and things change dramatically:

sqlite> select * from Album limit 10;
┌─────────┬───────────────────────────────────────┬──────────┐
│ AlbumId │                 Title                 │ ArtistId │
├─────────┼───────────────────────────────────────┼──────────┤
│ 1       │ For Those About To Rock We Salute You │ 1        │
│ 2       │ Balls to the Wall                     │ 2        │
│ 3       │ Restless and Wild                     │ 2        │
│ 4       │ Let There Be Rock                     │ 1        │
│ 5       │ Big Ones                              │ 3        │
│ 6       │ Jagged Little Pill                    │ 4        │
│ 7       │ Facelift                              │ 5        │
│ 8       │ Warner 25 Anos                        │ 6        │
│ 9       │ Plays Metallica By Four Cellos        │ 7        │
│ 10      │ Audioslave                            │ 8        │
└─────────┴───────────────────────────────────────┴──────────┘