// the find
Maxteabag/sqlit
A user friendly TUI for SQL databases. Written in python. Supports SQL server, Mysql, PostreSQL, SQLite, Turso and more.
sqlit is a terminal UI for querying databases, built on Python's Textual framework. It supports an absurdly wide range of databases (30+) with a connection manager, vim keybindings, and Docker auto-discovery. Aimed at developers who want something between a raw psql prompt and a full GUI like DBeaver.
The on-demand driver installation is genuinely good UX — instead of failing cryptically when psycopg2 is missing, it detects the gap and walks you through the fix. Docker container auto-discovery is a real time-saver for local dev workflows. OS keyring integration for credential storage (macOS Keychain, Windows Credential Locker) is the right call over plaintext config files. The `--mock=sqlite-demo` flag lets you evaluate the UI without wiring up a database first, which lowers the friction to try it.
The breadth of 30+ database adapters is a maintenance liability — each adapter is a different Python package with its own quirks, and the quality of support almost certainly varies wildly across them. There's no mention of multi-result-set handling, transactions, or query explain plans, which means DBAs will hit a ceiling fast. Being Python means the startup time will always trail Go-based alternatives like lazysql. The README claims 'load millions of rows' but gives no detail on how pagination or virtual scrolling actually works — that claim needs scrutiny before you trust it on a production table.