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

Project links

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.

Sources

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 post-install hook is recorded in formula metadata.
Homebrew bottle metadata is available for 6 platform targets.
Installs with 4 runtime dependencies.
Build metadata lists 1 build dependencies.

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

Command	Kind	Exposure	Note
`litecli`	cli	global executable

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-07-08

manager version1.17.1

manager updated2026-06-15

local dataok

upstreamnot checked

latest detectednot detected

https://litecli.com

infoRelease/tag comparison is only available for GitHub repositories.https://litecli.comnone confidence

install metadata

Package metadata

Package key	brew:litecli
Version	1.17.1
Package manager	Homebrew
Package manager page	https://formulae.brew.sh/formula/litecli
Homepage	https://litecli.com
Repository	https://github.com/dbcli/litecli
Upstream docs	https://litecli.com/
License	BSD-3-Clause
Source archive	https://files.pythonhosted.org/packages/e3/d5/afec99cc3eaba96214d77e76438d7fe5e6ea54704b0e47dd97d9696ccd6c/litecli-1.17.1.tar.gz
Last updated	2026-06-15T10:20:20-04:00
Pulse	updated
Dependencies	certifi, libyaml, pydantic, python@3.14
Build dependencies	rust
Uses from macOS	sqlite
Bottle	available (on arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux)
Homebrew post-install	not defined
Service	none declared

registry facts

Source database details

Source Database	Homebrew formula API
Tap	homebrew/core
Full Name	litecli
Version Scheme	0
Revision	2
Bottle Stable Root URL	https://ghcr.io/v2/homebrew/core
Deprecated	no
Disabled	no
Keg Only	no
URL Keys	stable

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-2.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/e5ca8ce900cd68f5419e1c39ae517343100b306336cbaeb70a3c153121d95094-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.

Combined YAML source

View the package source record on GitHub.

combined/litecli.yml

Used sources

Geiger risk classifier
Nucleus package database
av.db category and tag curation
cross-ecosystem install command graph
curated configuration and credential file locations
curated package history
external package-manager database matches
package relationship graph
package version freshness
package-page enrichment

Install litecli with Homebrew, apk, apt, dnf, MacPorts, Nix

Additional install commands

macOS

Linux

Package summary

Project links

Commands and aliases

Project history and usage

Project history

Adoption history

How it is used

Why package nerds care

Timeline

Related projects

Sources

No protected-tool coverage found yet

Install behavior

Recommended review

Configuration and credential file locations

Configuration files

Installed executables

Version and freshness

Package metadata

Source database details

Other package-manager records

Internal package links

Topical hubs

Related tools

Same workflow

Agent security guides

Generated from repository data

Combined YAML source

Used sources