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
• 🧪 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
• 🦀 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 🖥️

1. sqli - open the TUI

Keybindings:

cli ▶️

1. ad-hoc queries:

• sqli query --url postgres://user:password@host:port/database --sql "SELECT * FROM table;"

2. configure a connection:

• sqli config set --name local --url postgres://user:password@host:port/database

3. query using a pre-configured connection:

• sqli query --conn local --sql "SELECT * FROM table;"

4. query using a file:

• sqli query --conn local --sql path/to/file.sql

references 📚

• posting
• curl
• bruno