litecli
SQLite CLI with auto-completion
TLDR
Connect to database
$ litecli [database.db]
Create new databasecopy
$ litecli [new.db]
Execute querycopy
$ litecli [database.db] -e "[SELECT * FROM table]"
Use specific output formatcopy
$ litecli [database.db] --table
Connect to in-memory databasecopy
$ litecli :memory:
Run SQL filecopy
$ litecli [database.db] < [script.sql]
copy
SYNOPSIS
litecli [options] [database]
DESCRIPTION
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.
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.