Sqlit – A lazygit-style TUI for SQL databases
4 days ago
- #TUI
- #SQL
- #Database
- sqlit is a lightweight TUI for SQL databases, designed for quick and easy querying without heavy GUI applications.
- Supports multiple databases including Postgres, MySQL, SQL Server, SQLite, Supabase, Turso, and more.
- Features include a connection manager UI, SSH tunnels, Vim-style editing, query history, and SQL autocomplete.
- No CLI config needed; simply run `sqlit` and pick a connection.
- Includes themes like Tokyo Night and Nord, and auto-detects/installs necessary ODBC drivers.
- Allows for CLI mode for scripting and AI agents, with output formats like CSV and JSON.
- Credentials are stored securely in `~/.sqlit/` with restricted permissions.
- Inspired by lazygit, sqlit emphasizes intuitive use with on-screen keybindings and no need for external documentation.
- Pre-installation of database-specific Python packages is optional; sqlit prompts for installation as needed.