querypie-cli

Query QueryPie databases from the terminal with webview authentication.

Quick Start

querypie --host querypie.example.com auth login
querypie --host querypie.example.com connection list
querypie --host querypie.example.com query -c '<connection>' 'select 1;'

Installation

Linux / macOS:

curl -fsSL https://raw.githubusercontent.com/sudosubin/querypie-cli/main/scripts/install.sh | sh

Windows (PowerShell):

powershell -c "irm https://raw.githubusercontent.com/sudosubin/querypie-cli/main/scripts/install.ps1 | iex"

The installer downloads the matching binary from GitHub Releases, verifies its checksum, and installs it (Linux/macOS: ~/.local/bin, Windows: %LOCALAPPDATA%\querypie-cli\bin). Set QUERYPIE_VERSION to pin a release or QUERYPIE_INSTALL_DIR to change the location:

curl -fsSL https://raw.githubusercontent.com/sudosubin/querypie-cli/main/scripts/install.sh | QUERYPIE_VERSION=v0.1.1 sh

Or install with Cargo:

cargo install querypie-cli

Build from source:

cargo build --release

querypie uses a WebView for login: Linux needs WebKitGTK (libwebkit2gtk-4.1) at runtime, and Windows needs the Edge WebView2 Runtime (preinstalled on current Windows).

Commands

Examples

querypie --host querypie.example.com connection list
querypie --host querypie.example.com database list -c '<connection>'
querypie --host querypie.example.com query -c '<connection>' --db example_db 'select 1;'
querypie --host querypie.example.com query -c '<connection>' --db example_db --limit 100 'select * from users;'
querypie --host querypie.example.com table describe -c '<connection>' --db example_db users
querypie --host querypie.example.com table list -c '<connection>' --db example_db

Use --output json for machine-readable output.

querypie --host querypie.example.com connection list --output json

Authentication

• Login uses a dedicated Tauri WebView.
• httpOnly QueryPie cookies stay in the WebView cookie store.
• Access token refresh runs automatically in the background.
• If refresh fails for a previously authenticated host, commands open the login WebView and continue after login.
• If no login exists, commands exit with an auth error.

Configuration

Default path:

~/.config/querypie-cli/config.json

Example:

{
  "host": "querypie.example.com",
  "connection": "example-main",
  "database": "example_db"
}

CLI flags override config values.

Shell Completions

Generate completions for your shell:

querypie completion bash > querypie.bash
querypie completion elvish > querypie.elv
querypie completion fish > ~/.config/fish/completions/querypie.fish
querypie completion powershell > _querypie.ps1
querypie completion zsh > "${fpath[1]}/_querypie"

Completions can query your logged-in QueryPie host for connection, engine, database, schema, and table candidates. If authentication or network access is unavailable, dynamic candidates are skipped silently.

Output

• --color auto|always|never: control ANSI color (auto colors terminal output unless NO_COLOR is set)
• --limit <N>: maximum query rows to fetch, defaults to 1000 and must be at least 1
• --no-truncate: do not shorten long table cells
• --output json: raw JSON output
• --output text: default human-readable output
• QUERYPIE_NO_TRUNCATE=1: disable truncation globally

NULL values are rendered distinctly in colored text output. JSON output never includes ANSI escape sequences. Text query output reports (N rows, limit reached) when the result reaches the configured row limit. JSON query output includes limit and limit_reached fields alongside columns and rows.

How It Works

1. auth login opens QueryPie in a Tauri WebView.
2. The CLI reads httpOnly cookies through the same WebView profile.
3. API calls use QueryPie's gRPC-Web endpoints.
4. Expired access tokens are refreshed through the WebView cookie store.
5. Database sessions are cached under ~/.cache/querypie-cli.

Troubleshooting

Check auth:

querypie --host querypie.example.com auth status

Clear cached database sessions:

querypie --host querypie.example.com session clear

Development

cargo build --all-features
cargo clippy --all-targets --all-features -- -D warnings
cargo fmt --all -- --check
cargo test --all-features

License

MIT, see LICENSE.