LinuxCommandLibrary

sqlit

Lazygit-style TUI for SQL databases

TLDR

Launch the interactive TUI
$ sqlit
copy
Connect to a saved connection
$ sqlit -c "[MyConnection]"
copy
Run a query from the CLI
$ sqlit query -c "[MyConnection]" -q "[SELECT * FROM Users]" --format csv
copy

SYNOPSIS

sqlit [-c connectionname_]

DESCRIPTION

sqlit is a lightweight, keyboard-driven TUI for connecting to and querying SQL databases from the terminal. It supports 20+ database systems including PostgreSQL, MySQL, SQLite, DuckDB, BigQuery, ClickHouse, and Snowflake. Features include query history, autocomplete, Vim-style editing, SSH tunneling, Docker container auto-discovery, and secure credential storage.

HISTORY

sqlit was created by Maxteabag (Peter Adams) and is written in Python.

SEE ALSO

litecli(1), harlequin(1), usql(1)

> TERMINAL_GEAR

Curated for the Linux community

Copied to clipboard