sqli
| Crates.io | sqli |
| lib.rs | sqli |
| version | 1.0.3 |
| created_at | 2025-02-18 00:52:36.792097+00 |
| updated_at | 2025-03-02 03:51:49.892763+00 |
| description | A command line tool for interacting with Postgres databases |
| homepage | https://github.com/jcserv/sqli |
| repository | https://github.com/jcserv/sqli |
| max_upload_size | |
| id | 1559491 |
| size | 389,650 |
Jarrod Servilla (jcserv)
documentation
README
sqli
sqli (as in, "sql" + "cli" = "sqli") is a simple & sleek SQL client, used as a terminal UI or as a command line tool, to help you query your Postgres database!
heavily inspired by tools like posting, curl, and bruno.
features 🚀
- 📊 view query results directly in the terminal
- or pipe it into other tools like
jq
- or pipe it into other tools like
- 🧪 simple syntax for ad-hoc queries from the terminal
- 🔄 save and reuse database connections
- 📁 collections are stored in your local file system
- repo-level collections are stored in
./sqli- add these to your source control to share with others! - user-level settings & collections are stored in
<CONFIG_DIR>/sqli
- repo-level collections are stored in
- 🦀 written in rust btw 😎
installation 📦
homebrew
brew tap jcserv/cask
brew install sqli
cargo
cargo binstall sqli (cargo-binstall)
or
cargo install sqli
usage ⚙️
tui 🖥️
sqli- open the TUI
Keybindings:
| Key | Action |
|---|---|
| Tab | Switch between panels (when in nav mode) |
| Arrow keys | Switch between panels (when in nav mode) |
| Space/Enter | Focus on a pane |
| Ctrl+N | Create new file/folder |
| Ctrl+E | Edit selected file/folder |
| Ctrl+S | Save current file |
| Ctrl+Space | Run SQL query |
| Esc | Exit edit mode |
| Ctrl+C | Quit application |
cli ▶️
- ad-hoc queries:
sqli query --url postgres://user:password@host:port/database --sql "SELECT * FROM table;"
- configure a connection:
sqli config set --name local --url postgres://user:password@host:port/database
- query using a pre-configured connection:
sqli query --conn local --sql "SELECT * FROM table;"
- query using a file:
sqli query --conn local --sql path/to/file.sql