sabiql

A fast, driver-less TUI to browse, query, and edit PostgreSQL databases — no drivers, no setup, just psql.

Concept

sabiql wraps your existing psql CLI — no Rust database drivers, no connection pools, no extra dependencies. Point it at your database and get a full-featured TUI with vim-like keybindings.

Built in Rust for minimal memory footprint and near-zero idle CPU — no runtime, no GC pauses.

Features

https://github.com/user-attachments/assets/7d2c34ae-94b7-4746-86a5-6aadd0a4ab45

Core

• SQL Modal (s) — Ad-hoc queries with auto-completion for tables, columns, and keywords
• ER Diagram (e) — Generate relationship diagrams via Graphviz, opened instantly in your browser
• Inspector Pane (2) — Column details, types, constraints, and indexes for any table

Editing

• Inline Cell Editing (e in Result) — Edit cells in-place with a guarded UPDATE preview before committing
• Row Deletion (dd in Result) — DELETE with mandatory preview; risk level color-coded (yellow/orange/red)
• Yank (y) — Copy any cell value to clipboard

Navigation

• Fuzzy Search (/) — Incremental table filtering
• Focus Mode (f) — Expand any pane to full screen
• Command Palette (Ctrl+K) — Searchable command list

Installation

curl -fsSL https://raw.githubusercontent.com/riii111/sabiql/main/install.sh | sh

Or via Homebrew:

brew install riii111/sabiql/sabiql

Or from source:

cargo install --git https://github.com/riii111/sabiql

Quick Start

sabiql

On first run, enter your connection details — saved to ~/.config/sabiql/connections.toml. Press ? for help.

Keybindings

Requirements

• psql CLI (PostgreSQL client)
• Graphviz (optional, for ER diagrams): brew install graphviz

Environment Variables

Roadmap

• Connection UI
• Focused ER diagrams
• Expanded viewport / horizontal scrolling
• Google Cloud SQL / AlloyDB support
• MySQL support

License

MIT — see LICENSE.