LiteCLI
A command-line SQLite client with auto-completion and syntax highlighting.
These buttons open the developer's own site, repository or store listing in a new tab. wares.gg does not host downloads.
1 more ways to get LiteCLI
Package managers
- Homebrew
brew install litecli
About LiteCLI
LiteCLI is a terminal client for SQLite databases that adds auto-completion and syntax highlighting to the interactive prompt. You point it at a database file with litecli <db_name> and work with SQL as you would in the standard sqlite3 shell, with suggestions as you type.
It installs with pip or through the dbcli Homebrew tap. LiteCLI is part of the DBCLI organization, which also makes pgcli and mycli, and is a free open-source project suited to anyone who works with SQLite files from the terminal.
Strengths
- Context-aware auto-completion for SQL
- Syntax highlighting in the terminal
- Simple install via pip or Homebrew
Limitations
- Terminal only, no graphical table browser
- Requires a Python environment when installed via pip
Details
- Pricing
- FreeFree and open source.
- License
- Open source, license not stated
- Developer
- The DBCLI contributors
- Platforms
- Command line
- How it runs
- Downloadable app
- Account
- Not required
- Works offline
- Yes
- Best suited for
- Working with SQLite databases from the terminal
- Categories
- CLI tools, Database tools
- Last verified
- Added
- Provenance
- Facts checked against the developer's own pages and store listings, 1 sources on file.
Alternatives to LiteCLI
Compare allSoftware that can replace LiteCLI for an important use case, and what changes if you switch.
SQLite
A small, self-contained SQL database engine that stores a whole database in one file.
SQLite ships its own sqlite3 command-line shell with the engine, so nothing extra needs installing through Python, and the source code is public domain.
Harlequin
A SQL IDE that runs in the terminal, with adapters for DuckDB, SQLite, Postgres and more.
Harlequin is a full terminal SQL IDE with SQLite, DuckDB and Postgres adapters, usable over SSH, though newer Python versions may not suit all dependencies.
usql
Use one command-line interface for many database systems.
usql offers one command-line interface for SQLite and many other databases, though driver availability and feature support vary by database.
dblab
An open-source terminal UI client for browsing and querying PostgreSQL, MySQL, SQLite and other databases.
dblab is a terminal UI client that browses SQLite, PostgreSQL and MySQL databases, with connection settings stored in a config file, from a small maintainer team.
LazySQL
Browse and query databases through a terminal interface.
LazySQL provides a cross-platform terminal interface for browsing and querying databases, but the project describes itself as alpha software.
rainfrog
Query databases through a terminal editor with history and favorites.
rainfrog is a terminal query editor with history, favorites and table inspection, though its database drivers have different support and stability levels.
Similar software
Related functionality, not necessarily a direct replacement.
sqlite-utils
A Python command-line tool and library for creating, querying and transforming SQLite databases.
DB Browser for SQLite
Opens a SQLite file in a spreadsheet-like window so you can look at the data without writing SQL.
Letos
A free, open-source desktop app for creating, editing and browsing SQLite databases, formerly SQLiteStudio.
pgcli
A command-line PostgreSQL client with auto-completion and syntax highlighting.
mycli
A command-line MySQL client with auto-completion, syntax highlighting and fuzzy history search.
Datasette
Publishes SQLite databases as an explorable website and JSON API.
