Litecli
litecli.com
LiteCLI
SQLite CLI with auto-completion and syntax highlighting
Usage
Launch litecli.
Output
The table format can be changed temporarily at runtime from the litecli prompt using the \T table_format special command.
Installation
NOTE: If Python was installed into the “Program Files” directory, you may need to open the command prompt as an administrator for the above command to succeed. Once Python is installed and in the PATH environment variable, open a command prompt, and install litecli using the below command.
Features
SQLite CLI with auto-completion and syntax highlighting
GitHub
github.com › dbcli › litecli
GitHub - dbcli/litecli: CLI for SQLite Databases with auto-completion and syntax highlighting · GitHub
CLI for SQLite Databases with auto-completion and syntax highlighting - dbcli/litecli
Starred by 3.3K users
Forked by 93 users
Languages Python
PyPI
pypi.org › project › litecli
litecli · PyPI
CLI for SQLite Databases with auto-completion and syntax highlighting.
» pip install litecli
Published Jan 31, 2026
Version 1.17.1
x-cmd
x-cmd.com › pkg › litecli
SQLite with Autocomplete? litecli mycli-Style Client for SQLite | X-CMD Package One-Click Setup | litecli
litecli is a command-line client for SQLite databases developed by the dbcli organization, featuring auto-completion and syntax highlighting.
Pgcli
pgcli.com › launching-litecli.html
Launching LiteCLI
LiteCLI is a user-friendly CommandLine client for SQLite database.
Homebrew
formulae.brew.sh › formula › litecli
litecli — Homebrew Formulae
brew install litecli · CLI for SQLite Databases with auto-completion and syntax highlighting · https://github.com/dbcli/litecli · License: BSD-3-Clause · Development: Pull requests · Formula JSON API: /api/formula/litecli.json · Formula ...
Linux Command Library
linuxcommandlibrary.com › man › litecli
litecli man | Linux Command Library
litecli is a SQLite CLI with auto-completion.
Alpine Linux
pkgs.alpinelinux.org › package › edge › community › x86 › litecli
litecli - Alpine Linux packages
litecli-pyc · Provides (2) cmd:litecli · py3.14:litecli ·
Debian
packages.debian.org › sid › database › litecli
Debian -- Details of package litecli in sid
litecli is a command line interface for SQlite with auto-completion and syntax highlighting.
Amjith Ramanujam
amjith.com › introducing llms to litecli
Introducing LLMs to Litecli | Amjith Ramanujam
December 15, 2024 - LiteCLI is a command-line client for SQLite databases that has auto-completion and syntax highlighting. I’ve added the ability to use an LLM to create a SQL query. Disclaimer: This is an EXPERIMENTAL feature. Not yet released. Ask a question about your database in English and get a SQL query ...
LinuxLinks
linuxlinks.com › home › litecli – command-line client for sqlite databases
litecli - command-line client for SQLite databases - LinuxLinks
November 17, 2025 - litecli is a command-line client for SQLite databases that has auto-completion and syntax highlighting. Free and open source software.
Litecli
litecli.com › getting-started
Getting Started
Launch litecli.
Hacker News
news.ycombinator.com › item
Litecli: CLI for SQLite Databases with auto-completion and syntax highlighting | Hacker News
September 13, 2024 - It’s the best one for Python in my opinion. Pretty easy to work with · There also a tmux and vim clone that uses prompt_toolkit iirc
Feldroy
daniel.feldroy.com › posts › til-2024-11-litecli-improved-sqlite-cli
TIL: LiteCLI, Improved SQLite CLI
LiteCLI is a command line interface for SQLite with auto-completion and syntax highlighting.
Amjith Ramanujam
amjith.com › llm in litecli
LLM in Litecli | Amjith Ramanujam
January 26, 2025 - Run the special command \llm in the LiteCLI prompt. This will install the necessary dependency to interact with LLMs. The default model is gpt-4o-mini which is a remote model. You need an API key from OpenAI. You can switch the default to a local model such as Ollama or Llamafile.
Hacker News
news.ycombinator.com › item
LiteCLI – A user-friendly command-line client for SQLite database | Hacker News
January 6, 2019 - It covers the powerful features of the prompt-toolkit library that is used to make this client · We use `less -XRF` by default. You can change this to whatever you want via the config file `~/.config/litecli/config`. Just uncomment the line that says `# pager = "less -SXRF"