GitHub - xo/usql: Universal command-line interface for SQL databases
Universal command-line interface for SQL databases - xo/usql
Python Database TUI
Summary
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
Context
Audience
Developers, data engineers, DevOps or SRE professionals, and anyone who prefers terminal‑based workflows for querying SQL databases
DomainDatabase Administration
Formatopen source command‑line application
Accessfree open source on GitHub (pip install)
Topics
Related
psql, MySQL clientpgcli, myclilazygitDBeaver, TablePlusODBC/JDBC drivers