Alternatives to LiteCLI
A command-line SQLite client with auto-completion and syntax highlighting. The listings below can replace it for an important use case. Each note says what changes if you switch.
The original
LiteCLI
A command-line SQLite client with auto-completion and syntax highlighting.
Replacements
Listings that take over the same core job as LiteCLI.
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 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.
