litecli

SQLite CLI with auto-completion

TLDR

Connect to database

$ litecli [database.db]

Create new database

$ litecli [new.db]

Execute query

$ litecli [database.db] -e "[SELECT * FROM table]"

Use specific output format

$ litecli [database.db] --table

Connect to in-memory database

$ litecli :memory:

Run SQL file

$ litecli [database.db] < [script.sql]

litecli is a SQLite CLI with auto-completion. It provides syntax highlighting and intelligent suggestions.The tool offers a better interactive experience than sqlite3 with multiline editing and history.

PARAMETERS

DATABASE

SQLite database file path.

-e, --execute QUERY

Execute query and exit.

--table

Output as table format.

--csv

Output as CSV.

--auto-vertical-output

Automatically switch to vertical output for wide rows.

-l, --list-dsn

List configured DSNs.

--llm-api-key KEY

API key for AI-assisted SQL features.

--help

Display help information.

INSTALL

sudo dnf install litecli

sudo apk add litecli

brew install litecli

nix profile install nixpkgs#litecli

CAVEATS

Python-based. Requires pip install. For SQLite databases only.

HISTORY

litecli was inspired by pgcli and mycli, bringing similar enhanced CLI features to SQLite.