LiteCLI

litecli

A SQLite command-line client with auto-completion and syntax highlighting.

Runs as litecli|macOS, Linux, Windows|litecli.com

Open form in Otty otty.toml

Command form

ai-draft · 2 tasks · 6 fields

Open a SQLite database in litecli, optionally running one statement and quitting. Config file, prompt and logging options are mostly left out.

Opens the form; the finished command lands at your prompt, unrun

Run in Otty

otty gui litecli

Open SQLite databaseExample values, fixed in this page — nothing here reaches a terminal

Basic

Database file*

file

TasksEach one presets the form for one job

Open database

database

Run one query

databaseexecutetable

ParametersOnly these flags are editable in the form

Database file

path · positional 0

Run statement and quit

string

--execute-e

Table output (batch)

boolean

--table-t

CSV output (batch)

boolean

--csv

Auto vertical output

boolean

--auto-vertical-output

Query log file

path

--logfile-l

SourcesEvery flag above is checked against these

help

@click.option("-D", "--database", "dbname", help="Database to use.") @click.option("-t", "--table", is_flag=True, help="Display batch output in table format.") @click.option("--csv", is_flag=True, help="Display batch output in CSV format.") @click.option("-e", "--execute", type=str, help="Execute command and quit.") @click.option("--auto-vertical-output", is…

help2026-10-27

github.com

Before it fills your prompt, Otty checks the installed litecli against its version. A form that does not match your version is not offered.