riii111 / sabiql
A fast, driver-less TUI to browse, query, and edit PostgreSQL databases
AI Architecture Analysis
This repository is indexed by RepoMind. By analyzing riii111/sabiql in our AI interface, you can instantly generate complete architecture diagrams, visualize control flows, and perform automated security audits across the entire codebase.
Our Agentic Context Augmented Generation (Agentic CAG) engine loads full source files into context on-demand, avoiding the fragmentation of traditional RAG systems. Ask questions about the architecture, dependencies, or specific features to see it in action.
Embed this Badge
Showcase RepoMind's analysis directly in your repository's README.
Repository Overview (README excerpt)
Crawler viewsabiql A fast, driver-less TUI to browse, query, and edit PostgreSQL databases — no drivers, no setup, just . Concept > Vim-first · Safe by design · Oil-and-vinegar UI · Fast and lightweight sabiql wraps your existing CLI. No Rust database drivers, no connection pools, no extra dependencies. Point it at your database and get a full-featured TUI. Your config, , SSL setup all just work. Inspired by oil.nvim's "oil and vinegar" philosophy: UI elements appear only when needed, never occupying your screen permanently. Vim-native keybindings ( , , ) let you navigate and edit without leaving your muscle memory. Destructive operations are guarded. Inline edits and row deletions always show a preview modal before touching your data. Read-only mode ( ) goes further — block all writes at the PostgreSQL session level with a single keystroke. Built in Rust for minimal memory footprint and near-zero idle CPU. A full-featured alternative to GUI tools like DBeaver or DataGrip, without ever leaving the terminal. Features Core • **Read-Only Mode** ( ) — Toggle safe-browse mode; writes are blocked at both app and DB session level • **SQL Modal** ( ) — Ad-hoc queries with auto-completion for tables, columns, and keywords; browse past results with ; recall previous queries with • **ER Diagram** ( ) — Generate relationship diagrams via Graphviz, opened instantly in your browser • **Inspector Pane** ( ) — Column details, types, constraints, and indexes for any table Editing • **Inline Cell Editing** ( in Result) — Edit cells in-place with a guarded UPDATE preview before committing • **Row Deletion** ( in Result) — DELETE with mandatory preview; risk level color-coded (yellow/orange/red) • **Yank** ( ) — Copy any cell value to clipboard • **CSV Export** ( ) — Export query results to a CSV file Navigation • **Fuzzy Search** ( ) — Incremental table filtering • **Focus Mode** ( ) — Expand any pane to full screen • **Command Palette** ( ) — Searchable command list Installation Quick Start On first run, enter your connection details — saved to . Press for help. Requirements • CLI (PostgreSQL client) • Graphviz (optional, for ER diagrams): Environment Variables | Variable | Description | |----------|-------------| | | Browser for ER diagrams (e.g., , ). macOS uses ; falls back to OS default. | Roadmap • [x] Connection management UI • [x] ER diagram generation • [x] Read-only mode ( ) • [x] SQL modal with DML/DDL safety guardrails • [x] Query history persistence & fuzzy search • [x] CSV export & clipboard yank • [ ] JSON/JSONB support (tree view, editing, validation) • [ ] Neovim integration ( ) • [ ] Zero-config connection (env vars, , URI auto-detect) • [ ] EXPLAIN workflow (plan tree view & comparison) • [ ] Google Cloud SQL / AlloyDB support • [ ] MySQL support Have a feature request? Open an issue feedback is welcome! License MIT — see LICENSE.