Linux command
sqlit 命令
文本
复制后可按需替换文件名、目录或参数。
常用示例
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
说明
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.
参数
- -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).
FAQ
What is the sqlit command used for?
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.
How do I run a basic sqlit example?
Run `sqlit` in a terminal, then adjust file names, paths, flags, or remote targets for your system.
What does -c _CONNECTION_ do in sqlit?
Connect using a saved connection name.