Description:
CLI for SQLite Databases with auto-completion and syntax highlighting
|
|
Type: Formula
|
Tracked Since: Dec 28, 2025
|
|
Links:
Homepage |
formulae.brew.sh
|
|
Category: Databases
|
|
Tags:
sqlite
cli
database
sql
developer-tools
|
|
Install:
brew install litecli
|
About:
Litecli is a command-line interface tool for SQLite databases that provides a feature-rich alternative to the standard sqlite3 CLI. It offers intelligent auto-completion for SQL keywords and database schema objects, along with syntax highlighting for improved readability. This tool significantly enhances the developer experience when interacting with SQLite databases directly from the terminal.
|
Key Features:
- Intelligent auto-completion for SQL keywords and table/column names
- Syntax highlighting for improved query readability
- Supports standard SQLite commands and features
- User-friendly interface similar to pgcli and mycli
|
Use Cases:
- Interactive querying and exploration of SQLite databases
- Rapid prototyping of SQL queries with auto-completion assistance
- Database administration and maintenance tasks via CLI
|
Alternatives:
-
sqlite3
– The standard CLI included with SQLite; lacks auto-completion and syntax highlighting out of the box.
-
pgcli
– A similar tool designed for PostgreSQL; Litecli brings the same enhanced UX to SQLite.
|
| Detected |
Version |
Rev |
Change |
Commit |
| May 21, 2026 9:42am |
|
2 |
REVISION_ONLY |
88457eca |
| Mar 31, 2026 8:47am |
|
1 |
REVISION_ONLY |
4bd4cfe1 |
| Sep 28, 2025 11:57pm |
|
0 |
VERSION_BUMP |
b1fce9ea |
| Sep 28, 2025 11:06pm |
|
0 |
VERSION_BUMP |
4b526e80 |
| Sep 16, 2025 6:53am |
|
0 |
VERSION_BUMP |
0ec20766 |
| Dec 15, 2024 11:23am |
|
0 |
VERSION_BUMP |
4b451c1d |
| Nov 23, 2024 11:09pm |
|
0 |
VERSION_BUMP |
b08e1280 |
| Oct 11, 2024 10:43pm |
|
1 |
VERSION_BUMP |
bae980fc |
| Oct 11, 2024 3:02pm |
|
1 |
VERSION_BUMP |
84a2b76a |
| Sep 11, 2024 2:13am |
|
0 |
VERSION_BUMP |
43d50bfb |
| Sep 8, 2024 6:40am |
|
0 |
VERSION_BUMP |
56c49fbc |
| May 3, 2024 6:42pm |
|
0 |
VERSION_BUMP |
3d83641a |
| Apr 16, 2024 8:14am |
|
1 |
VERSION_BUMP |
107ed874 |
| Oct 15, 2023 3:59pm |
|
2 |
VERSION_BUMP |
c3ccfb41 |
| Jan 27, 2023 10:55am |
|
2 |
VERSION_BUMP |
57a63f56 |
|