pkg.soopen package index

brew / rank 2616

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 commandSecurity notes

install

Additional install commands

macOS

Homebrewverified · 100%
brew install litecli

local Homebrew formula metadata

MacPortsverified · 94%
sudo port install litecli

MacPorts ports tree · databases/litecli/Portfile · source: api.github.com

Linux

Alpine Linux apkverified · 92%
sudo apk add litecli

Alpine Linux edge package indexes · litecli · source: dl-cdn.alpinelinux.org

Debian aptverified · 92%
sudo apt install litecli

Debian stable package indexes · litecli · source: deb.debian.org

Fedora dnfverified · 92%
sudo dnf install litecli

Fedora Rawhide package metadata · litecli · source: dl.fedoraproject.org

Nixverified · 92%
nix profile install nixpkgs#litecli

nixpkgs package indexes · pkgs/by-name/li/litecli/package.nix · source: api.github.com

overview

Package summary

CLI for SQLite Databases with auto-completion and syntax highlighting

Commands and aliases

  • litecli

history

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.

security posture

No protected-tool coverage found yet

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.

Install behavior

  • No Homebrew bottle metadata was recorded.

Recommended review

Before unattended agent use, check whether the tool reads plaintext credentials, writes remote state, publishes artifacts, or shells out to plugins.

local files

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

Config paths the tool may read or write during local use.

Unix
~/.config/litecli/config
Windows
~\AppData\Local\dbcli\litecli\config

executables

Installed executables

CommandKindExposureNote
litecliexecutableindexed executableDiscovered from the local executable index.

freshness

Version and freshness

These signals separate page generation age, package-manager activity, and upstream release comparison. Version lag is warned only when an evidence URL and comparable versions are present.

page generated2026-08-03
manager version1.17.1
manager updated2026-06-15
local dataunknown
upstreamnot available
latest detectednot detected
  • okNo freshness warnings were generated.

install metadata

Package metadata

Package keybrew:litecli
Version1.17.1
Package managerHomebrew
Homepagehttps://litecli.com
Last updated2026-06-15T10:20:20-04:00
Pulseupdated
Bottlenot recorded
Servicenone declared

source database matches

Other package-manager records

Matches are pulled from external package-manager indexes and kept separate from local Automic Vault package links.

Debian apt95%

litecli 1.15.0-2

CLI for SQlite with auto-completion and syntax highlighting

https://litecli.com

sudo apt install litecli
  • Section: database
  • Architecture: all
  • 9 dependencies
  • normalized package name match
  • Matched by: Litecli
Debian stable package indexes · deb.debian.org · Debian stable package indexes: litecli from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz
Nix95%

litecli

nix profile install nixpkgs#litecli
  • normalized package name match
  • Matched by: Litecli
nixpkgs package indexes · api.github.com · nixpkgs package indexes: pkgs/by-name/li/litecli/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1
Ubuntu apt95%

litecli 1.10.0-1

CLI for SQlite with auto-completion and syntax highlighting

https://litecli.com

sudo apt install litecli
  • Section: universe/database
  • Architecture: all
  • 7 dependencies
  • normalized package name match
  • Matched by: Litecli
Ubuntu 24.04 LTS package indexes · archive.ubuntu.com · Ubuntu 24.04 LTS package indexes: litecli from https://archive.ubuntu.com/ubuntu/dists/noble/universe/binary-amd64/Packages.gz
apk95%

litecli 1.17.1-r1

CLI for SQLite Databases with auto-completion and syntax highlighting

https://litecli.com/

sudo apk add litecli
  • License: BSD-3-Clause
  • Architecture: x86_64
  • Source Package: litecli
  • 1 dependencies
  • 1 provides
  • normalized package name match
  • Matched by: Litecli
Alpine Linux edge package indexes · dl-cdn.alpinelinux.org · Alpine Linux edge package indexes: litecli from https://dl-cdn.alpinelinux.org/alpine/edge/community/x86_64/APKINDEX.tar.gz
apk95%

litecli-pyc 1.17.1-r1

Precompiled Python bytecode for litecli

https://litecli.com/

sudo apk add litecli-pyc
  • License: BSD-3-Clause
  • Architecture: x86_64
  • Source Package: litecli
  • 1 dependencies
  • normalized package name match
  • Matched by: Litecli
Alpine Linux edge package indexes · dl-cdn.alpinelinux.org · Alpine Linux edge package indexes: litecli-pyc from https://dl-cdn.alpinelinux.org/alpine/edge/community/x86_64/APKINDEX.tar.gz
dnf95%

litecli 1.17.1-3.fc45

CLI for SQLite Databases with auto-completion and syntax highlighting

https://litecli.com

sudo dnf install litecli
  • License: BSD-3-Clause
  • Category: Unspecified
  • Architecture: noarch
  • Source Package: litecli
  • 3 dependencies
  • 4 provides
  • normalized package name match
  • Matched by: Litecli
Fedora Rawhide package metadata · dl.fedoraproject.org · Fedora Rawhide package metadata: litecli from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/07190dc5ae9f35ae73866675fed6d95fe6e8d9fe22c9d7cdf85862cb2ed24a4c-primary.xml.zst
MacPorts95%

litecli

sudo port install litecli
  • normalized package name match
  • Matched by: Litecli
MacPorts ports tree · api.github.com · MacPorts ports tree: databases/litecli/Portfile from https://api.github.com/repos/macports/macports-ports/git/trees/master?recursive=1

package graph

Links come from deterministic package relationships, av.db category and tag curation, ecosystem matches, and package hub membership.

source trail

Generated from repository data

This page is generated by av-web from the private package SQLite artifact built by scripts/generate-pkg-sqlite.py.

Used sources

  • Geiger risk classifier
  • cross-ecosystem install command graph
  • curated configuration and credential file locations
  • curated package history
  • external package-manager database matches
  • pkg.so package database
  • pkgdb category and tag curation