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]
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 QUERY
Execute query and exit.--table
Output as table.--csv
Output as CSV.-D FILE
Execute commands from file.--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.