# Install litecli with Homebrew, apk, apt, dnf, MacPorts, Nix CLI for SQLite Databases with auto-completion and syntax highlighting. Version 1.17.1 via Homebrew; verified 2026-06-15. Also installable with debian: sudo apt install litecli. ## Install ```sh sudo av install brew:litecli ``` Additional install commands: ### macOS - Homebrew (100%): ```sh brew install litecli ``` Evidence: local Homebrew formula metadata - MacPorts (94%): ```sh sudo port install litecli ``` Evidence: MacPorts ports tree: databases/litecli/Portfile from https://api.github.com/repos/macports/macports-ports/git/trees/master?recursive=1 ### Linux - apk (92%): ```sh sudo apk add litecli ``` Evidence: Alpine Linux edge package indexes: litecli from https://dl-cdn.alpinelinux.org/alpine/edge/community/x86_64/APKINDEX.tar.gz - Debian apt (92%): ```sh sudo apt install litecli ``` Evidence: Debian stable package indexes: litecli from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz - dnf (92%): ```sh sudo dnf install litecli ``` Evidence: Fedora Rawhide package metadata: litecli from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/07190dc5ae9f35ae73866675fed6d95fe6e8d9fe22c9d7cdf85862cb2ed24a4c-primary.xml.zst - Nix (92%): ```sh nix profile install nixpkgs#litecli ``` Evidence: nixpkgs package indexes: pkgs/by-name/li/litecli/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1 ## Package facts - **Package key:** brew:litecli - **Package manager:** Homebrew - **Version:** 1.17.1 - **Source summary:** CLI for SQLite Databases with auto-completion and syntax highlighting - **Homepage:** - **Last updated:** 2026-06-15T10:20:20-04:00 - **Generated:** 2026-08-03T19:37:03+00:00 ## Executables - litecli (alias) ## Install behavior - Bottle: not available ## Freshness - Page generated: 2026-08-03 - Package-manager version: 1.17.1 ## Project history and usage LiteCLI is a command-line SQLite client from the dbcli family, designed around auto-completion, syntax highlighting, and a friendlier interactive SQL prompt. It brings the style popularized by pgcli and mycli to SQLite databases. ### Project history LiteCLI was announced on January 3, 2019 by Amjith Ramanujam, the maintainer associated with the dbcli tools. The launch post described it as a user-friendly SQLite command-line client based on pgcli and mycli. The project matured as a Python CLI distributed through PyPI, Homebrew, and Linux package repositories. Its README and documentation focus on practical interactive use: opening a database, tabular output, completion, highlighting, and a generated configuration file. ### Adoption history LiteCLI's adoption follows the dbcli pattern: Python users can install it with pip, macOS users can install it with Homebrew, and distro packages make it available on common Linux systems. Its appeal is strongest for developers who want SQLite exploration without a heavyweight GUI. ### How it is used Users run `litecli DATABASE` or `litecli :memory:` to open a SQLite session. On first launch, LiteCLI creates a configuration file at `~/.config/litecli/config` on Unix-like systems and `~\AppData\Local\dbcli\litecli\config` on Windows. ### Why package nerds care LiteCLI is significant because it packages a quality-of-life database shell as a small Python command. It is a good example of a package whose value is interactive ergonomics: prompt-toolkit-style completion, highlighting, formatting, and sane defaults wrapped around SQLite. ### Timeline - 2018-12-05: PyPI recorded an early 0.0.2 release. - 2019-01-03: The LiteCLI launch post introduced the project as a SQLite client based on pgcli and mycli. - 2019-01-04: PyPI recorded version 1.0.0. - 2026-01-31: PyPI recorded version 1.17.1. ### Related projects - Related projects include SQLite, pgcli, mycli, dbcli's shared helper libraries, Python prompt-toolkit, and other interactive SQL shells. ### Sources - - - - - ## Security Notes No matching local secret-handling manifest was found for litecli. Nucleus package metadata is still published here so future coverage has a stable package URL. ## Configuration and credential file locations These source-backed paths show where this package keeps local settings or durable credentials. Automic Vault can use them as review targets for secret scanning, migration, and command approval. ## Configuration files - Unix: ~/.config/litecli/config - Windows: ~\AppData\Local\dbcli\litecli\config ## Other Package-Manager Records - Debian apt - litecli - 1.15.0-2: normalized package name match | Debian stable package indexes: litecli from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz | CLI for SQlite with auto-completion and syntax highlighting | https://litecli.com - Nix - litecli: normalized package name match | nixpkgs package indexes: pkgs/by-name/li/litecli/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1 - Ubuntu apt - litecli - 1.10.0-1: normalized package name match | Ubuntu 24.04 LTS package indexes: litecli from https://archive.ubuntu.com/ubuntu/dists/noble/universe/binary-amd64/Packages.gz | CLI for SQlite with auto-completion and syntax highlighting | https://litecli.com - apk - litecli - 1.17.1-r1: normalized package name match | Alpine Linux edge package indexes: litecli from https://dl-cdn.alpinelinux.org/alpine/edge/community/x86_64/APKINDEX.tar.gz | CLI for SQLite Databases with auto-completion and syntax highlighting | https://litecli.com/ - apk - litecli-pyc - 1.17.1-r1: normalized package name match | Alpine Linux edge package indexes: litecli-pyc from https://dl-cdn.alpinelinux.org/alpine/edge/community/x86_64/APKINDEX.tar.gz | Precompiled Python bytecode for litecli | https://litecli.com/ - dnf - litecli - 1.17.1-3.fc45: normalized package name match | Fedora Rawhide package metadata: litecli from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/07190dc5ae9f35ae73866675fed6d95fe6e8d9fe22c9d7cdf85862cb2ed24a4c-primary.xml.zst | CLI for SQLite Databases with auto-completion and syntax highlighting | https://litecli.com - MacPorts - litecli: normalized package name match | MacPorts ports tree: databases/litecli/Portfile from https://api.github.com/repos/macports/macports-ports/git/trees/master?recursive=1 ## Combined YAML source View the package source record on GitHub. [combined/litecli.yml](https://github.com/mxcl/pkgdb/blob/main/combined/litecli.yml) ## Sources - pkg.so package database - Geiger risk classifier - curated configuration and credential file locations - curated package history - pkgdb category and tag curation - external package-manager database matches - cross-ecosystem install command graph