# 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. ## 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/e5ca8ce900cd68f5419e1c39ae517343100b306336cbaeb70a3c153121d95094-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 - **Package manager page:** - **Version:** 1.17.1 - **Source summary:** CLI for SQLite Databases with auto-completion and syntax highlighting - **Homepage:** - **Repository:** - **Upstream docs:** - **License:** BSD-3-Clause - **Source archive:** - **Last updated:** 2026-06-15T10:20:20-04:00 - **Generated:** 2026-07-09T07:20:21+00:00 ## Executables - litecli (cli) - litecli (alias) ## Dependencies - certifi - libyaml - pydantic - python@3.14 ## Build dependencies - rust ## Uses from macOS - sqlite ## Install behavior - Post-install hook: not defined - Bottle: available on arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux ## Freshness - Page generated: 2026-07-09 - Package-manager version: 1.17.1 - Package-manager updated: 2026-06-15 - Local data: ok - Upstream repository: https://litecli.com - info: Release/tag comparison is only available for GitHub repositories. ## 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 ## Source Database Details - **Source Database:** Homebrew formula API - **Tap:** homebrew/core - **Full Name:** litecli - **Version Scheme:** 0 - **Revision:** 2 - **Bottle Stable Root URL:** - **Deprecated:** no - **Disabled:** no - **Keg Only:** no - **URL Keys:** stable ## 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-2.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/e5ca8ce900cd68f5419e1c39ae517343100b306336cbaeb70a3c153121d95094-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 ## Related links - [Terminal utility packages](https://www.automicvault.com/pkg/terminal-utilities/) - Matched terminal and command-line workflow metadata. - [Text processing packages](https://www.automicvault.com/pkg/text-processing-tools/) - Matched text, document, or structured-data processing metadata. - [Developer build packages](https://www.automicvault.com/pkg/developer-build-tools/) - Matched build, compiler, generator, or developer workflow metadata. - [Networking and protocol packages](https://www.automicvault.com/pkg/networking-protocol-tools/) - Matched network, protocol, or remote-service metadata. - [python@3.14](https://www.automicvault.com/pkg/brew/python-3-14/) - Runtime dependency declared by Homebrew. - [rust](https://www.automicvault.com/pkg/brew/rust/) - Build dependency declared by Homebrew. - [dbhash](https://www.automicvault.com/pkg/brew/dbhash/) - Shares av.db curated category or tags: cli, database, developer-tools, sqlite. - [mongosh](https://www.automicvault.com/pkg/brew/mongosh/) - Shares av.db curated category or tags: cli, database, database-client, developer-tools. - [pgcli](https://www.automicvault.com/pkg/brew/pgcli/) - Shares av.db curated category or tags: autocomplete, cli, database, database-client, developer-tools. - [dblab](https://www.automicvault.com/pkg/brew/dblab/) - Shares av.db curated category or tags: cli, database, database-client, developer-tools, sqlite. - [neonctl](https://www.automicvault.com/pkg/brew/neonctl/) - Shares av.db curated category or tags: cli, database, developer-tools. - [sqlcmd](https://www.automicvault.com/pkg/brew/sqlcmd/) - Shares av.db curated category or tags: cli, database, developer-tools. - [dbmate](https://www.automicvault.com/pkg/brew/dbmate/) - Shares av.db curated category or tags: cli, database, developer-tools, sqlite. - [harlequin](https://www.automicvault.com/pkg/brew/harlequin/) - Shares av.db curated category or tags: cli, database, database-client, developer-tools. - [http-prompt](https://www.automicvault.com/pkg/brew/http-prompt/) - Both packages touch the same language runtime or ecosystem. Shared terms: autocomplete, certifi, cli, client, developer. ## Combined YAML source View the package source record on GitHub. [combined/litecli.yml](https://github.com/automic-vault/db/blob/main/combined/litecli.yml) ## Sources - Nucleus package database - Geiger risk classifier - package-page enrichment - curated configuration and credential file locations - curated package history - package version freshness - av.db category and tag curation - package relationship graph - external package-manager database matches - cross-ecosystem install command graph