GitHub - pgrundev/pgterm: Postgres Terminal
Postgres Terminal. Contribute to pgrundev/pgterm development by creating an account on GitHub.
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)
Source Overview
Sqlit is a lightweight terminal UI client for SQL databases, written in Python, that connects to Postgres, MySQL, SQL Server, SQLite, MariaDB, Oracle, DuckDB, CockroachDB, Supabase, and Turso.
It provides a connection manager, SSH tunneling, vim-style editor, query history, schema browsing, SQL autocomplete, themes, and a CLI mode for scripting. Installation is via pip, configuration is stored in a local directory, and connections/queries can be managed both interactively in the TUI and through command-line commands.
Topics
Related
psql, MySQL clientpgcli, myclilazygitDBeaver, TablePlusODBC/JDBC drivers
