sqlit is an open‑source, terminal‑based UI for interacting with a wide range of SQL databases. Built in Python, it offers connection management, SSH tunneling, vim‑style editing, query history, schema browsing and autocomplete, all configurable via pip installation.
Highlights
Supports many databases out of the box: PostgreSQL, MySQL, SQL Server, SQLite, MariaDB, Oracle, DuckDB, CockroachDB, Supabase, Turso, etc.
Fully keyboard‑driven with a Lazygit‑style interface, including connection manager UI and built‑in SSH tunnels.
Features vim‑style modal editing, context‑aware help, theming (Tokyo Night, Nord, …), and automatic ODBC driver detection.
Persists query history per connection; searchable, sortable, and available in both interactive TUI and CLI modes.
Easy installation via `pip install sqlit-tui`; no external configuration required to start querying.
auto-generated
Maxteabag · via GitHub
Context
Audience
Developers, data engineers, DevOps or SRE professionals, and anyone who prefers terminal‑based workflows for querying SQL databases