sqlit
Lazygit-style TUI for SQL databases
TLDR
Launch the interactive TUI
$ sqlit
Connect to a saved connection$ sqlit -c "[MyConnection]"
Run a query from the CLI$ sqlit query -c "[MyConnection]" -q "[SELECT * FROM Users]" --format csv
SYNOPSIS
sqlit [-c connectionname_]sqlit query [-c connectionname] [**-q** query] [**--format** format_]
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.
PARAMETERS
-c CONNECTION
Connect using a saved connection name.-q QUERY
SQL query to execute (used with the query subcommand).--format FORMAT
Output format for query results: table, csv, json (used with the query subcommand).
INSTALL
yay -S sqlit
HISTORY
sqlit was created by Maxteabag (Peter Adams) and is written in Python.
