id = "litecli"
name = "LiteCLI"
homepage = "https://litecli.com/config/"
description = "A SQLite command-line client with auto-completion and syntax highlighting."
executables = ["litecli"]

[dotfiles]

# LiteCLI's official configuration page documents ~/.config/litecli/config on
# Unix and the dbcli path below on Windows; it is an INI settings file.
# https://litecli.com/config/
paths = [
  "~/.config/litecli/config",
  "%LOCALAPPDATA%/dbcli/litecli/config",
]
secret = []
side_effect = false

[commands]
format = 1
label = "Open SQLite database"
description = "Open a SQLite database in litecli, optionally running one statement and quitting. Config file, prompt and logging options are mostly left out."
quality = "ai-draft"
parser = { end_of_options = "--", interleave = "permute", long_equals = true, short_attached = true, short_bundles = false }

[[commands.source]]
id = "help"
kind = "help"
url = "https://github.com/dbcli/litecli/blob/main/litecli/main.py"
revision = "2026-10-27"
evidence = """
@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_flag=True, help="Automatically switch to vertical output mode if the result is wider than the terminal width.")
@click.option("-l", "--logfile", help="Log every query and its results to a file.")
@click.argument("database", default="", nargs=1)
"""

[[commands.field]]
id = "database"
label = "Database file"
type = "path"
position = 0
path = { kind = "file", role = "input", must_exist = false }
sources = ["help"]

[[commands.field]]
id = "execute"
label = "Run statement and quit"
type = "string"
option = ["--execute", "-e"]
sources = ["help"]

[[commands.field]]
id = "table"
label = "Table output (batch)"
type = "boolean"
option = ["--table", "-t"]
sources = ["help"]

[[commands.field]]
id = "csv"
label = "CSV output (batch)"
type = "boolean"
option = ["--csv"]
sources = ["help"]

[[commands.field]]
id = "auto_vertical"
label = "Auto vertical output"
type = "boolean"
option = ["--auto-vertical-output"]
sources = ["help"]

[[commands.field]]
id = "logfile"
label = "Query log file"
type = "path"
option = ["--logfile", "-l"]
path = { kind = "file", role = "output", must_exist = false }
effect = "overwrite"
sources = ["help"]

[[commands.task]]
id = "open"
label = "Open database"
fields = ["database"]
required = ["database"]

[[commands.task]]
id = "query"
label = "Run one query"
fields = ["database", "execute", "table"]
required = ["database", "execute"]

[[commands.group]]
id = "basic"
label = "Basic"
fields = ["database", "execute", "table", "csv"]

[[commands.group]]
id = "advanced"
label = "Advanced"
fields = ["auto_vertical", "logfile"]