litecli ☆
« Back to VersTracker
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.
Version History
Detected Version Rev Change Commit
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
« Back to VersTracker  |  Browse Packages  |  About